Re: Debugging deadlocks - Mailing list pgsql-general

From Qingqing Zhou
Subject Re: Debugging deadlocks
Date
Msg-id d27p67$2ifu$1@news.hub.org
Whole thread Raw
In response to Debugging deadlocks  ("Guy Rouillier" <guyr@masergy.com>)
List pgsql-general
"Stephan Szabo" <sszabo@megazone.bigpanda.com> writes
>
> Well, that's not the foreign key necessarily. I don't have a machine to
> test on at the moment (machine currently dead), but I think the same
> happens without a foreign key constraint due to the unique/primary key
> constraint on a.i.

I see. That's more reasonable - the executor will first wait to see if the
constraint on itself satifies, then do the RI check.

Thanks,
Qingqing



pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: After Insert or Update Trigger Issues!
Next
From: Bricklen Anderson
Date:
Subject: Re: plpgsql no longer exists