Ingo, On Wed, Mar 4, 2009 at 8:49 AM, Ingo Weiss <i...@metaversum.com> wrote: > 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?
Are you accessing the view and doing the inserts in separate transactions? -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org