SLUG Mailing List Archives - [SLUG] Re: How can I get a list of locks in a table in Postgres?

To: slug@xxxxxxxxxxx
Subject: [SLUG] Re: How can I get a list of locks in a table in Postgres?
From: Angus Lees <gus@xxxxxxxxxxx>
Date: Mon Feb 25 12:06:02 2002
User-agent: Mutt/1.3.27i

On Fri, Feb 22, 2002 at 04:53:53PM +0900, Antony Stace wrote:
> I have run into a problem with postgres.  I cannot update some rows in a table while
> i can update other rows in the same table.  How can I see what locks are on a table/row in postgres?

don't know. but "pgmonitor" could show you what queries were currently
executing, which may be enough to find the problem.

-- 
 - Gus

References:
- [SLUG] How can I get a list of locks in a table in Postgres?
  - From: Antony Stace

Messages sorted by: [ date | thread ]
Prev by Date: [SLUG] Using unstable packages with Potato
Next by Date: Re: [SLUG] Mounting a zip file?
Previous by thread: [SLUG] How can I get a list of locks in a table in Postgres?
Next by thread: [SLUG] ask xlib