Re: Commit with wait event on advisory lock!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Commit with wait event on advisory lock!
Дата
Msg-id 3505513.1737506928@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: Commit with wait event on advisory lock!  (<msalais@msym.fr>)
Ответы RE: Commit with wait event on advisory lock!
Список pgsql-admin
<msalais@msym.fr> writes:
> How a COMMIT statement could be blocked by a lock whatever the kind of the lock could be. COMMIT releases locks. How
couldit be blocked by a lock?! 

There could be pre-commit actions (for example, firing deferred
triggers) that need to take locks the transaction didn't already
hold.  You've provided no details that would let anyone diagnose
the exact cause, though.

            regards, tom lane



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