[BUGS] BUG #3654: Inconsistent handling of usernames
The following bug has been logged online: Bug reference: 3654 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 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[BUGS] BUG #3655: Inconsistent handling of usernames
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
[BUGS] BUG #3714: applications using COPY are now much slower
The following bug has been logged online: Bug reference: 3714 Logged by: Radim Kolar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 beta2 Operating system: BSD/64bit Description:applications using COPY are now much slower Details: Applications using COPY for batch insert few records are now much slower on heavily updated table than in 8.2. Using COPY for importing database dumps in 8.3 is noticeable faster than in 8.2 I recommend to add some configuration file switch for switching COPY between old and new mode or add COPY NOLOG keyword. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[BUGS] BUG #3717: libpq needs .so version raised to 6
The following bug has been logged online: Bug reference: 3717 Logged by: Radim Kolar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta2 Operating system: FreeBSD Description:libpq needs .so version raised to 6 Details: /libexec/ld-elf.so.1: /usr/local/pgsql8.3/bin/psql: Undefined symbol "PQconnectionUsedPassword" both libpq from pgsql 8.2 and 8.3 are using same version of .so 5. But libpq from 8.3 have new function PQconnectionUsedPassword. .so version of 8.3 libpq needs to be raised to 6 /usr/local/pgsql8.3/lib/libpq.so.5 ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
