Re: Exclusive row locks not release

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Exclusive row locks not release
Дата
Msg-id 26344.1327038039@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Exclusive row locks not release  (Mark van Leeuwen <markvl@internode.on.net>)
Ответы Re: Exclusive row locks not release
Numerous prepared transactions?
Список pgsql-general
Mark van Leeuwen <markvl@internode.on.net> writes:
> I have a case where exclusive row locks have been placed on a table and
> I don't what process has the locks or how they might be released.

> The locks are still there even after I have restarted the database.

Uncommitted prepared transaction, perhaps?  Look into pg_prepared_xacts.

            regards, tom lane

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