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:pie...@hogranch.com] Sent: 24 March 2009 16:21 To: Will Rutherdale (rutherw) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
