Skip site navigation (1) Skip section navigation (2)

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: 2007-08-27 22:13:43
Message-ID: 9471.1188252823@sss.pgh.pa.us (view raw or flat)
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

In response to

pgsql-bugs by date

Next:From: Peter KoczanDate: 2007-08-27 22:16:05
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Previous:From: Andrew SullivanDate: 2007-08-27 20:50:11
Subject: Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group