[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:  strk
      Type:  defect   |     Status:  closed
  Priority:  medium   |  Milestone:  PostGIS 3.3.0
 Component:  postgis  |    Version:  3.1.x
Resolution:  fixed    |   Keywords:
----------------------+---------------------------
Changes (by Sandro Santilli <strk@…>):

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


Comment:

 In [changeset:"f1562b5ed954f9a8325857b3a9d2cf0dcc11f55d/git"
 f1562b5e/git]:
 {{{
 #!CommitTicketReference repository="git"
 revision="f1562b5ed954f9a8325857b3a9d2cf0dcc11f55d"
 Turn spatial_ref_sys into a view

 PostGIS official entries will be in spatial_ref_sys_postgis
 and user overrides in spatial_ref_sys_user.

 The spatial_ref_sys.sql script (now included in extension upgrade
 scripts) will fully replace contents of spatial_ref_sys_postgis.

 Migrations from table based spatial_ref_sys versions
 will consider all entries as user entries.

 INSERT/UPDATE/DELETE operations on spatial_ref_sys views will
 raise a WARNING about such operation being deprecated but will
 still be accepted in a way that is backward compatible with
 the previous system. In particular, SELECTs from the view will
 always see the effects of the changes performed on the view.
 Internally, DELETE will delete entries from both system and user
 tables, INSERT will insert to user table, UPDATE will insert or
 update existing entry in user table.

 The postgis_full_version() function will report count of SRIDs
 found in _user table which have a corresponding entry in the
 _postgis table.

 Contents of spatial_ref_sys_user will be always included in
 database dumps.

 The postgis_restore.pl script will be able to restore dumps
 from both table-based and view-based spatial_ref_sys postgis
 versions.

 Includes regression tests for spatial_ref_sys, including
 expected count of entries. Updates existing tests to directly
 edit the _user table to avoid the deprecation WARNINGs.

 Closes #5024 (SRID entries not updated on upgrade).
 }}}

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