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

From Bruce Momjian
Subject Re: Bug in FOREIGN KEY
Date
Msg-id 200101262203.RAA10859@candle.pha.pa.us
Whole thread Raw
In response to Re: Bug in FOREIGN KEY  (Jan Wieck <janwieck@Yahoo.com>)
Responses RE: Bug in FOREIGN KEY
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
 


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Sure enough, the lock file is gone
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: Bug in FOREIGN KEY