Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.1/8.9.1) with ESMTP id OAA02782 for ; Tue, 29 Dec 1998 14:43:02 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by trends.net (8.8.8/8.8.8) with SMTP id OAA23615 for ; Tue, 29 Dec 1998 14:17:04 -0500 (EST) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m0zuj8x-000EBPC; Mon, 28 Dec 98 21:19 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] change username To: brandtwr-pgsql@draaw.net (Bill Brandt) Date: Mon, 28 Dec 1998 21:19:59 +0100 (MET) Cc: pgsql-sql@postgreSQL.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: <19981228131503.01192@draaw.net> from "Bill Brandt" at Dec 28, 98 01:15:03 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > I have a user on my system whose username has recently changed. The user > owns and is a non-owning user of multiple database. I have tried a command > of the form: > > update pg_user set usename='newname' where usesysid=###; > > When I try this I get an error. Does anyone know how to change this > information? If I delete the user and recreate the user with the same uid > does that retain all the existing database permissions? pg_user is a system view. Update pg_shadow instead. But what error do you get? The command should respond with "UPDATE 0" and do nothing! Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #