[postgis-devel] [PostGIS] #1204: Need to generate upgrade script for topology

[PostGIS]

#1204: Need to generate upgrade script for topology
----------------------+-----------------------------------------------------
 Reporter:  robe      |       Owner:  strk         
     Type:  task      |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.0.0
Component:  topology  |     Version:  trunk        
 Keywords:            |  
----------------------+-----------------------------------------------------
 strk,

 I wanted to test out the upgrade features of extension, but in order to do
 that, I need an upgrade script for topology.

 I assume we would build it so it has everything but the create type,
 create schema, create table stuff using the perl script we have for
 postgis.  Not sure how to do that.

 We'll need the same for raster, which I think I already have as a ticket.

 The CREATE EXTENSION can also support non-numeric versions, so pre-relese
 I was just going to make the versions

 postgis_topology version 2.0.0a1 etc.  We'd be using ssentially the same
 script to upgrade for each so i'd just need to copy them to files like

 postgis_topology--2.0.0a1--2.0.0a2.sql etc which I'll incorporate in the
 extension make.

 These get daisy chained if it can't find a way to go from v1--v2 with a
 single file.  Though there doesn't seem to be a mechanism to put in a wild
 card version

 e.g. 2.0--2.0.0 which is a bit of a bummer.

 Then when people upgrade, they would run the sql command:

 ALTER EXTENSION postgis_topology UPDATE TO "2.0.0a2";

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1204>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.