From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Type cast errors in version 9.2 while upgrade |
Date: | 2013-06-18 13:30:21 |
Message-ID: | 20130618133021.GA7255@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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°
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Fitzpatrick | 2013-06-18 15:54:19 | Using functions to calc field values in other table |
Previous Message | Alban Hertroys | 2013-06-18 13:29:18 | Re: Type cast errors in version 9.2 while upgrade |