Re: do foreign key checks lock parent table ? - Mailing list pgsql-general

From
Subject Re: do foreign key checks lock parent table ?
Date
Msg-id Pine.LNX.4.33.0204030016450.24260-100000@12-220-136-82.client.insightBB.com
Whole thread Raw
In response to Re: do foreign key checks lock parent table ?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: do foreign key checks lock parent table ?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: do foreign key checks lock parent table ?  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-general
So turning intially deferred on is a suitable solution?  It seems
to work OK in this simple test case.

On Tue, 2 Apr 2002, Stephan Szabo wrote:
> The locks being grabbed are a bit stronger than they need to be
> (if you want more info, there was a bit of discussion on -hackers
> recently).  The updates should block updates on parent of the
> referenced row but don't need to block other child updates but there's
> no current lock level that is quite right.


pgsql-general by date:

Previous
From: Peter Sojan
Date:
Subject: Re: Problem with referential integrity within functions (bug?)
Next
From: Oliver Elphick
Date:
Subject: Re: [HACKERS] v7.2.1 Released: Critical Bug Fix