RE: [BUGS] POSTGRES BUG - FIX IT PLEASE - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: [BUGS] POSTGRES BUG - FIX IT PLEASE
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018D45@SECTORBASE1
Whole thread Raw
Responses Re: RE: [BUGS] POSTGRES BUG - FIX IT PLEASE
List pgsql-hackers
> > create table t1
> > (
> >         f1 integer,
> >         f2 integer
> > );
> > 
> > create table t2
> > (
> >         f1 integer references t1(f1),
> >         f2 integer
> > );
> 
> > begin transaction;
> > insert into t1(f1,f2) values(1,1);
> > delete from t1 where f1=1;
> 
> > ERROR:  triggered data change violation on relation "t1"
> 
> You cannot change data twice within a transaction if there's a RI
> constraint on the table.  This is per SQL, nothing we can do about it.                           ^^^^^^^^^^^^^^^
Is it true?! *Any reasons* for this? DELETE doesn't break integrity rules.
Just tested it in Oracle - deletion is allowed!
But yes, I know that Oracle doesn't always follow standards -:)
Can someone test it under Informix, others?

Vadim


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: My new job
Next
From: Tom Lane
Date:
Subject: Re: ORDER BY and UNION