Re: UPDATE pg_catalog.pg_class as NO Superuser?? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: UPDATE pg_catalog.pg_class as NO Superuser??
Date
Msg-id 20070913102551.GA10931@depesz.com
Whole thread Raw
In response to UPDATE pg_catalog.pg_class as NO Superuser??  ("Kai Behncke" <Kai-Behncke@gmx.de>)
Responses Re: UPDATE pg_catalog.pg_class as NO Superuser??
List pgsql-general
On Thu, Sep 13, 2007 at 11:25:39AM +0200, Kai Behncke wrote:
> I want that the user xy (who is no superuser) can Update a systemtable with:
> UPDATE pg_catalog.pg_class SET reltriggers = 0;

why dont you simply alter table disable trigger?

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: UPDATE pg_catalog.pg_class as NO Superuser??
Next
From: "Kai Behncke"
Date:
Subject: Re: UPDATE pg_catalog.pg_class as NO Superuser??