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.
--
Richard Huxton
Archonet Ltd