Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas) - Mailing list pgsql-sql

From Jasen Betts
Subject Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)
Date
Msg-id jtqokv$cnh$3@reversiblemaps.ath.cx
Whole thread Raw
In response to must appear in GROUP by clause issue  (George Woodring <george.woodring@iglass.net>)
List pgsql-sql
On 2012-07-10, Chris Preston <chris@thetrafalgartravel.com> wrote:
>
> Hello all,
> How far can I get to a higher version of PostgreSQL by just entering a
> command line instruction to upgrade without any major effort?

8.1.23

going to 8.2.x or later is going to need more effort, especially if any
of your code relies on any of 8.1's quirks (like comparing integers to
strings) - if you do decide to abandon 8.1.x you may as well make it a
big change and go to 9.1

-- 
⚂⚃ 100% natural



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How does Numeric division determine precision?
Next
From: Victor Sterpu
Date:
Subject: Selecting data from XML