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

Re: The new driver and PostgreSQL7.1.3

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: <chantal(dot)ackermann(at)web(dot)de>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: The new driver and PostgreSQL7.1.3
Date: 2001-12-20 18:45:24
Message-ID: NEBBLAAHGLEEPCGOBHDGMEKEEBAA.nickf@ontko.com (view raw or flat)
Thread:
Lists: pgsql-jdbc

> I still want
> to be sure
> that the name of the jar does not mean that it can't be used
> together with
> the 7.1.3 version of the database.

My understanding based on earlier posts from "the people who should know" is
that the 7.2 driver is compatible with 7.1.3. I've been using it in this way
on a development system with no problems for a while, but of course, I don't
exercise every function.

> I get the Exception:
> java.sql.SQLException: ERROR:  Unable to identify an operator '='
> for types 'int4' and 'text'
>         You will have to retype this query using an explicit cast

If you can send the prepared statement text, table create statement, and the
line you get the error on to the list, it would help solve this.

One simple thing you might check first- The last time I got this error, I
had mis-counted my columns, and so I was off by one & really was trying to
stuff a string into an integer field.

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf(at)ontko(dot)com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/





In response to

Responses

pgsql-jdbc by date

Next:From: Hunter HillegasDate: 2001-12-20 19:38:28
Subject: FW: JDBC Driver Munging My Text?
Previous:From: Dave CramerDate: 2001-12-20 18:33:07
Subject: Re: The new driver and PostgreSQL7.1.3

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