Postgres Pro
Downloads
Home   >   mailing lists

SELECT .. FOR UPDATE: find out who locked a row - Mailing list pgsql-general

From Enrico Thierbach
Subject SELECT .. FOR UPDATE: find out who locked a row
Date
Msg-id E269BF34-4CE1-47EC-8A80-F18DE55E2BEF@open-lab.org
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view

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 by date:

Previous
From: Raghavendra Rao J S V
Date:
Subject: ERROR: right sibling's left-link doesn't match: block 5 links to 8instead of expected 2 in index "pg_toast_2619_index"
Next
From: pinker
Date:
Subject: Re: SELECT .. FOR UPDATE: find out who locked a row