Re: BUG #3654: Inconsistent handling of usernames - Mailing list pgsql-bugs

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, Oct 04, 2007 at 11:36:59PM +0000, Radim Kolar wrote:
>
> The following bug has been logged online:
>
> Bug reference:      3654
> Logged by:          Radim Kolar
> Email address:      kolar.radim@gmail.com
> PostgreSQL version: 8.2.5
> Operating system:   Windows XP
> Description:        Inconsistent handling of usernames
> Details:
>
> On Windows platform, users are named like 'Radim'. PostgreSQL doesnt seems
> to be able to create user 'Radim'. i.e cant rename user 'radim' TO 'Radim';
> PGSQL usernames are sadly not case sensitive.

This is probably not a bug. We can't see how you generated the user, but
if you want to have it case-sensitive you have to double-quote it (as
you would have to do for any other named object in the database):

  CREATE USER "Radim" WITH PASSWORD 'secret';

instead of:

  CREATE USER Radim WITH PASSWORD 'secret';

The second variant will create a lower-case user radim.

Hope that helps
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFHBgsXBcgs9XrR2kYRAt4jAJ9mWW4NQvDZYAgAFcC5QlJB9qShowCfXEns
9435e3u7/gSKoLGe7eJhjKA=
=znKm
-----END PGP SIGNATURE-----