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(at)postgresql(dot)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(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL