Yes, that worked, thanks. After also doing this: alter database "mickey" rename to "Mickey"; it solved the problem. Pardon my newness to Postgres. -Will -----Original Message----- From: John R Pierce [mailto:pierce@xxxxxxxxxxxx] Sent: 24 March 2009 16:21 To: Will Rutherdale (rutherw) Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Case sensitivity problems with user name Will Rutherdale (rutherw) wrote: > When I try going into psql as user postgres to change the user name, I > get this problem: > > postgres=# alter user mickey rename to Mickey; > > ERROR: role "mickey" already exists > you might try... alter user "mickey" rename to "Mickey"; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
