Re: caveats upgrading from 7.0.3 to 7.2.x

On Friday 22 November 2002 18:12, Dave [Hawk-Systems] wrote:
> am preparing to upgrade the postgres on our servers to 7.2.x from 7.0.3
>
> aside from a dump restore requirements and backing up the 7.0.3
> installation just in case something goes awry, is there anything from a
> data type or syntax that will cause any major hurdles as a result of this
> upgrade?
>
> Appreciate any forewarnings.

IIRC there aren't any negative syntax changes, i.e. which
will break something. timestamp() has gone away, and
SELECT ... LIMIT x,y has been replaced with SELECT ... LIMIT x OFFSET y
in 7.3.

The release history is here:

http://www.postgresql.org/idocs/index.php?release.html

http://www.postgresql.org/idocs/index.php?release-7-2.html

http://www.postgresql.org/idocs/index.php?release-7-1.html

I would recommend testing before you make the change though.

Ian Barwick
barwick(at)gmx(dot)net