From: Ingo Weiss (Ingometaversum.com)
Date: Wed Mar 04 2009 - 07:49:55 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi all,

I have a view that is joining two base tables. I can update through
the view, but insert only through the base tables. Now I am having the
problem that seems to boil down to the following: When I insert into
the base tables inside a transaction, the view doesn't seem to update.
Only after the transaction is committed does the row appear in the
view. Now I would like to avoid having to commit the transaction at
that point. Is there any way to force a view to refresh inside a
transaction?

Thanks for any hint!
Ingo

Metaversum GmbH
Rungestr. 20 - 10179 Berlin - Germany
Geschaeftsfuehrer: Jochen Hummel, Dr. Mirko Caspar
Amtsgericht Berlin Charlottenburg HRB 99412 B
CONFIDENTIALITY NOTICE: The information contained in this communication is confidential to the sender, and is intended only for the use of the addressee. Unauthorized use, disclosure or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately at the contact numbers or addresses noted herein.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]