Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 1909B2E0083 for ; Sat, 12 Apr 2008 17:08:55 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 44318-05 for ; Sat, 12 Apr 2008 17:08:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by developer.postgresql.org (Postfix) with ESMTP id 818B92E007F for ; Sat, 12 Apr 2008 17:08:51 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 44F2B118A70; Sat, 12 Apr 2008 16:08:50 -0400 (EDT) Date: Sat, 12 Apr 2008 16:08:50 -0400 From: Ray Stell To: Kranti K K Parisa? Cc: pgsql-admin@postgresql.org Subject: Re: PostgreSQL 8.1 to 8.3 Message-ID: <20080412200850.GA4098@cns.vt.edu> References: <4478b4ac0804121208x7fdd8419pf3f9675c397f62e3@mail.gmail.com> <20080412192353.GA3188@cns.vt.edu> <4478b4ac0804121247t3019cb67jc212c304edc805cf@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4478b4ac0804121247t3019cb67jc212c304edc805cf@mail.gmail.com> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/109 X-Sequence-Number: 28873 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.