[postgis-devel] Fwd: PostGIS 1.4

[Mark Cave-Ayland]

Paul Ramsey wrote:

> Some issues on the soft upgrade, where the client soft upgrades an 
> 8.3/1.3 database to 8.3/1.4, then dumps and restores into 8.4 to create 
> an 8.4/1.4 database (seems like the most likely upgrade path, and the 
> one we should recommend).
> 
> These are aesthetic, the actual restore is good. I was thinking that 
> since our PgSQL requirement is 8.2, we could add DROP IF EXISTS 
> statements to the top of postgis.sql for the removed functions and then 
> postgis_upgrade.sql would inherit them, and everything would work hunky 
> dory.
> 
> Thoughts?
> 
> P

I do like Regina's idea of creating a fresh 1.4 database, removing the 
old 1.3 shared library and then letting the restore ignore the functions 
that aren't present anymore. This seems to be a good way to finally get 
a clean install if people have been doing constant upgrades.


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063