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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly