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.
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 [EMAIL PROTECTED])
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
