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

PostGIS trac at osgeo.org
Thu Sep 22 07:47:44 PDT 2011


#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 strk):

 Now you are a sed hacker you could try with that. Who needs perl anymore !
 :)

 How does "ALTER EXTENSION UPDATE" know if it's possible to update w/out
 dump-reload ?

 In other words.. how do we do when we _need_ to change something in CREATE
 TABLE / CREATE TYPE. For example you just droped an ALTER TABLE ADD COLUMN
 of mine (for topology.topology) which was there for the specific purpose
 of keeping the .sql file usable for upgrading since the stone-age of
 topology. That one was an update adding
 a field to topology.topology. How is that done with ALTER EXTENSION ?

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


More information about the postgis-devel mailing list