Re: problems with types after update to 8.0

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jason Tesser <JTesser(at)nbbc(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problems with types after update to 8.0
Date: 2005-06-21 08:07:14
Message-ID: 42B7CAB2.4030903@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ilja Golshtein 2005-06-21 08:12:24 Re: failed to find conversion function from "unknown" to ...
Previous Message peter pilsl 2005-06-21 08:06:40 renumber id's in correct order (compact id's)