Arun P.L <arunpl@hotmail.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°