Re: [BUGS] BUG #5598: Compatibility modes

2010-08-04 Thread Tom Lane
Alex Hunsaker writes: > On Wed, Aug 4, 2010 at 10:42, Robert Haas wrote: >> On Wed, Aug 4, 2010 at 10:53 AM, Shine 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)... >> >> So

Re: [BUGS] BUG #5598: Compatibility modes

2010-08-04 Thread Alex Hunsaker
On Wed, Aug 4, 2010 at 10:42, Robert Haas wrote: > On Wed, Aug 4, 2010 at 10:53 AM, Shine 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... H

Re: [BUGS] BUG #5598: Compatibility modes

2010-08-04 Thread Robert Haas
On Wed, Aug 4, 2010 at 10:53 AM, Shine 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 not