The following bug has been logged online: Bug reference: 3655 Logged by: Radim Kolar Email address: [EMAIL PROTECTED] 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'. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate