Foreign key order evaluation - Mailing list pgsql-general

From Shawn Chisholm
Subject Foreign key order evaluation
Date
Msg-id A8535F8D62F3644997E91F4F66E341FC17F22B@exchange.sandvine.com
Whole thread Raw
Responses Re: Foreign key order evaluation  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Hi, I am trying to deal with a deadlock situation caused by foreign key references on insert and I was wondering if
anyoneknows what order the foreign keys are locked (or evaluated) in for a particular table?  Deferring the locks is
unfortunatelynot a good option for me... 

Thanks,

Shawn



pgsql-general by date:

Previous
From: Kevin Murphy
Date:
Subject: Re: using COPY table FROM STDIN within script run as psql
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: Null comparisons (was Re: checksum)