Bug in FOREIGN KEY
От | Bruce Momjian |
---|---|
Тема | Bug in FOREIGN KEY |
Дата | |
Msg-id | 200012121713.MAA14926@candle.pha.pa.us обсуждение исходный текст |
Ответы |
Re: Bug in FOREIGN KEY
Re: Bug in FOREIGN KEY |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: