Re: view doesn't refresh inside transaction

2009-03-05 Thread Baron Schwartz
Ingo, On Wed, Mar 4, 2009 at 8:49 AM, Ingo Weiss 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 tabl

view doesn't refresh inside transaction

2009-03-04 Thread Ingo Weiss
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