Re: Temporally disabled foreign key constraint check? - Mailing list pgsql-general

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

You can disable *triggers* on a table (which will disable all the FK constraints, but not things like 'not nul' or 'unique').

For Disable:

update pg_class set reltriggers=0 where relname = 'TEST';

For Enable:

update pg_class set reltriggers = count(*) from pg_trigger where pg_class.oid=tgrelid and relname='TEST';