BUG #5598: Compatibility modes

From: "Shine" <shine(dot)prakash(at)icasework(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5598: Compatibility modes
Date: 2010-08-04 14:53:02
Message-ID: 201008041453.o74Er2AS033723@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5598
Logged by: Shine
Email address: shine(dot)prakash(at)icasework(dot)com
PostgreSQL version: 8.4
Operating system: Windows XP
Description: Compatibility modes
Details:

Hi,

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)...

This would be helpful in getting our system deployed using the new database,
otherwise we would have to push back our release to a later date.

Regards,

Shine Prakash
Software Consultant
iCasework Ltd.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-08-04 15:29:39 Re: string_agg delimiter having no effect with order by
Previous Message Pavel Stehule 2010-08-04 14:37:10 Re: string_agg delimiter having no effect with order by