Stephan Szabo wrote:
> On Sat, 3 Jul 2004, Dennis Gearon wrote:
>
>
>>Please CC me:
>>
>>If I create the user 'web_user'
>>with password 'password'
>>I can connect using 'psql' just fine.
>>
>>If I create the user 'D1Khb2g5m7FGk_web_user'
>>with password 'password'
>>I CANNOT connect using 'psql', I get authentication error.
>
>
> Are you sure that you're not just running into a case problem
> with case folded names (non-quoted names from sql statements) versus
> non-case folded names (programs which treat their arguments as quoted like
> psql).
>
I am putting the exact same string into both situations:
A/ creating the username
B/ trying to log in.
If the database is not going to respect case in one, it shouldn't respect case in the other, right?
Maybe because it's feeding the name to the MD5 library with case, but checking it without case later?