Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #3582: CREATE USER via ODBC
- 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: Mon, 27 Aug 2007 18:13:43 -0400
"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
- References:
- BUG #3582: CREATE USER via ODBC
- From: Zoltan Szmutku
- BUG #3582: CREATE USER via ODBC
- Prev by Date: Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index
- Next by Date: Re: BUG #3504: Some listening sessions never return from writing, problems ensue
- Previous by thread: BUG #3582: CREATE USER via ODBC
- Next by thread: BUG #3583: IMPORT/EXPORT into PostgreSQL
- Indexes: