privillages for pg_class

Started by Zlatko Matićover 18 years ago1 messagesgeneral
Jump to latest
#1Zlatko Matić
zlatko.matic1@sb.t-com.hr

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.