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

Re: Two foreign keys in one table both referencing same record in primary table gives error on update of primary table

From: "Bob Soeters" <bob(at)iway(dot)nl>
To: "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Two foreign keys in one table both referencing same record in primary table gives error on update of primary table
Date: 2001-07-19 00:00:20
Message-ID: 002601c10fe5$cdea0d00$72e29fc2@TBPIII450W2K (view raw or flat)
Thread:
Lists: pgsql-bugs
Thank you Stephan, for the quick reply.

Please, do you know if your fixes will be available soon,
or are they already in the development release or any of the production
releases ?

> Yes, it's because it sees the intermediate
> state (6,1) when it shouldn't (it processes
> each foreign key separately and does the cascade
> update which places it in an "invalid" state
> since the 1 key no longer exists).
>
> I believe the fixes I've been working on for deferred
> constraints will make this case work as well.
>
> > Bob Soeters (bob(at)iway(dot)nl) reports a bug with a severity of 2
> > Short Description Two foreign keys in one table both referencing same
> > record in primary table gives error on update of primary table



In response to

pgsql-bugs by date

Next:From: bonolinDate: 2001-07-19 04:08:36
Subject: help for:FATAL 1: configuration file `postgresql.conf' has wrong permissions
Previous:From: Stephan SzaboDate: 2001-07-18 21:58:49
Subject: Re: Two foreign keys in one table both referencing same record in primary table gives error on update of primary table

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