LOCK ROW SHARE MODE

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: LOCK ROW SHARE MODE
Date: 2001-10-24 02:56:12
Message-ID: ECEHIKNFIMMECLEBJFIGCEFECCAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

In the LOCK TABLE docs it documents the SELECT...FOR UPDATE as follows:

----
ROW SHARE MODE
Note: Automatically acquired by SELECT...FOR UPDATE. While it is a shared
lock, may be upgraded later to a ROW EXCLUSIVE lock.

Conflicts with EXCLUSIVE and ACCESS EXCLUSIVE lock modes.
----

However, if I begin a transaction in one window and SELECT...FOR UPDATE a
row, then begin a transaction in another window and SELECT ... FOR UPDATE
the same row, the second SELECT..FOR UPDATE blocks until the first
transactions is committed or rolled back.

So, shouldn't this mean that the ROW SHARE mode should in fact be documented
to conflict with itself??? And with this behaviour is it really a shared
lock? I don't get it!

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-10-24 04:34:17 Re: LOCK ROW SHARE MODE
Previous Message David Eduardo Gomez Noguera 2001-10-24 01:36:50 Re: Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!!