SELECT .. FOR UPDATE: find out who locked a row

Поиск
Список
Период
Сортировка
От Enrico Thierbach
Тема SELECT .. FOR UPDATE: find out who locked a row
Дата
Msg-id E269BF34-4CE1-47EC-8A80-F18DE55E2BEF@open-lab.org
обсуждение исходный текст
Ответы Re: SELECT .. FOR UPDATE: find out who locked a row  (pinker <pinker@onet.eu>)
Re: SELECT .. FOR UPDATE: find out who locked a row  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: SELECT .. FOR UPDATE: find out who locked a row  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general

Hello,

I am using SELECT * FROM queue ... FOR UPDATE SKIP LOCKED to implement a queueing system.

Now I wonder if it is possible, given the id of one of the locked rows in the queue table, to find out which connection/which transaction owns the lock.

Any help is greatly appreciated.

Thank you,
/eno

--
me at github: https://github.com/radiospiel
me at linked.in: https://www.linkedin.com/in/radiospiel

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

Предыдущее
От: Raghavendra Rao J S V
Дата:
Сообщение: ERROR: right sibling's left-link doesn't match: block 5 links to 8instead of expected 2 in index "pg_toast_2619_index"
Следующее
От: pinker
Дата:
Сообщение: Re: SELECT .. FOR UPDATE: find out who locked a row