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