Received: from draaw.net (qmailr@puma.draaw.net [199.234.237.21]) by hub.org (8.9.1/8.9.1) with SMTP id NAA28898 for ; Mon, 28 Dec 1998 13:15:06 -0500 (EST) (envelope-from bbrandt@draaw.net) Received: (qmail 28311 invoked by uid 501); 28 Dec 1998 18:15:03 -0000 Message-ID: <19981228131503.01192@draaw.net> Date: Mon, 28 Dec 1998 13:15:03 -0500 From: Bill Brandt To: pgsql-sql@postgreSQL.org Subject: change username Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.88e 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? -- Bill Brandt brandtwr@draaw.net http://www.draaw.net/