Postgres Pro
Downloads
Home   >   mailing lists

Re: problems with types after update to 8.0 - Mailing list pgsql-general

From Richard Huxton
Subject Re: problems with types after update to 8.0
Date
Msg-id 42B7CAB2.4030903@archonet.com
Whole thread Raw
In response to problems with types after update to 8.0  ("Jason Tesser" <JTesser@nbbc.edu>)
Responses Re: problems with types after update to 8.0
List pgsql-general
Tree view 
Jason Tesser wrote:
> I just upgraded 7.4 to 8.0 and I have noticed that i am getting alot
> of error that are saying i have a type problem.  For example it is
> saying big int expected but it was sent character varying.

Is it right? Do you have an example you could give?

 > These
> same queries use to work in 7.4  I am using java and jboss.  My
> queries are all dynamic sql in prepared statements.

I'm guessing something is blindly quoting all values. Seems unlikely
that it's the jdbc driver.

Examples, please.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: peter pilsl
Date:
Subject: renumber id's in correct order (compact id's)
Next
From: "Ilja Golshtein"
Date:
Subject: Re: failed to find conversion function from "unknown" to ...