BUG #1195: foreignkey-bug

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