Re: For update

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?

-- 
Alvaro Herrera                           Developer, http://www.PostgreSQL.org
"MySQL is a toy compared to PostgreSQL."             (Randal L. Schwartz)
(http://archives.postgresql.org/pgsql-general/2005-07/msg00517.php)