Hi, everyone.
Is there a standard way to disable a table foreign-key constraint temporarily?
I thought that this would be a fairly common thing to want to do, but
I only found this snippet online:
-- to disable
UPDATE pg_class SET reltriggers=0 WHERE relname = 'your_table';
-- to re-enable
UPDATE pg_class SET reltriggers = count( * )
FROM pg_trigger WHERE pg_class.oid=tgrelid AND relname = 'your_table';
and it appears that one needs to be root to execute these statements.
Is there any other way for non-root users?
TIA!
kj