Re: Res: [GENERAL] Case sensitivity problems with user name

2009-03-24 Thread berdam
*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

Re: Res: [GENERAL] Case sensitivity problems with user name

2009-03-24 Thread Raymond O'Donnell
On 24/03/2009 20:25, Berdam wrote: > aer > ? -- Raymond O'Donnell, Director of Music, Galway Ca

Re: [GENERAL] Case sensitivity problems with user name

2009-03-24 Thread Raymond O'Donnell
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

Re: [GENERAL] Case sensitivity problems with user name

2009-03-24 Thread Will Rutherdale (rutherw)
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

Res: [GENERAL] Case sensitivity problems with user name

2009-03-24 Thread Berdam
@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

Re: [GENERAL] Case sensitivity problems with user name

2009-03-24 Thread John R Pierce
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

[GENERAL] Case sensitivity problems with user name

2009-03-24 Thread Will Rutherdale (rutherw)
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