[postgis-tickets] [PostGIS] #4271: postgis_extensions_upgrade() does nothing when upgrading from same version of Postgis different PostgreSQL

[PostGIS]

#4271: postgis_extensions_upgrade() does nothing when upgrading from same version
of Postgis different PostgreSQL
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.5.2
Component:  postgis  |    Version:  2.5.x
 Keywords:           |
---------------------+---------------------------
 So I pg_upgraded by PostgreSQL 10 windows running 2.5.1 to PostgreSQL 11
 PostGIS 2.5.1


 {{{
 SELECT postgis_full_version():
 }}}

 Shows:


 {{{
 POSTGIS="2.5.1 r17027" [EXTENSION] PGSQL="100" (procs need upgrade for use
 with "110") GEOS="3.7.0-CAPI-1.11.0 3.7.1" PROJ="Rel. 4.9.3, 15 August
 2016" GDAL="GDAL 2.2.4, released 2018/03/19" LIBXML="2.7.8" LIBJSON="0.12"
 LIBPROTOBUF="1.2.1" RASTER
 }}}



 Next I tried to fix the issue by running:


 {{{
 SELECT postgis_extensions_upgrade();
 }}}

 Still same read

 I think our basic extension upgrade is okay though cause I could still do:


 {{{
 ALTER EXTENSION postgis UPDATE TO "2.5.1next";
 ALTER EXTENSION postgis UPDATE TO "2.5.1";
 }}}


 To force the upgrade

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