[postgis-tickets] r15970 - postgis_extensions_upgrade(). Can't remember which postgis extensions you installed and are two lazy to figure out and upgrade each with ALTER EXTENSION.

Sandro Santilli strk at kbt.io
Thu Oct 12 02:44:47 PDT 2017


On Wed, Oct 11, 2017 at 10:11:50AM -0700, Regina Obe wrote:
> Author: robe
> Date: 2017-10-11 10:11:50 -0700 (Wed, 11 Oct 2017)
> New Revision: 15970
> 
> Modified:
>    trunk/NEWS
>    trunk/doc/reference_management.xml
>    trunk/postgis/postgis.sql.in
> Log:
> postgis_extensions_upgrade().  Can't remember which postgis extensions you installed and are two lazy to figure out and upgrade each with ALTER EXTENSION.
> just do 
> 
> SELECT postgis_extensions_upgrade();

Regina, would it make sense to implement this in C, so that 
you could get a new version w/out running the upgrade but simply
by having a new library installed ?

Think the raster-split case: you'll need the
postgis_extension_upgrade() function rewritten but
it can only be done by running the upgrade first...

--strk;


More information about the postgis-tickets mailing list