Re: Record locking in deadlock

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert Wille" <a2om6sy02(at)sneakemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Record locking in deadlock
Date: 2003-07-06 02:10:25
Message-ID: 7119.1057457425@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Robert Wille" <a2om6sy02(at)sneakemail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jason Godden 2003-07-06 04:48:59 Rules and actions involving multiple rows
Previous Message Stephan Szabo 2003-07-06 01:37:25 Re: Record locking in deadlock