Home > mailing lists

Re: LOCK command inside a TRANSACTION - Mailing list pgsql-sql

From	Peter Eisentraut
Subject	Re: LOCK command inside a TRANSACTION
Date	April 3, 2007 13:57:46
Msg-id	200704031557.33680.peter_e@gmx.net Whole thread Raw
In response to	LOCK command inside a TRANSACTION (Carlos Santos <carloscompels@yahoo.com.br>)
List	pgsql-sql

Tree view

Am Dienstag, 3. April 2007 14:48 schrieb Carlos Santos:
> - if an user query a select on a table, the rows of the table in the result
> of this select can not be updated or deleted by another user until this one
> update, delete or discard the changes on those rows.

Sounds like SELECT FOR UPDATE.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-sql by date:

From: John Summerfield
Date: 03 April 2007, 13:53:03
Subject: Re: Using a variable as a view name in a select

From: Scott Marlowe
Date: 03 April 2007, 14:17:41
Subject: Re: Serial

Re: LOCK command inside a TRANSACTION - Mailing list pgsql-sql

Previous

Next