I'm OWNER of the db but I get `permission denied` when doing updating table pg_class ???? Any help appreciated

Поиск
Список
Период
Сортировка
От David Gagnon
Тема I'm OWNER of the db but I get `permission denied` when doing updating table pg_class ???? Any help appreciated
Дата
Msg-id 42418566.7050107@siunik.com
обсуждение исходный текст
Ответ на Re: plpython function problem workaround  (Marco Colombo <pgsql@esiway.net>)
Ответы Re: I'm OWNER of the db but I get `permission denied` when  (Richard Huxton <dev@archonet.com>)
Re: I'm OWNER of the db but I get `permission denied` when  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
Hi all,

I just created a new db wich userX is owner.  I log via pgAdminIII with
the same user but I can't update the pg_class.

UPDATE pg_class SET reltriggers = 0 WHERE relname = 'ic'

I get:ERROR:  permission denied for relation pg_class

I do that on my dev env.  The only difference I saw beetween users is
that my DEV user as priviledge to create database(But it shouln't
matter...?!)

We create the db with : createdb -O userX -E UNICODE webCatalogTest

Thanks for your help!

/David





В списке pgsql-general по дате отправления:

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: Simple query takes a long time on win2K
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: PostgreSQL support