Re: Type cast errors in version 9.2 while upgrade

Arun P.L <arunpl(at)hotmail(dot)com> 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 varying = integer.
>
> HINT: No operator matches the given name and argument type(s). You might need
> to add explicit type casts."

That's a problem since 8.2 -> 8.3, now we don't have a lot of implicit casts. You
can redefine that, read:
http://petereisentraut.blogspot.de/2008/03/readding-implicit-casts-in-postgresql.html

But i think you should redesign your code ...

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°