Re: Deadlock with ShareLocks?

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