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

Bug #511: multiple foreign keys on same table fail update cascade

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #511: multiple foreign keys on same table fail update cascade
Date: 2001-11-07 18:27:43
Message-ID: 200111071827.fA7IRhU16629@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Paul Wehr (postgresql(at)industrialsoftworks(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
multiple foreign keys on same table fail update cascade

Long Description
I would expect the code below to say "1 records updated", setting the values of t_b.b and t_b.c to "2".

Sample Code
create table t_a (a int, primary key (a));
create table t_b (b int, c int,
		foreign key (b) references t_a (a) on update cascade,
		foreign key (c) references t_a (a) on update cascade);
insert into t_a values (1);
insert into t_b values (1, 1);
update t_a set a=2;



No file was uploaded with this report


pgsql-bugs by date

Next:From: Vincent.GaboriauDate: 2001-11-08 14:44:16
Subject: Curious problem with the character û é
Previous:From: Kovacs ZoltanDate: 2001-11-06 21:35:17
Subject: Re: Bug #510: conditional rules sometimes work more than

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