*De:* John R Pierce
*Para:* Will Rutherdale (rutherw)
*Cc:* pgsql-general@postgresql.org
*Enviadas:* Terça-feira, 24 de Março de 2009 17:21:20
*Assunto:* Re: [GENERAL] Case sensitivity problems with user name
Will Rutherdale (rutherw) wrote:
> When I try going into psql as user postg
On 24/03/2009 20:25, Berdam wrote:
> aer
>
?
--
Raymond O'Donnell, Director of Music, Galway Ca
On 24/03/2009 20:38, Will Rutherdale (rutherw) wrote:
> Pardon my newness to Postgres.
We've all been there at some point! - except of course for Tom Lane.
:-)
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Irelan
herdale (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
@postgresql.org
Enviadas: Terça-feira, 24 de Março de 2009 17:21:20
Assunto: 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 mick
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-genera
Hi.
I have a little problem with user names and Postgres commands.
Due to quirks in corporate account management using ADS, some user names
come out as, say, Mickey when you log into Linux instead of mickey.
This unfortunate user tries to run Postgres commands and gets for
instance:
$ p