[postgis-tickets] [PostGIS] #3913: Include minor upgrade in extension-from-unpackaged script

[PostGIS]

#3913: Include minor upgrade in extension-from-unpackaged script
----------------------+---------------------------
  Reporter:  strk     |      Owner:  robe
      Type:  defect   |     Status:  reopened
  Priority:  medium   |  Milestone:  PostGIS 2.5.0
 Component:  postgis  |    Version:  2.4.x
Resolution:           |   Keywords:
----------------------+---------------------------
Changes (by strk):

 * status:  closed => reopened
 * resolution:  fixed =>


Comment:

 I think this commit might have introduced a conceptual error.
 When including minor upgrade it may happen that the minor upgrade runs a
 {{{ CREATE }}} statement, so that the created new object is installed in
 the target extension automatically.
 Later on, when {{{ ALTER EXTENSION .. ADD }}} is called if the object is
 already in the extension you get an error like: {{{ ERROR:  view
 raster_columns is already a member of extension "postgis" }}}

 Regina: can you produce such occurrence ? I'm not sure our bots are
 triggering it (but could be wrong) -- I'm getting it manually from my
 "split-raster-from-core" branch...

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