Re: BUG #5598: Compatibility modes - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5598: Compatibility modes
Date
Msg-id AANLkTi=p_2QaqOKvwv6RjExVsTW_HZ9E8fNqQejf4T1r@mail.gmail.com
Whole thread Raw
In response to BUG #5598: Compatibility modes  ("Shine" <shine.prakash@icasework.com>)
Responses Re: BUG #5598: Compatibility modes  (Alex Hunsaker <badalex@gmail.com>)
List pgsql-bugs
On Wed, Aug 4, 2010 at 10:53 AM, Shine <shine.prakash@icasework.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

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: string_agg delimiter having no effect with order by
Next
From: Tom Lane
Date:
Subject: Re: string_agg delimiter having no effect with order by