I forget to mention the version: postgreSQL 7.3.2.
Regards,
CN
-------------
CREATE TABLE tt1 (
c1 int primary key
)WITHOUT OIDS;
CREATE TABLE tt2 (
PRIMARY KEY (c1,c2),
c1 int,
c2 int
)INHERITS (tt1) WITHOUT OI---DS;
CREATE TABLE tt3 (
CONSTRAINT fktt3c1 FOREIGN KEY (c1) REFERENCES tt1 (c1),
PRIMARY KEY (c1,c2),
c1 int,
c2 int,
c3 int
)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