Re: [GENERAL] Type cast errors in version 9.2 while upgrade

2013-06-18 Thread Andreas Kretschmer
Arun P.L wrote: > 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 var

Re: [GENERAL] Type cast errors in version 9.2 while upgrade

2013-06-18 Thread Alban Hertroys
On 18 June 2013 14:38, Arun P.L wrote: > > 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 n

[GENERAL] Type cast errors in version 9.2 while upgrade

2013-06-18 Thread Arun P . L
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