Re: ExclusiveLock and Python

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ExclusiveLock and Python
Дата
Msg-id 4197.1046441156@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ExclusiveLock and Python  ("Gaetano Mendola" <mendola@bigfoot.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Transaction isolation and UNION queries
Следующее
От: Laurette Cisneros
Дата:
Сообщение: Re: server won't shutdown