| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Shine <shine(dot)prakash(at)icasework(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5598: Compatibility modes |
| Date: | 2010-08-04 16:42:04 |
| Message-ID: | AANLkTi=p_2QaqOKvwv6RjExVsTW_HZ9E8fNqQejf4T1r@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, Aug 4, 2010 at 10:53 AM, Shine <shine(dot)prakash(at)icasework(dot)com> wrote:
> We are planning to upgrade from Postgresql 8.2 to 8.4, and we have hit the
> following error when running our application against it.
>
> org.postgresql.util.PSQLException: ERROR: operator does not exist: character
> varying = integer
>
> We have noticed many people have reported this issue and that this was an
> intentional change on your side.
>
> We would like to know if there is a workaround built into postgres by
> setting some kind of COMPATIBILITY variable (similar to SQL SERVER 2005 /
> 2008)...
Sorry, there is no such mode...
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-08-04 16:44:40 | Re: string_agg delimiter having no effect with order by |
| Previous Message | Robert Haas | 2010-08-04 16:40:09 | Re: string_agg delimiter having no effect with order by |