Re: Table locks - Mailing list pgsql-general

From Tom Lane
Subject Re: Table locks
Date
Msg-id 10235.970776311@sss.pgh.pa.us
Whole thread Raw
In response to Table locks  ("Dale Anderson" <danderso@crystalsugar.com>)
Responses Re: Table locks  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
"Dale Anderson" <danderso@crystalsugar.com> writes:
>     Is there any way to view the locks being held on a table??

There is not any good way --- lock.c has a routine called DumpAllLocks,
but it's not even compiled by default, let alone connected up to any
reasonable calling method.  I've been thinking for awhile that we
desperately need some simple way of dumping out the state of the lock
manager...

            regards, tom lane

pgsql-general by date:

Previous
From: "Dale Anderson"
Date:
Subject: Table locks
Next
From: Tom Lane
Date:
Subject: Re: Re: [SQL] Object syntax