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

["Enrico Thierbach" <eno@xxxxxxxxxxxx>]

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