[postgis-tickets] [PostGIS] #3975: ST_Transform references spatial_ref_sys without schema

[PostGIS]

#3975: ST_Transform references spatial_ref_sys without schema
-------------------------+---------------------------
  Reporter:  javitonino  |      Owner:  pramsey
      Type:  defect      |     Status:  new
  Priority:  medium      |  Milestone:  PostGIS 2.4.3
 Component:  postgis     |    Version:  2.4.x
Resolution:              |   Keywords:
-------------------------+---------------------------

Comment (by pramsey):

 > Just to add to this, don't forget raster has an ST_Transform too, so
 that would need to be patched as well.

 Could just stick the install schema into a global in the backend. First
 call through, if it's null, set it. No user visible GUC required. Then the
 SPI lookup could check and see if the global is non-null and use it to
 qualify the query if it is. Ugly but avoids re-writing all the function
 signatures between through the proj cache.

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