From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Bug in FOREIGN KEY |
Date: | 2001-01-23 04:16:48 |
Message-ID: | 200101230416.XAA04293@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Can someone tell me where we are on this?
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-01-23 04:17:13 | Re: Bug in FOREIGN KEY |
Previous Message | Bruce Momjian | 2001-01-23 04:05:47 | Re: SourceForge & Postgres |