Arun P.L <arunpl@xxxxxxxxxxx> 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° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
