privillages for pg_class

From: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: privillages for pg_class
Date: 2007-07-20 09:29:34
Message-ID: 004201c7cab0$7e3277c0$34715bd4@zlatkovyfkpgz6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Sébastien Boutté 2007-07-20 10:25:35 Re: pg_dump without blobs
Previous Message Shane Ambler 2007-07-20 09:08:45 Re: Retrieve the record ID