Re: [GENERAL] Problem with SET CONSTRAINTS some_constraint_fkey DEFERRED

2009-12-09 Thread Tom Lane
Sergey Levchenko writes: > Why I get: update or delete on table "people" violates foreign key > constraint "transactions_person_id_fkey" on table "transactions" > But before that query I run: SET CONSTRAINTS > transactions_person_id_fkey DEFERRED; before delete from people table It looks to me l

[GENERAL] Problem with SET CONSTRAINTS some_constraint_fkey DEFERRED

2009-12-09 Thread Sergey Levchenko
Why I get: update or delete on table "people" violates foreign key constraint "transactions_person_id_fkey" on table "transactions" But before that query I run: SET CONSTRAINTS transactions_person_id_fkey DEFERRED; before delete from people table Log: 2009-12-09 20:01:51 EET LOG: statement: BEG