Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 67DDB2E002F for ; Sat, 12 Apr 2008 17:20:57 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 57212-07 for ; Sat, 12 Apr 2008 17:20:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.190]) by developer.postgresql.org (Postfix) with ESMTP id EFBDE2E002C for ; Sat, 12 Apr 2008 17:20:53 -0300 (ADT) Received: by ti-out-0910.google.com with SMTP id y6so371814tia.5 for ; Sat, 12 Apr 2008 13:20:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=jT5Ig6TD+KYXjC7BBCbf3fgbSWdfXlax0Z7n3aqQMJ0=; b=JfvgZ/qx89VSMAnQUk78QFeT2m5aXp0CWMn6lkmlXaWKONLhDEP3hYFNhX7u6f1NYN5zMZXXwUaY5Otu5VrqnD0TKJJNwsM8XeDaLIq27QE/k/EOKC2AvTbQzlt30zTlj44okftNvw3yAsXX9ollTgMttUdC/UJA0Ycpw91qWUQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=HQyPmAFFPPA5z61o/hNMxgZ8UdGz/lSQ4Xj9Edp02k8oHdrgATAzH5prlR3POy8r6DcGqeRyL1BNK1bvnVNSTtEF8Fc67+KOMTOJ11YUMD4nrBkWi9TaI0q1YUsszpzHqjbGKNICXMvcBPYOHmgDfFYdZ2P/KbCl6I4PvpRCQOY= Received: by 10.110.73.3 with SMTP id v3mr309831tia.27.1208031651852; Sat, 12 Apr 2008 13:20:51 -0700 (PDT) Received: by 10.110.49.5 with HTTP; Sat, 12 Apr 2008 13:20:51 -0700 (PDT) Message-ID: <4478b4ac0804121320w1a6bfceehd0a4c7fbe8abb970@mail.gmail.com> Date: Sun, 13 Apr 2008 01:50:51 +0530 From: "=?WINDOWS-1252?Q?Kranti_K_K_Parisa=99?=" To: "Ray Stell" Subject: Re: PostgreSQL 8.1 to 8.3 Cc: pgsql-admin@postgresql.org In-Reply-To: <20080412200850.GA4098@cns.vt.edu> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5989_22748670.1208031651852" References: <4478b4ac0804121208x7fdd8419pf3f9675c397f62e3@mail.gmail.com> <20080412192353.GA3188@cns.vt.edu> <4478b4ac0804121247t3019cb67jc212c304edc805cf@mail.gmail.com> <20080412200850.GA4098@cns.vt.edu> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/110 X-Sequence-Number: 28874 ------=_Part_5989_22748670.1208031651852 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 ------=_Part_5989_22748670.1208031651852 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
------=_Part_5989_22748670.1208031651852--