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@xxxxxxxxxxxxxx)
------------------------------------------------------------------------
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx 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@xxxxxxxxx #
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
