Re: [HACKERS] Bug in FOREIGN KEY

[Bruce Momjian]

> 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
  [EMAIL PROTECTED]               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026