Hi Kris,
>> i am using Postgres 7.4.2 with jdbc. Every time i try to select a
>> varchar the SQL generated by the jdbc driver uses RTRIM(t0.columnname)
>> which breaks an existing application. Is this normal, can we disable
>> the RTRIM usage?
>
> I assume from this bold claim that you have written an SQL query like
> "SELECT t0.columnname FROM ..." and enabled statement logging in the
> server and seen the executed query come through as "SELECT
> RTRIM(t0.columnname) FROM ...". If this is the case then you are not
> using the community supported jdbc driver because it never uses rtrim,
> and
> you need to contact whoever wrote the jdbc driver you are using.
>
I use the JDBC driver from the postgres742 installation. But i am also
using a middleware / eor tool named webobjects from apple ... and one
of our sourcecodes superclasses generated the rtrim. Thanks for your
hint, it works now.
Regards David