rtpostgis_upgrade_20_minor.sql doesn't work

[nicklas]

When I try to upgrade this:

"POSTGIS="2.0.0alpha7SVN r9347" GEOS="3.4.0dev-CAPI-1.8.0" PROJ="Rel. 4.8.0, 20 February 2012" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8" USE_STATS (core procs from "2.0.0alpha7SVN r9322" need upgrade) (raster procs from "2.0.0alpha7SVN r9322" need upgrade)"

with rtpostgis_upgrade_20_minor.sql

I get:

Error: cannot drop function st_union(raster, text)because extension postgis requires it

[strk]

Did you install postgis with "create extension" ? I suspect in that case the correct way to upgrade would be trough the extension mechanism as well (not that I think it would work)

The dependency of postgis ON raster does sound bogus, btw. Could be due to the fact that the so-called "postgis extension" includes raster, which is kind of puzzling.

I'd leave this to the ones who thought keeping "core" and "raster" extensions together was a good idea...

[robe]

Nicklas, Nice to see you back in the groove again :).

As strk said sounds like your postgis was installed with extensions. You can't upgrade an extension installed postgis with the scripts, you have to use

ALTER EXTENSION postgis  UPDATE TO ..

​http://www.postgresql.org/docs/devel/static/sql-alterextension.html

Sadly extension updates have to be done at version milestones since your from and to can't be the same version so you'll need to wait till pramsey releases the next release today.

However that said -- there is an issue with the update scripts for extension which I have noted in http://trac.osgeo.org/postgis/ticket/1630 which I hope to fix before beta comes out today.

[nicklas]

great :-)

invalid tickets is good news!