Postgres Pro
Downloads
Home   >   mailing lists

Thread: lock status check

lock status check

From
mixo
Date:
Is it possible to check if a row is currently locked for update?

Re: lock status check

From
Christoph Haller
Date:
>
> Is it possible to check if a row is currently locked for update?
>
Check the system view "pg_catalog.pg_locks".
Should tell you about held locks.

Regards, Christoph