Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group