Foreign key order evaluation

From: "Shawn Chisholm" <ShawnC(at)sandvine(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Foreign key order evaluation
Date: 2004-09-27 19:19:47
Message-ID: A8535F8D62F3644997E91F4F66E341FC17F22B@exchange.sandvine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi, I am trying to deal with a deadlock situation caused by foreign key references on insert and I was wondering if anyone knows what order the foreign keys are locked (or evaluated) in for a particular table? Deferring the locks is unfortunately not a good option for me...

Thanks,

Shawn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dean Gibson (DB Administrator) 2004-09-27 20:08:34 Re: Null comparisons (was Re: checksum)
Previous Message Kevin Murphy 2004-09-27 18:08:03 Re: using COPY table FROM STDIN within script run as psql