[postgis-devel] [PostGIS] #1217: add a raster_upgrade_20_minor script

PostGIS trac at osgeo.org
Sat Oct 1 20:26:05 PDT 2011


#1217: add a raster_upgrade_20_minor script
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  blocker         |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 I have a preliminary one building at r7930 and works fine for current
 version.

 However it doesn't upgrade one of my older dbs because I'm still missing a
 drop in the rtpostgis_drop.sql.in.c of a function that changed output
 parameters.

 Guys -- do me a favor, moving forward - If you are going to rename, change
 the arguments of, or output type of a function, please add the older
 version to the rtpostgis_drop.sql.inc.c file.

 The way upgrade script works -- it builds by first dropping obsolete
 functions (whcih I can't tell from teh rtpostgis.sql.inc.c

 and then sources the rtpostgis.sql.inc.c to CREATE OR REPLACE functions.

 Functions that have changed signature or outputs need to be dropped first
 otherwise the CREATE OR REPLACE compalins the signature has changed etc.

 I'll close this out once I've found the remaining offending obsolete
 signatures.

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