Lists: | pgsql-bugs |
---|
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 |
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.
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 |
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: | Alex Hunsaker <badalex(at)gmail(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Shine <shine(dot)prakash(at)icasework(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5598: Compatibility modes |
Date: | 2010-08-04 16:51:44 |
Message-ID: | AANLkTimuOft2XgtZz1Va9LouEm2VBW2uaomvaztrWpgQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
On Wed, Aug 4, 2010 at 10:42, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Wed, Aug 4, 2010 at 10:53 AM, Shine <shine(dot)prakash(at)icasework(dot)com> wrote:
>> 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...
However, you can add them back if you must:
http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html
Be aware, they were removed for a reason. See
http://www.postgresql.org/docs/8.4/static/release-8-3.html section
E.17.2.1 for more.
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Alex Hunsaker <badalex(at)gmail(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Shine <shine(dot)prakash(at)icasework(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5598: Compatibility modes |
Date: | 2010-08-04 17:06:27 |
Message-ID: | 21793.1280941587@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Alex Hunsaker <badalex(at)gmail(dot)com> writes:
> On Wed, Aug 4, 2010 at 10:42, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> On Wed, Aug 4, 2010 at 10:53 AM, Shine <shine(dot)prakash(at)icasework(dot)com> wrote:
>>> 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...
> However, you can add them back if you must:
> http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html
Note that that hack actually does not work very well: it has unpleasant
side effects. You'd be far better advised to fix your application.
regards, tom lane