What do you think of an Postgres option that would enable stripping of trailing blanks
from connect host variables when turned ON?
This would allow current behavior to be supported by ECPG and the Postgres server,
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 same problem,
in this case with an ODBC driver:
http://archives.postgresql.org/pgsql-interfaces/1998-08/msg00000.php
| Tom Lane <[EMAIL PROTECTED]>
09/08/2005 09:15 PM |
|
Michael Fuhr <[EMAIL PROTECTED]> 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
