[postgis-tickets] [PostGIS] #4643: PostgreSQL 13 no longer supports FROM in CREATE EXTENSION

[PostGIS]

#4643: PostgreSQL 13 no longer supports FROM in CREATE EXTENSION
------------------------------------+---------------------------
  Reporter:  robe                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  blocker                |  Milestone:  PostGIS 3.1.0
 Component:  build/upgrade/install  |    Version:  master
Resolution:                         |   Keywords:
------------------------------------+---------------------------

Comment (by robe):

 Thread from IRC


 {{{
 02:17:49        robe2:  Komzpa good job except I don't see the release on
 the dev mailing list though I do see it on users list
 https://postgis.net/2020/02/20/postgis-3.0.1/
 02:17:50        sigq:   Title: PostGIS PostGIS 3.0.1 (at postgis.net)
 02:18:12        robe2:  Komzpa the exploding part yah that's not mentioned
 in the HOW TO :) it wasn't always that way
 02:18:48        robe2:  that was my hack job to try to get something that
 only works for PHP 5 / PHP 7 to work on PHP 7.3
 03:59:42        robe2:  RhodiumToad I assume this is an intentional
 change? What replaces it? https://trac.osgeo.org/postgis/ticket/4643
 03:59:43        sigq:   Title: #4643 (PostgreSQL 13 no longer supports
 FROM in CREATE EXTENSION) – PostGIS (at trac.osgeo.org)
 04:04:18        RhodiumToad:    FROM unpackaged is gone
 04:04:51        RhodiumToad:    without that, the only way to upgrade an
 extenstion is from the version that's already installed, so no FROM option
 is needed
 04:04:51        robe2:  RhodiumToad so how do people upgrade from
 unpackaged?
 04:05:33        robe2:  oh so it's just CREATE EXTENSION postgis; and
 system checks if the things are installed?
 04:06:07        RhodiumToad:    upgrading from unpackaged isn't supported
 any more (from pg 13+)
 04:06:38        robe2:  :(
 04:07:04        RhodiumToad:    it gets in the way of allowing "trusted"
 extensions which are installable by non-superusers
 04:07:12        robe2:  In PostGIS we have a function that upgrades old
 version to new version so it's upgrade to the latest
 04:07:46        RhodiumToad:    commit 70a77320
 04:07:47        robe2:  and then the unpackaged step wraps these functions
 in an extension
 }}}

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