Home > mailing lists

For update - Mailing list pgsql-sql

From	Ottó Havasvölgyi
Subject	For update
Date	January 16, 2006 15:59:43
Msg-id	34608c0c0601160859g4e077ad9g@mail.gmail.com Whole thread Raw
Responses	Re: For update (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List	pgsql-sql

Hello,

What does this do exactly:

select * from <ViewName> where <condition> for update;

Will be locked all the tuples in all tables it retrieves?

In 8.0.5 this did not work for me.

Thanks,

Otto

From: Jeff Boes
Date: 16 January 2006, 14:33:46
Subject: Re: psql client: technique for applying default values to :variables?

From: Andreas Seltenreich
Date: 16 January 2006, 16:02:38
Subject: Re: psql client: technique for applying default values to :variables?