privillages for pg_class

[Zlatko Matić <zlatko.matic1@xxxxxxxxxxx>]

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.