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

From Stephan Szabo
Subject Re: do foreign key checks lock parent table ?
Date
Msg-id 20020403083359.C92483-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: do foreign key checks lock parent table ?  (<swalker@iglou.com>)
List pgsql-general
On Wed, 3 Apr 2002 swalker@iglou.com wrote:

>
> So turning intially deferred on is a suitable solution?  It seems
> to work OK in this simple test case.

That'll hide this particular locking issue (since the locks are held
for much less time in that case).  There are some issues with
initially deferred constraints right now in some cases if you're
doing actions on both tables in one transaction (like deleting a
pk row and then re-adding it).

>
> 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: Tom Lane
Date:
Subject: Re: [HACKERS] Re : Solaris Performance - Profiling (Solved)
Next
From: Jan Wieck
Date:
Subject: Re: do foreign key checks lock parent table ?