-----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: [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.
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----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
