[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:            |  
----------------------+-----------------------------------------------------

Comment(by robe):

 It doesn't you just don't create a migration path between if it would
 require a dump/reload. ALTER can never do a dump / reload.

 So if we created an extension for postgis version 1.5.3 for example, we
 would not define a script that takes it to postgis version 2.0.0 so if the
 user tries to toggle to 2.0.0 -- it would give an error -- "No migration
 path defined for 1.5.3 to 2.0.0"

 The main benefit is that the extension functions and tables do not get
 backed up.

 All that is added is a line in backup saying.

 CREATE EXTENSION ....

 So I would have to as part of the extension definition mark
 spatial_ref_sys as editable
 so it gets backed up but it wouldn't back up the structure just the data.

 I haven't investigated if you have a specific version how it would
 upgrade.  I think if it can't find the older version it upgrades to the
 next available.  So if you deleted all your postgis 1.5 extensions, it
 would upgrade to 2.0 extension.
 If you have both available though -- it would keep it at postgis 1.5

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1204#comment:2>
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.