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.