| From: | David Gagnon <dgagnon(at)siunik(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | Marco Colombo <pgsql(at)esiway(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: I'm OWNER of the db but I get `permission denied` when |
| Date: | 2005-03-23 16:29:54 |
| Message-ID: | 42419982.9050406@siunik.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2005-03-23 16:30:47 | Re: Simple query takes a long time on win2K |
| Previous Message | Magnus Hagander | 2005-03-23 16:28:34 | Re: Simple query takes a long time on win2K |