Res: Case sensitivity problems with user name

From: Berdam <berdamzinho(at)yahoo(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Res: Case sensitivity problems with user name
Date: 2009-03-24 20:25:32
Message-ID: 440206.24516.qm@web53206.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

aergggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg

ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg
gggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg

________________________________
De: John R Pierce <pierce(at)hogranch(dot)com>
Para: Will Rutherdale (rutherw) <rutherw(at)cisco(dot)com>
Cc: pgsql-general(at)postgresql(dot)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 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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Will Rutherdale (rutherw) 2009-03-24 20:38:58 Re: Case sensitivity problems with user name
Previous Message John R Pierce 2009-03-24 20:21:20 Re: Case sensitivity problems with user name