Re: BUG #6313: Deadlock reporting contains not enought details

dmigowski@ikoffice.de writes:
> PostgreSQL version: 8.3.16

> In my application I receive deadlocks from time to time, reported by an
> error message like this:

> ERROR: deadlock detected
> SQL Status:40P01
> Detail:Process 30812 waits for ShareLock on transaction 278158200; blocked
> by process 2852.
> Process 2852 waits for ShareLock on transaction 278158159; blocked by
> process 30812.

> This is absolutely useless for me for the following reasons.

If you were running a more modern version of Postgres, you would find a
more complete report about the deadlock in the postmaster log.  We're
not going to change it in 8.3.x though.

            regards, tom lane