Ticket #1204 (closed task: fixed)
Need to generate upgrade script for topology
|Reported by:||robe||Owned by:||strk|
I wanted to test out the upgrade features of extension, but in order to do that, I need an upgrade script for topology.
I assume we would build it so it has everything but the create type, create schema, create table stuff using the perl script we have for postgis. Not sure how to do that.
We'll need the same for raster, which I think I already have as a ticket.
The CREATE EXTENSION can also support non-numeric versions, so pre-relese I was just going to make the versions
postgis_topology version 2.0.0a1 etc. We'd be using ssentially the same script to upgrade for each so i'd just need to copy them to files like
postgis_topology--2.0.0a1--2.0.0a2.sql etc which I'll incorporate in the extension make.
These get daisy chained if it can't find a way to go from v1--v2 with a single file. Though there doesn't seem to be a mechanism to put in a wild card version
e.g. 2.0--2.0.0 which is a bit of a bummer.
Then when people upgrade, they would run the sql command:
ALTER EXTENSION postgis_topology UPDATE TO "2.0.0a2";