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.



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to