Postgres Pro
Downloads
Home   >   mailing lists

Re: Help related to Postgresql for RHEL 6.5 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Help related to Postgresql for RHEL 6.5
Date
Msg-id 5400978C.2090608@aklaver.com
Whole thread Raw
In response to Re: Help related to Postgresql for RHEL 6.5  ("Yogesh. Sharma" <Yogesh1.Sharma@nectechnologies.in>)
List pgsql-general
Tree view 
On 08/28/2014 09:14 PM, Yogesh. Sharma wrote:
> Dear David,
>
>> Are you currently using PostgreSQL?
> Currently we are using PostgreSQL 8.1.18 version on RHEL 5.8.
> Now we plan to update this to PostgreSQL 9.0 version with  RHEL6.5. As in verion 9.0 I found least Compatibilities.

So what are the things you are concerned about?

>
> So, please guide me.

If you are going from 8.1 to any supported version you will be dealing
with the type casting changes introduced in 8.3

http://www.postgresql.org/docs/9.3/interactive/release-8-3.html

E.97.2.1. General

     Non-character data types are no longer automatically cast to TEXT
(Peter, Tom)

I would spend some time testing that.


>
> Regards,
> Yogesh

>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: John McKown
Date:
Subject: Re: Transforming pg_dump output to be compatible with SQLite 3.x
Next
From: Steve Crawford
Date:
Subject: Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions