Re: do foreign key checks lock parent table ?

From: <swalker(at)iglou(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: do foreign key checks lock parent table ?
Date: 2002-04-03 05:18:54
Message-ID: Pine.LNX.4.33.0204030016450.24260-100000@12-220-136-82.client.insightBB.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2002-04-03 05:48:20 Re: [HACKERS] v7.2.1 Released: Critical Bug Fix
Previous Message Neil Conway 2002-04-03 04:54:35 Re: Suggestions please: names for function cachability