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

On 3/23/2005 11:22 AM, Joshua D. Drake wrote:

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

and not only a superuser, but one with usecatupd set to true as well.


Jan

>
> 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)
>
>
>
>
>
> ------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #