ERROR: column "total_cost" is of type numeric but expression is of type character varying

From: Antony Paul <antonypaul24(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: ERROR: column "total_cost" is of type numeric but expression is of type character varying
Date: 2005-02-11 10:41:55
Message-ID: 2989532e050211024126b599f9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
I am testing PostgreSQL 8.0.1. I compiled and installed it.
Downloaded JDBC driver postgresql-8.0-310.jdbc3.jar for JDK 1.4.(I was
unable to find it in source) Dumped my 7.3.3 database. Restored it in
new installation. Run the application and it gives this error.
The error is when I use setString() to insert into a numeric
field. I hope it is bug. Otherwise we have to rewrite our application.
The error message can be seen in server log also.

rgds
Antony Paul

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Markus Schaber 2005-02-11 10:55:18 Re: PLJava and Database Meta Data
Previous Message Thomas Hallgren 2005-02-11 10:17:43 Re: PLJava and Database Meta Data