Paul Wehr (postgresql@industrialsoftworks.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