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

Поиск
Список
Период
Сортировка

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