Re: I'm OWNER of the db but I get `permission denied` when - Mailing list pgsql-general

From David Gagnon
Subject Re: I'm OWNER of the db but I get `permission denied` when
Date
Msg-id 42419982.9050406@siunik.com
Whole thread Raw
In response to Re: I'm OWNER of the db but I get `permission denied` when  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Thanks It's the problem.

/David

Richard Huxton 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.
>>
>> 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...?!)
>
>
> I'm guessing your dev user is a superuser, and your other user isn't.
> Don't forget pg_class isn't in your database, it's shared by all.
>


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: backend process
Next
From: "Magnus Hagander"
Date:
Subject: Re: Simple query takes a long time on win2K