The following bug has been logged online:
Bug reference: 1195
Logged by: Michael Groth
Email address: m.groth@10grad.de
PostgreSQL version: 7.4
Operating system: debian
Description: foreignkey-bug
Details:
hello,
this constraint doesn't work correctly : 'FOREIGN KEY (id_1, id_2)
REFERENCES table_1 ON DELETE CASCADE'
adding records into table_2 the database sometimes said that there is no
corresponding record in table_1, but there is.
otherwise this constraint work correctly with the same list of records:
'FOREIGN KEY (id_1, id_2) REFERENCES table_1 (id_1, id_2) ON DELETE CASCADE'
table-structure:
CREATE TABLE table_1 (
id_1 int NOT NULL,
id_2 int NOT NULL,
PRIMARY KEY (id_1, id_2)
);
CREATE TABLE table_2 (
id_1 int NOT NULL,
id_2 int NOT NULL,
FOREIGN KEY (id_1, id_2) REFERENCES table_1 ON DELETE CASCADE
);
best regards
michael