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) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
