[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