Hidepesz, -------- Original-Nachricht -------- > Datum: Thu, 13 Sep 2007 12:25:51 +0200 > Von: hubert depesz lubaczewski <depesz@xxxxxxxxxx> > An: Kai Behncke <Kai-Behncke@xxxxxx> > CC: pgsql-general@xxxxxxxxxxxxxx > Betreff: Re: 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings