Ricardo J. Méndez Castro (rmendez@sheertalent.com) 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'mfollowing (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
Testwith
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