Re: Bug in FOREIGN KEY

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@candle.pha.pa.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@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