Re: lock status check

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Cc: mixo(at)beth(dot)uniforum(dot)org(dot)za
Subject: Re: lock status check
Date: 2003-05-16 10:53:45
Message-ID: 3EC4C339.6413076A@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message mdc 2003-05-16 14:02:40 installation problem
Previous Message Christoph Haller 2003-05-16 09:43:22 Re: Testing castability of text to numeric