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 #
