[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 robe):

 Ah that sorry I misunderstood the question.

 It assumes the version you have in your database is what you installed.
 For most extensions that generally works because they rarely add new
 functions.  For us not so much.

 People would have to know what version of postgis they installed and do
 something like


 {{{
 CREATE EXTENSION postgis FROM unpackaged VERSION "2.4.0";
 }}}

 So it would run the version 2.4.0 script instead of the default 2.5.0
 script.

 or you'd put in a guard in the unpackaged script to check (so you'll still
 need to isntall one of our temporary helper functions) and error out.

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