| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Zoltan Szmutku" <szmutku(dot)zoltan(at)freemail(dot)hu> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #3582: CREATE USER via ODBC |
| Date: | 2007-08-27 22:13:43 |
| Message-ID: | 9471.1188252823@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Koczan | 2007-08-27 22:16:05 | Re: BUG #3504: Some listening sessions never return from writing, problems ensue |
| Previous Message | Andrew Sullivan | 2007-08-27 20:50:11 | Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index |