On Thu, Feb 08, 2007 at 08:47:42AM -0800, Marc Munro wrote: > One of the causes of deadlocks in Postgres is that its referential > integrity triggers can take locks in inconsistent orders. Generally a > child record will be locked before its parent, but not in all cases.
Where would PostgreSQL lock the parent before the child? AFAIK the behavior should be consistent... -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
