Re: BUG #3582: CREATE USER via ODBC

"Zoltan Szmutku" <szmutku.zoltan@freemail.hu> writes:
> I try save a new account:
> ?SQLEXEC(1,"CREATE ROLE TESZT LOGIN ENCRYPTED PASSWORD 'nincsen' SUPERUSER
> CREATEDB NOCREATEROLE")

This isn't a bug.  Since you didn't double-quote the role name, it's
converted to lower case, the same as any other unquoted SQL identifier.
So CREATE ROLE TESZT does the same thing as CREATE ROLE teszt.

Whether to smash a supplied username to lowercase at login time is the
decision of the client-side software.  Most doesn't, and it looks like
that includes ODBC.

            regards, tom lane