Re: Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock
Дата
Msg-id 4C4A8385.2010900@postnewspapers.com.au
обсуждение исходный текст
Ответ на Re: Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
On 24/07/10 00:00, Merlin Moncure wrote:

> I generally agree with your statements, but there is one correction to
> make: advisory locks are not released at end of transaction.

Argh. Good point. Every other kind of lock is, but advisory locks are
only released when the connection is closed or the lock is explicitly
released.

Thanks for the correction.

--
Craig Ringer

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Frankel
Дата:
Сообщение: Re: prepared statements
Следующее
От: Allan Kamau
Дата:
Сообщение: Efficiently obtaining (any) one record per group.