What do you think of an Postgres option that would enable stripping of
from connect host variables when turned ON?
This would allow current behavior to be supported by ECPG and the Postgres
but allow applications that need the behavior (like a Cobol/SQL
preprocessor for Postgres),
to make use of it.
When I searched the mail archives, I found that others had run into this
in this case with an ODBC driver:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
09/08/2005 09:15 PM
Michael Fuhr <mike(at)fuhr(dot)org>
Jim(dot)Gray(at)Bull(dot)com, pgsql-bugs(at)postgresql(dot)org, Ken(dot)Rosensteel(at)Bull(dot)com
Re: [BUGS] BUG #1862: ECPG Connect, host variable trailing blanks
Michael Fuhr <mike(at)fuhr(dot)org> writes:
> If you think this behavior should be changed then propose it on
> pgsql-hackers and discuss it with the developers.
I doubt we'll consider changing it. If I haven't missed any of the
details, the critical points here are
(1) User names containing trailing (or embedded) spaces are legal.
Not a very good idea maybe, but legal both per SQL spec and per
our historical practice.
(2) Making ECPG strip trailing spaces would render it unable to
connect as such a user.
I don't think ECPG has any business deciding that trailing spaces are
insignificant. If that's the case in your application environment,
fine: strip the spaces at the application level. But don't expect a
general-purpose library to make that policy choice for you.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Lee Benson||Date: 2005-09-10 04:52:08|
|Subject: BUG #1873: "Invalid username specified" during install|
|Previous:||From: Hugo Cesar||Date: 2005-09-09 16:06:14|
|Subject: BUG #1872: Failed to create process: 2!|