Re: FKs and deadlocks - Mailing list pgsql-general

"Philippe Lang" <philippe.lang@attiksystem.ch> writes:
> I got a deadlock in my database this morning.

There is no deadlock here.  The ungranted rows in pg_locks all point to
the transaction ID 6489299, which belongs to PID 11346, which is this
one:

> 11346  ??  R    236:43.23 postmaster: jlroubaty groupefpdb 172.17.10.14 UPDATE (postgres)

An UPDATE that churns for hours and hours may well represent a bug in
your application (unconstrained join maybe?) but it's not a deadlock.

            regards, tom lane