Type cast errors in version 9.2 while upgrade

From: Arun P(dot)L <arunpl(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Type cast errors in version 9.2 while upgrade
Date: 2013-06-18 12:38:06
Message-ID: SNT136-W2789816F28BDD200706217DB8C0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

We are doing a postgresql upgrade from version 7.4.30 to 9.2. While testing the queries in newer version, the following error is obtained for some of the queries which were working fine in older version.

"ERROR: operator does not exist: character varying = integer.HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts."
When modified the script to add ' '(quotes) to integer values, the queries are working fine in 9.2 version also. Is this the best fix for this? or is there any other way (adding new type cast??) which will help to overcome this without modifying all the queries? Please advise.

Thanks for your help in advance,Arun

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Kane 2013-06-18 13:08:21 Foreign Key constraint violation
Previous Message 高健 2013-06-18 09:09:05 I want to make an example of using parameterized path