Re: ExclusiveLock and Python - Mailing list pgsql-admin

From Tom Lane
Subject Re: ExclusiveLock and Python
Date
Msg-id 4197.1046441156@sss.pgh.pa.us
Whole thread Raw
In response to ExclusiveLock and Python  ("Gaetano Mendola" <mendola@bigfoot.com>)
List pgsql-admin
"Michael A. Schulte" <michael.schulte@sun.com> writes:
> Tom Lane wrote:
>> Offhand I think this is only used to implement waits associated with
>> SELECT FOR UPDATE row locking --- all other locks are on tables or
>> table-like objects.

> What about two processes updating the same row?

Right, that case is also a row lock.

> I thougth
> PostGres locks the row in this case and this would also
> be reflected as an entry in pg_locks with mode
> ExclusiveLock.

There's no pg_locks entry for a row lock.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Transaction isolation and UNION queries
Next
From: Laurette Cisneros
Date:
Subject: Re: server won't shutdown