Detecting table/row locks

From: Joshua Daniel Franklin <joshua(at)iocc(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Detecting table/row locks
Date: 2002-11-27 15:26:52
Message-ID: Pine.LNX.4.44.0211270924260.29903-100000@iocc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is there a quick SQL way to check if a certain table
(or row) is locked?

I see that an UPDATE will just block until the previous
lock is removed.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Dan Jewett 2002-11-27 16:38:41 Re: Error when calling this function....
Previous Message Henshall, Stuart - Design & Print 2002-11-27 09:46:08 Re: Error when calling this function....