Lock table, Select for update and Serialization error - Mailing list pgsql-general

From sudhir
Subject Lock table, Select for update and Serialization error
Date
Msg-id 4651E1C8.2040902@cse.iitb.ac.in
Whole thread Raw
List pgsql-general
Hi,

As per postgres docs, 'Select for update' is used to obtain row level
locks where as 'lock table' is used to obtain table level locks.

Under serializable isolation level, select for update gives error if
rows selected have been modified concurrently.
but 'lock table' does not give such error even though some of the rows
in the table are modified by concurrent transaction.

Is this the expected behavior?






pgsql-general by date:

Previous
From: "CAJ CAJ"
Date:
Subject: Re: Perl + Determine active connections on Pg 8.0.x and Pg 8.2.x
Next
From: PFC
Date:
Subject: feature suggestions