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