Re: Record locking in deadlock - Mailing list pgsql-general

From Tom Lane
Subject Re: Record locking in deadlock
Date
Msg-id 7119.1057457425@sss.pgh.pa.us
Whole thread Raw
In response to Re: Record locking in deadlock  ("Robert Wille" <a2om6sy02@sneakemail.com>)
List pgsql-general
"Robert Wille" <a2om6sy02@sneakemail.com> writes:
> Any idea how this could happen or how to track it down? Is there any way to
> look at what records are locked, and what caused them to be locked?

Update to PG 7.3, and see the pg_locks view.  There is no very useful
way to see the locking state in earlier releases.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Record locking in deadlock
Next
From: Jason Godden
Date:
Subject: Rules and actions involving multiple rows