fk_check_input_values — alter default foreign key checking behavior


DB.DBA. fk_check_input_values ( in mode integer );


mode = 1 - on
mode = 0 - off

Enforcing foreign key constraints is enabled by default. This function allows globally disabling it without however disabling all triggers. This may be useful for large data imports or other special circumstances. The return value is the previous state of this setting, 0 for off, 1, for on. The effect of this function is persistent and survives server restart.