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.
Problem is when user Radim launches PGSQL app for example psql.exe. psql
grabs username of current user from Windows which is 'Radim'. Sadly
postgresql uses username for password hashing so even if user type right
password for 'radim' but Windows is trying to log
him as 'Radim', he is out of luck.
G:\Program Files\EnterpriseDB Postgres\8.2\bin>psql
Heslo:
psql: FATAL: password authentication failed for user "Radim"
G:\Program Files\EnterpriseDB Postgres\8.2\bin>psql -U radim
Password for user radim:
psql: FATAL: database "radim" does not exist
FIX: make libpq to convert usernames to lowercase, because even if i am
trying to create user 'Radim', pgsql store him in catalog as 'radim'.