Re: UPDATE pg_catalog.pg_class as NO Superuser??

Hidepesz,
-------- Original-Nachricht --------
> Datum: Thu, 13 Sep 2007 12:25:51 +0200
> Von: hubert depesz lubaczewski <depesz@depesz.com>
> An: Kai Behncke <Kai-Behncke@gmx.de>
> CC: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] UPDATE pg_catalog.pg_class as NO Superuser??

> 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
>
Could you give me an example for that please?
Thank you very much :-), Kai
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail