"Zoltan Szmutku" <szmutku(dot)zoltan(at)freemail(dot)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
In response to
pgsql-bugs by date
|Next:||From: Peter Koczan||Date: 2007-08-27 22:16:05|
|Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue|
|Previous:||From: Andrew Sullivan||Date: 2007-08-27 20:50:11|
|Subject: Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index|