oracle: deferring Foreign Key checks not working. e.g.,
create table Foo (id number(20,0), name varchar(20),
primary key(id));
create table Bar (id number(20,0), name varchar(20),
primary key(id),
constraint FK1 foreign key (id) references Foo (id));
insert into Foo(id,name) values(1, 'foo');
insert into Bar(id,name) values(1, 'bar');
delete data:
SET CONSTRAINTS ALL DEFERRED;
delete from Foo;
delete from Bar;
SET CONSTRAINTS ALL IMMEDIATE;
ERROR:
ORA-02292: integrity constraint violated - child record found