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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
