SVN updates applied in PostgreSQL 9.1+

[darkblueb]

currently, to build and test new code from topology svn, either tricky sym links or a complete dump and reload of the test database appear to be necessary when using CREATE EXTENSION sort of libraries, such as postgis_topology.

wouldn't it be better to have a way to cleanly reload topology after building and installing? same for other EXTENSION based additions, most likely...

[robe]

Yah that's one of the downsides of extension that it won't upgrade from same version to same version. It's only an issue for svn version of course.

As a hack -- what I do is change the control file to be something like PostGIS 2.0.1SVNrxyz

and then create a copy of the script to be from my old to faked version path.

I agree we should come up with something more elegant or get in the habit of having interim version stops whenever we change the scripts. strk won't like that :).

One thought i had is to have an unbundle script. Basically a script that unbundles your postgis from extension so you can run the regular upgrade script and then rebundles it.

That we could achieve in one step I guess. It's essentially how we get the update from extension to work. But it won't have the nice "ALTER EXTENTION postgis UPDATE To" feel. Live on the edge have to pay some tolls :)