Re: I'm OWNER of the db but I get `permission denied` when

David Gagnon wrote:

> 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.


You are a datdba but not a superuser :). You have to be a super user
to update pg_class.

Sincerely,

Joshua D. Drake

>
> 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
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL