Re: BUG #3654: Inconsistent handling of usernames

-----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(dot)radim(at)gmail(dot)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-----