Re: For update

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