Robert Forsman ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
foreign keys are broken
Long Description
I'm performing a transaction that has temporary violations of a referential integrity
constraint which are repaired later in the transaction. However, I still get a
constraint failure when I set constraints all immediate, even thought the tables have
been adjusted to a consistent state.
The following code snippet demonstrates the malfunction in postgres 7.1.3 :
Sample Code
create table x(foo int primary key); create table y(foo int references x deferrable);
begin; set constraints all deferred; insert into y values(2); insert into x values(2);
set constraints all immediate; commit;
begin; set constraints all deferred; delete from x; delete from y; insert into y
values(2); insert into x values(2); select * from x; select * from y;set constraints
all immediate;
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
