On Wed, Mar 4, 2009 at 8:49 AM, Ingo Weiss <Ingo@stripped> 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
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