Mikheev, Vadim writes:
> > 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?!
Actually, it's not. Jan Wieck first explained this on July 23 in "
> > 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: trig
Sergey Mavrinsky writes:
> 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 da
