Re: pg_advisory_lock(bigint) vs. LOCK TABLE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_advisory_lock(bigint) vs. LOCK TABLE
Дата
Msg-id 10590.1216359637@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_advisory_lock(bigint) vs. LOCK TABLE  (Volkan YAZICI <yazicivo@ttmail.com>)
Список pgsql-sql
Volkan YAZICI <yazicivo@ttmail.com> writes:
> On Thu, 17 Jul 2008, Alvaro Herrera <alvherre@commandprompt.com> writes:
>> They are two different lock spaces.  pg_advisory_lock does not conflict
>> with regular system locks, whereas LOCK TABLE does.

> Is this documented in somewhere? I couldn't figure out that from the
> documentation.

Advisory locks are defined as locking application-defined identifiers.
Why would you expect them to conflict with system locks, and what would
be the relationship exactly?
        regards, tom lane


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

Предыдущее
От: Volkan YAZICI
Дата:
Сообщение: Re: pg_advisory_lock(bigint) vs. LOCK TABLE
Следующее
От: Lennin Caro
Дата:
Сообщение: Re: How to GROUP results BY month