Re: ERROR: column "total_cost" is of type numeric but expression - Mailing list pgsql-jdbc

From Antony Paul
Subject Re: ERROR: column "total_cost" is of type numeric but expression
Date
Msg-id 2989532e050211034710015504@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: column "total_cost" is of type numeric but expression  (Markus Schaber <schabios@logi-track.com>)
List pgsql-jdbc
Now I understand why 8.0 drive dont print query parameters in the
server log while 7.4 prints query parameters since 8.0 uses real
prepared statements.

rgds
Antony Paul


On Fri, 11 Feb 2005 12:37:25 +0100, Markus Schaber
<schabios@logi-track.com> wrote:
> Hi, Antony,
>
> Antony Paul schrieb:
> > Updating application is going to be a lot of work. If it breaks
> > existing applications why it is implemented. I dont think type
> > checking is a big thing. What is its use ?.
>
> I'm not 100% shure, as I'm no jdbc developer, but I think the 8.0 driver
> consequently uses server-side prepared statements from V3 protocol, for
> speed benefits, and thus needs all typing information. (I do not know
> whether it is possible to send untyped parameters via this approach.)
>
> Markus
> --
> markus schaber | dipl. informatiker
> logi-track ag | rennweg 14-16 | ch 8001 zürich
> phone +41-43-888 62 52 | fax +41-43-888 62 53
> mailto:schabios@logi-track.com | www.logi-track.com
>
>
>

pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: ERROR: column "total_cost" is of type numeric but expression
Next
From: Thomas Hallgren
Date:
Subject: Re: PLJava and Database Meta Data