[postgis-tickets] [PostGIS] #3892: Review safety and behavior of CREATE EXTENSION from UNPACKAGED

[PostGIS]

#3892: Review safety and behavior of CREATE EXTENSION from UNPACKAGED
----------------------+---------------------------
  Reporter:  strk     |      Owner:  pramsey
      Type:  task     |     Status:  new
  Priority:  high     |  Milestone:  PostGIS 2.4.1
 Component:  postgis  |    Version:  2.4.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by strk):

 Regina: what if you loaded postgis-2.2.0 unpackaged and then install
 postgis-2.4.0 and {{{ CREATE EXTENSION postgis VERSION 2.4.0 FROM
 unpackaged }}} ?

 I've tried doing 2.1 to 2.3 and got:
 {{{
 ERROR:  aggregate st_clusterintersecting(geometry) does not exist
 }}}

 That one seems like the best case (an error is raised, although obscure).
 What's the worst case ?

 If we make a version check ourselves we get:

   1) More user-friendly error message
   2) Protection against worst case (yet to be defined..)

 *OR* (but could be also done in a second ticket?) we do the upgrade-on-
 load (dangerous in case the load would effectively be a _downgrade_ for
 any reason)

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3892#comment:4>
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.