table locking and SELECT FOR UPDATE

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: table locking and SELECT FOR UPDATE
Date: 2005-07-11 22:10:23
Message-ID: 42D2EE4F.1090302@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How come when a share lock is held and update can't be done on the
table, but a SELECT FOR UPDATE can be done? I can't SELECT FOR UPDATE
the same row in two transactions, but I can SELECT FOR UPDATE a row that
I will won't be able to update because the other table is held in a
SHARE lock.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F. O'Connell 2005-07-11 22:16:12 Quoting $user as Parameter to SET
Previous Message Vivek Khera 2005-07-11 21:15:26 Re: PostgreSQL Scalability