Charles Haron wrote, On 3/23/2004 21:48:
Is there a way to temporarily disable a trigger without dropping and re-adding it?
if you ever use dump: pg_dump --disable-triggers ...
off:
UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid = 'tablename'::pg_catalog.regclass;
on:
UPDATE pg_catalog.pg_class SET reltriggers = (SELECT pg_catalog.count(*) FROM pg_catalog.pg_trigger where pg_class.oid = tgrelid) WHERE oid = 'tablename'::pg_catalog.regclass;
C.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
