Re: LOCK command inside a TRANSACTION

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org, Carlos Santos <carlos(at)compels(dot)net>
Subject: Re: LOCK command inside a TRANSACTION
Date: 2007-04-03 13:57:33
Message-ID: 200704031557.33680.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Hilary Forbes 2007-04-03 14:14:22 Re: Using a variable as a view name in a select
Previous Message John Summerfield 2007-04-03 13:21:35 Re: Using a variable as a view name in a select