Emi Lu wrote on 21.10.2011 15:36:
Good morning,
Is there a way to temporally disabled foreign key constraints something like
SET FOREIGN_KEY_CHECKS=0
When population is done, will set FOREIGN_KEY_CHECKS=1
Thanks a lot!
Emi
You can define the FKs as "DEFERRABLE INITIALLY IMMEDIATE".
Then at the start of your transaction you can defer constraint checking until
you commit everything using:
SET CONSTRAINTS ALL DEFERRED;
Thomas
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql