Re: Deadlock with ShareLocks? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Deadlock with ShareLocks?
Date
Msg-id 1134516688.27873.135.camel@localhost.localdomain
Whole thread Raw
In response to Re: Deadlock with ShareLocks?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, 2005-12-13 at 11:04 -0500, Tom Lane wrote:
> Mario Weilguni <mweilguni@sime.com> writes:
> > I guess two backends might have issued interleaved updates.
> > I think without logging this cannot be solved here. 
> 
> Yeah, it's annoying that there is no convenient way to see the contents
> of pg_locks at the instant of the deadlock.  Knowing which tuple locks
> were held would give at least some additional information.

Can we LOG that info? If the deadlock detector knows about it, surely we
can dump it out usefully.

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: kbforge@kbforge.com
Date:
Subject: New release: - kbforge 1.20 Free desktop search application with PGSQL database option
Next
From: "Marc G. Fournier"
Date:
Subject: Re: New release: - kbforge 1.20 Free desktop search