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(at)postgresql(dot)org)
>
>
>
>
>
> ------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)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(at)Yahoo(dot)com #