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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
