Thread: BUG #1195: foreignkey-bug

BUG #1195: foreignkey-bug

From
"PostgreSQL Bugs List"
Date:
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

Re: BUG #1195: foreignkey-bug

From
Peter Eisentraut
Date:
PostgreSQL Bugs List wrote:
> 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.

Please provide a concrete, reproducible example.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/