Re: Add casts & related fixes - Mailing list pgsql-jdbc

From Kim Ho
Subject Re: Add casts & related fixes
Date
Msg-id 1057684010.21368.92.camel@topanga.toronto.redhat.com
Whole thread Raw
In response to Re: Add casts & related fixes  (Barry Lind <blind@xythos.com>)
List pgsql-jdbc
Hm, you're right. Maybe there's a better way to do this then. Perhaps
it'll be something I can change in the registerOutParam patch to get it
to work.

I'll have to run CTS to find a specific case.

Cheers,

Kim

On Tue, 2003-07-08 at 11:46, Barry Lind wrote:
> Kim,
>
> Can you provide some examples of the type of problem you are trying to
> solve here.  I am wondering if there is a different way to solve it than
> adding these casts.  This patch will break backward compatibility with
> some existing code.  That may be necessary, but I would like to avoid it
> if possible.
>
> Specifically statements along the lines of:
>
> select foo from ?
>
> will no longer work as this would now get translated into:
>
> select foo from table::text
>
> There are also other subtle ways that adding the cast will cause
> problems.  We added casts in the past for int8 and int2 binds in order
> to get them to use indexes, but ended up removing the casts because of
> problems with breaking existing apps.
>
> thanks,
> --Barry
>


pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: Strange exception opening JDBC connection
Next
From: Paul Thomas
Date:
Subject: Re: Strange exception opening JDBC connection