Hi,
We have a problem with the next table declarations:
EXEC SQL CREATE TABLE table1(
p1 int4,
p2 varchar(10),
p3 varchar(20),
CONSTRAINT table1_1 PRIMARY KEY (p1)
);
EXEC SQL COMMIT;
EXEC SQL CREATE TABLE table2(
s1 int4,
s2 int4,
s3 varchar(10),
s4 varchar(20),
CONSTRAINT table2_1 PRIMARY KEY (s2, s1),
CONSTRAINT table2_2 FOREIGN KEY (S2) REFERENCES table1 (p1) DEFERRABLE
);
EXEC SQL COMMIT;
EXEC SQL CREATE TABLE table3 (
x1 int4,
x2 int4,
x3 int4,
x4 varchar(16),
CONSTRAINT table3_1 PRIMARY KEY (x3, x2, x1),
CONSTRAINT table3_2 FOREIGN KEY (x3) REFERENCES table2 (s1) DEFERRABLE
);
EXEC SQL COMMIT;
After compile, when we run the program, we obtain the next error in the
third "COMMIT";
Err code: -400
ERROR: UNIQUE constraint matching given keys for referenced table
"table2" not found.
We are using postgres 7.1.3, could you help us?
Thanks.
