Re: migrate from 8.1 to 9.0

From: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
To: Vick Khera <vivek(at)khera(dot)org>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: migrate from 8.1 to 9.0
Date: 2010-11-08 15:08:49
Message-ID: AANLkTinTCw79VnxZwgtOttR8jhWytMHDCPBso1PBAHZ0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/11/8 Vick Khera <vivek(at)khera(dot)org>:
> On Mon, Nov 8, 2010 at 5:23 AM, Thom Brown <thom(at)linux(dot)com> wrote:
>> Implicit casting might bite you since that was removed in 8.3.
>>
>
> Also if you use bytea fields to store binary data, the encoding format
> on return of the data is different.  Make sure your client library
> handles that for you (or explicitly code for it).
>
> These are the two major issues we had to address between our
> 8.1->8.3->9.0 update over the last few  years.

It is also possible to hit issues with plpgsql code quality.

>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Cédric Villemain               2ndQuadrant
http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2010-11-08 15:10:18 Re: Syntax of: alter table ... add constraint ...
Previous Message Alexander Farber 2010-11-08 14:50:32 Syntax of: alter table ... add constraint ...