Hello.
I use following statements for temporarily disable triggers and enable them 
again:
--Disable triggers. 
UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'orders';

--Enable triggers.
UPDATE pg_class SET reltriggers = (
    SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid)
    WHERE relname = 'orders';

It works when connected as a superuser.

But, when I try to execute it as a normal user, not enough privillages, 
although I granted all privillages to pg_class and pg_trigger.

Do I miss something?

Thanks.

Reply via email to