[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 robe):

 Replying to [comment:2 pramsey]:

 > * Potentially cleaner but still ugly variant: change the signature of
 `st_transform` and `postgis_transform_geometry` to have an extra 'schema'
 parameter that has a default value of @extschema@, then we can avoid the
 extra level of indirection and get the install schema injected still.
 Depends on defaults working and involves changing signature of existing
 heavily used function.
 >

 Wondering is it any easier to look this value up in a GUC variable than
 going thru FunctionCallInfo.

 My thought is on install or upgrade of PostGIS, we can have our code set a
 guc variable to @extschema at .

 Then if that guc variable is set, our SPI queries will use the GUC
 variable

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