Re: ERROR: column "total_cost" is of type numeric but expression

From: Antony Paul <antonypaul24(at)gmail(dot)com>
To: Markus Schaber <schabios(at)logi-track(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ERROR: column "total_cost" is of type numeric but expression
Date: 2005-02-11 11:47:46
Message-ID: 2989532e050211034710015504@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)logi-track(dot)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(at)logi-track(dot)com | www.logi-track.com
>
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Hallgren 2005-02-11 12:07:47 Re: PLJava and Database Meta Data
Previous Message Markus Schaber 2005-02-11 11:37:25 Re: ERROR: column "total_cost" is of type numeric but expression