Ricardo J. Méndez Castro ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Postgres apparently not identifying users created in Caps

Long Description
I'm unable to change the password for an user after creating it with some of the 
letters in caps.  Here are the steps I'm following (from my user on a Linux machine):

su - 
su - postgresql
createuser Test;   (I don't give him any superuser rights)
psql -d testdatabase; (whichever database)

Inside psql, I then do:

alter user Test with password 'testpwd';

I then get an error message stating that the user 'test' (no caps) isn't known to the 
system.  Logging in with the user Test with

psql -d testdatabase -U Test;

does work. The only problem is in changing the password from psql.  I WAS able to 
change the password from pgAdmin II.

Sample Code


No file was uploaded with this report


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to