Обсуждение: Just in 'case' (:

Hi folks,

it seems that there is a problem with identifying cases on a win XP pro
installation of a binary snapshot from about a week ago. initdb was run
under user 'Postgres' account. Instance ( sorry if that's the wrong
word... Oracle background ) is owned by Postgres. create user postgres
unencrypted password 'postgres' createuser createdb works fine and
creates another user, uid 100. alter user Postgres unencrypted password
'Postgres' changes the password for user 'postgres', not 'Postgres'.

Personally, I see the recognition of case in the username as an extra
complication, and it doesn't happen with table/column names, so could it
be removed from here as well?

Cheers,

Steve

Steve ,

did you check for

alter user "Postgres" unencrypted password 'Postgres' changes the
password for user 'postgres', not 'Postgres'.

and also with columns using "" for case sensitivity?

Harald