Re: Table locks

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dale Anderson" <danderso(at)crystalsugar(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: Table locks
Date: 2000-10-05 20:05:11
Message-ID: 10235.970776311@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dale Anderson" <danderso(at)crystalsugar(dot)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

In response to

  • Table locks at 2000-10-05 19:47:08 from Dale Anderson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-10-05 20:07:04 Re: Re: [SQL] Object syntax
Previous Message Dale Anderson 2000-10-05 19:47:08 Table locks