"Zoltan Szmutku" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
