RI Bug In Inherited Table

Hi!

Please try the following.

Regards,

CN
-------------
CREATE TABLE tt1 (
c1int primary key
)WITHOUT OIDS;

CREATE TABLE tt2 (
PRIMARY KEY (c1,c2),
c1int,
c2int
)INHERITS (tt1) WITHOUT OIDS;

CREATE TABLE tt3 (
CONSTRAINT fktt3c1 FOREIGN KEY (c1) REFERENCES tt1 (c1),
PRIMARY KEY (c1,c2),
c1int,
c2int,
c3int
)WITHOUT OIDS;

INSERT INTO tt2 VALUES(1,2);
INSERT INTO tt3 VALUES(1,2,3); --This statement produces fktt3c1 referential integrity violation
--
_______________________________________________
Get your free email from http://www.graffiti.net

Powered by Outblaze