[postgis-tickets] [PostGIS] #4405: Index over ST_Transform(constant, SRID) breaks pg_upgrade

[PostGIS]

#4405: Index over ST_Transform(constant, SRID) breaks pg_upgrade
------------------------------------+-----------------------------
  Reporter:  Algunenano             |      Owner:  Algunenano
      Type:  defect                 |     Status:  assigned
  Priority:  medium                 |  Milestone:  PostGIS Fund Me
 Component:  build/upgrade/install  |    Version:  master
Resolution:                         |   Keywords:
------------------------------------+-----------------------------
Changes (by Algunenano):

 * version:  2.3.x => master
 * milestone:  PostGIS 3.0.3 => PostGIS Fund Me


Comment:

 I don't think this is fixable with our current spatial_ref_sys desisgn. To
 fix it in my migrations I've hardcoded the necessary SRID transformation
 strings inside Postgis, but that isn't a proper solution.

 I think that ideally we would have a set of static SRIDs inside
 Postgis/PROJ (independent of spatial_ref_sys) that can't be modified by
 the end user and then allow having other SRIDS (as long as they don't
 collide with the static ones). This would mean a major change which I'm
 not sure we want to tackle.

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