Re: lock status check - Mailing list pgsql-sql

From Christoph Haller
Subject Re: lock status check
Date
Msg-id 3EC4C339.6413076A@rodos.fzk.de
Whole thread Raw
In response to lock status check  (mixo <mixo@beth.uniforum.org.za>)
List pgsql-sql
>
> 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




pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: Testing castability of text to numeric
Next
From: mdc@keko.com.ar
Date:
Subject: installation problem