This problem with foreign keys has been reported to me, and I have confirmed
the bug exists in current sources. The DELETE should succeed:
---------------------------------------------------------------------------
CREATE TABLE primarytest2 ( col1 INTEGER, col2 INTEGER,
PRIMARY KEY(col1, col2) );
CREATE TABLE foreigntest2 (col3 INTEGER, col4 INTEGER, FOREIGN KEY
(col3,col4) REFERENCES primarytest2 );
test=> BEGIN;
BEGIN
test=> INSERT INTO primarytest2 VALUES (5,5);
INSERT 27618 1
test=> DELETE FROM primarytest2 WHERE col1 = 5 AND col2 = 5;
ERROR: triggered data change violation on relation "primarytest2"
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026