Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group