Re: Debugging deadlocks

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Debugging deadlocks
Date: 2005-03-28 02:11:42
Message-ID: d27p67$2ifu$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bricklen Anderson 2005-03-28 03:36:02 Re: plpgsql no longer exists
Previous Message Michael Fuhr 2005-03-28 02:06:58 Re: After Insert or Update Trigger Issues!