Re: Type cast errors in version 9.2 while upgrade
От | Andreas Kretschmer |
---|---|
Тема | Re: Type cast errors in version 9.2 while upgrade |
Дата | |
Msg-id | 20130618133021.GA7255@tux обсуждение исходный текст |
Ответ на | Type cast errors in version 9.2 while upgrade (Arun P.L <arunpl@hotmail.com>) |
Список | pgsql-general |
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°
В списке pgsql-general по дате отправления: