> 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