| 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: | Whole Thread | Raw Message | 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.
| 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 |