Brian Cox <bcox@xxxxxxxxxxxx> 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
