Re: [GENERAL] UPDATE pg_catalog.pg_class as NO Superuser??

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

[GENERAL] UPDATE pg_catalog.pg_class as NO Superuser??

2007-09-13 Thread Kai Behncke
Dear list, on my system I have multiple user. I want that the user xy (who is no superuser) can Update a systemtable with: UPDATE pg_catalog.pg_class SET reltriggers = 0; With psql I already wrote: ALTER TABLE pg_catalog.pg_class OWNER TO xy; and GRANT ALL PRIVILEGES ON pg_catalog.pg_class T

[GENERAL] Question to schema public

2007-09-12 Thread Kai Behncke
Dear list, If I create on my system (Postgresql 8.2.4) a new database it gets automatically the schema public. I would like to know what this schema is for? On my system I have a couple of different users. The owner of the public-schema is postgres. Could it be Fatal to give all of my users th