[postgis-tickets] [PostGIS] #5024: spatial_ref_sys table not updated with new entries

[PostGIS]

#5024: spatial_ref_sys table not updated with new entries
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.1.5
Component:  postgis  |    Version:  3.1.x
 Keywords:           |
---------------------+---------------------------
 As noted on mailing list excerpt from list
 https://lists.osgeo.org/pipermail/postgis-users/2021-November/045068.html


 {{{
 postgres=> create extension postgis version '2.4.5';
 CREATE EXTENSION
 postgres=> select count(*) from spatial_ref_sys;
  count
 -------
   5757
 (1 row)

 postgres=> alter extension postgis update to '3.1.4';
 WARNING:  unpackaging raster
 WARNING:  PostGIS Raster functionality has been unpackaged
 HINT:  type `SELECT postgis_extensions_upgrade();` to finish the upgrade.
 After upgrading, if you want to drop raster, run: DROP EXTENSION
 postgis_raster;
 ALTER EXTENSION
 postgres=> select count(*) from spatial_ref_sys;
  count
 -------
   5757
 (1 row)

 whereas...

 postgres=> create extension postgis version '3.1.4';
 CREATE EXTENSION
 postgres=> select count(*) from spatial_ref_sys;
  count
 -------
   8500
 (1 row)

 }}}

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