Re: migrate from 8.1 to 9.0 - Mailing list pgsql-general

From Cédric Villemain
Subject Re: migrate from 8.1 to 9.0
Date
Msg-id AANLkTinTCw79VnxZwgtOttR8jhWytMHDCPBso1PBAHZ0@mail.gmail.com
Whole thread Raw
In response to Re: migrate from 8.1 to 9.0  (Vick Khera <vivek@khera.org>)
List pgsql-general
2010/11/8 Vick Khera <vivek@khera.org>:
> On Mon, Nov 8, 2010 at 5:23 AM, Thom Brown <thom@linux.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@postgresql.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

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Syntax of: alter table ... add constraint ...
Next
From: Thomas Kellerer
Date:
Subject: Re: Syntax of: alter table ... add constraint ...