Skip site navigation (1) Skip section navigation (2)

Re: deadlock problems with foreign keys

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Mario Weilguni <mario(dot)weilguni(at)icomedias(dot)com>
Cc: "Postgresql Mailinglist (E-Mail)" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: deadlock problems with foreign keys
Date: 2002-03-28 16:30:53
Message-ID: 20020328082428.R22741-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, 28 Mar 2002, Mario Weilguni wrote:

> I've a severe problem with deadlocks in postgres, when using
> referential integrity it's quite easy to trigger deadlocks. I think
> the may be a bug in ri_trigger.c (discussed later). Here's some short

You might want to see recent messages about foreign keys for more
information (in the RI triggers and schemas thread, specifically
the message from Alex Hayward).

Jan's example of a failure case is why it does what it currently does
since AFAIK we don't have a weaker mechanism available to us through SPI
currently that is still sufficiently strong.


In response to

pgsql-hackers by date

Next:From: Mario WeilguniDate: 2002-03-28 16:33:53
Subject: Re: deadlock problems with foreign keys
Previous:From: Alex LauDate: 2002-03-28 15:58:05
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group