[postgis-tickets] [PostGIS] #4987: Reorganize spatial_ref_sys

[PostGIS]

#4987: Reorganize spatial_ref_sys
--------------------------+---------------------------
  Reporter:  strk         |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 3.3.0
 Component:  postgis      |    Version:  master
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by strk):

 So after trying to implement the view idea I'm really appreciating the
 simplicity of Regina's solution of just adding an `is_custom` boolean
 column. Such column could determine whether or not the entries are reset
 on update or not (only non-custom entries should be reset) and whether or
 not they are dumped by pg_dump I guess (custom entries should be dumped).

 During the excercise I've seen that at least gitlab-ci bot is not testing
 much about spatial_ref_sys because it succeeded way too easily ...

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