From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
---|---|
To: | Aras Angelo <araskoktas(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: upgrading postgresql broke some queries |
Date: | 2009-08-04 19:20:10 |
Message-ID: | 1249413610.28585.12.camel@hp-laptop2.gunduz.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, 2009-08-04 at 13:02 -0600, Aras Angelo wrote:
> I recently upgraded my box to the latest version. The previous one
> was a bit outdated. Apparently we have some bad structure formatting
> in our db design, cause the latest version broke our software. The
> issue is some character varying fields are used in queries joining to
> integers. The old db server was just allowing us to join INT to CHAR.
> Now its not.
This was one of the changes in 8.3. Please see here:
http://www.postgresql.org/docs/current/static/release-8-3.html#AEN96354
> I was wondering if there is an easy global solution for this.
Until you fix your app, you can re-add these casts:
http://wiki.postgresql.org/images/d/d1/Pg83-implicit-casts.sql
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-08-04 19:23:01 | Re: upgrading postgresql broke some queries |
Previous Message | Scott Marlowe | 2009-08-04 19:13:34 | Re: RAID for the DB filesystem |