Re: BUG #1485: upper case user names / creatuser

Hannes Erven wrote:
> The following bug has been logged online:
>
> Bug reference: 1485
> Logged by: Hannes Erven
> Email address: h(dot)e(at)gmx(dot)at
> PostgreSQL version: 7.4.7
> Operating system: 2.6.10-gentoo-r6
> Description: upper case user names / creatuser
> Details:

> template1=# alter user Hannes password '***';
> ERROR: user "hannes" does not exist

> I then created another user, 'hannes', with createuser, and then I was able
> to alter the passwords, altough I now had two users in pg_user: hannes and
> Hannes.

The rules for SQL are: unquoted names get folded to lower case,
double-quoted names are left alone. The error message shows this - it
says "hannes" doesn't exist.

You could argue that the command-line tools should fold to lower-case
too, but that's not standard behaviour for command-line tools.

So - all you need to do is issue SQL like:
ALTER USER "Hannes" ...

Personally, I keep all objects and users lower-case only, it makes my
life easier.
--
Richard Huxton
Archonet Ltd