On Mon, Jan 16, 2006 at 02:05:15PM -0300, Alvaro Herrera wrote:
> Ottó Havasvölgyi wrote:
> > What does this do exactly:
> >
> > select * from <ViewName> where <condition> for update;
> >
> > Will be locked all the tuples in all tables it retrieves?
>
> Yes.
>
> > In 8.0.5 this did not work for me.
>
> How did it not work? Was any error message emitted? What is the view
> definition?
I wonder if "not work" means "didn't lock the rows" and the cause
is simply not having a surrounding transaction.
--
Michael Fuhr