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),
P
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,
