[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:  closed
  Priority:  blocker                |  Milestone:  PostGIS PostgreSQL
 Component:  build/upgrade/install  |    Version:  master
Resolution:  fixed                  |   Keywords:
------------------------------------+--------------------------------
Comment (by Sandro Santilli <strk@…>):

 In [changeset:"506943604d2d5336691838e16cb7ec4cf119d0dc/git" 5069436/git]:
 {{{#!CommitTicketReference repository="git"
 revision="506943604d2d5336691838e16cb7ec4cf119d0dc"
 Work around PG13 drop of `FROM unpackaged` syntax

 - Always install empty extension--unpackage.sql scripts
 - Have run_test.pl use create/update trick for PG13
 - Re-enable check_all_upgrades.sh testing of unpackaged
 - Have postgis_extensions_upgrade use the unpackaged trick

 References #4643 in stable-3.0 branch (3.0.7dev)

 This code has been in branches 3.1 onward for a long time now,
 but never made it into 3.0 until today when I saw 3.0 is advertised
 as supporting PostgreSQL 13 here:

   https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS

 This is a backport of master branch commits:
   - 963aad2943924702e03b180a82bd1412c0d5880e
   - 33db86ac377e060f59c353ab7b44703ebfbf90aa
   - 43b1f58ed8869d4a6d0b2c58cbecc49d407e39e2
   - 520af0e8d1bb6e9544d974713bb87e428ff4230b
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4643#comment:18>
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.