Re: Add casts & related fixes

From: Kim Ho <kho(at)redhat(dot)com>
To: Barry Lind <blind(at)xythos(dot)com>
Cc: pgsql-jdbc-list <pgsql-jdbc(at)postgresql(dot)org>, Dave Cramer <Dave(at)micro-automation(dot)net>, Fernando Nasser <fnasser(at)redhat(dot)com>
Subject: Re: Add casts & related fixes
Date: 2003-07-08 17:06:49
Message-ID: 1057684010.21368.92.camel@topanga.toronto.redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Paul Thomas 2003-07-08 18:37:31 Re: Strange exception opening JDBC connection
Previous Message Barry Lind 2003-07-08 17:01:46 Re: Strange exception opening JDBC connection