Re: Bug in FOREIGN KEY - Mailing list pgsql-hackers

> Bruce Momjian wrote:
> > Here is another bug:
> >
> > test=> begin;
> > BEGIN
> > test=> INSERT INTO primarytest2 VALUES (5,5);
> > INSERT 18757 1
> > test=> UPDATE primarytest2 SET col2=1 WHERE col1 = 5 AND col2 = 5;
> > ERROR:  deferredTriggerGetPreviousEvent: event for tuple (0,10) not
> > found
> 
>     Schema?
> 

CREATE TABLE primarytest2 (                          col1 INTEGER,                           col2 INTEGER,
            PRIMARY KEY(col1, col2)                         );
 

CREATE TABLE foreigntest2 (col3 INTEGER,                           col4 INTEGER,                          FOREIGN KEY
(col3,col4) REFERENCES 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