List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:March 5 2009 8:02pm
Subject:Re: view doesn't refresh inside transaction
View as plain text  

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
> transaction?

Are you accessing the view and doing the inserts in separate transactions?

Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog:
Our Services:
view doesn't refresh inside transactionIngo Weiss4 Mar
  • Re: view doesn't refresh inside transactionBaron Schwartz5 Mar