Re: PostgreSQL 8.1 to 8.3 - Mailing list pgsql-admin

From Kranti K K Parisa™
Subject Re: PostgreSQL 8.1 to 8.3
Date
Msg-id 4478b4ac0804121320w1a6bfceehd0a4c7fbe8abb970@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 8.1 to 8.3  (Ray Stell <stellr@cns.vt.edu>)
Responses Re: PostgreSQL 8.1 to 8.3  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-admin
That means, we have to get the values into specific data types than the general string variables?

On Sun, Apr 13, 2008 at 1:38 AM, Ray Stell <stellr@cns.vt.edu> wrote:
On Sun, Apr 13, 2008 at 01:17:45AM +0530, Kranti K K Parisa? wrote:
> Will look into that.

There were some list rumblings when 8.3 was released about this
feature:

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

so, apps will need to be checked for this use.

Upgrade is a straight forwared process, but does require dump/restore/downtime:
http://www.postgresql.org/docs/8.3/interactive/install-upgrading.html
seemless in my experience.



--

Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625

pgsql-admin by date:

Previous
From: Ray Stell
Date:
Subject: Re: PostgreSQL 8.1 to 8.3
Next
From: Ray Stell
Date:
Subject: Re: PostgreSQL 8.1 to 8.3