Re: insert deadlock

Brian Cox <bcox@wilytech.com> writes:
> There are no foreign key constraints from/to A or B to/from C.

How sure are you of that?  FK conflicts are much the most common reason
for unexpected deadlocks in pre-8.1 PG releases.

> 2005-12-02 15:04:46,773 [TP-Processor8] INFO
> [com.timestock.tess.services.processors.DefectProcessor] - <SQLException>
> java.sql.SQLException: ERROR: deadlock detected

Java is doing you no favors here by suppressing the detail message that
would have told you exactly who blocked on what.  Perhaps you can get
the detail by looking in the postmaster log, though.

            regards, tom lane