[postgis-tickets] [PostGIS] #4802: Spatial query with find_srid() not using the spatial index

[PostGIS]

#4802: Spatial query with find_srid() not using the spatial index
-------------------------+---------------------------
  Reporter:  Paco Calvo  |      Owner:  pramsey
      Type:  defect      |     Status:  new
  Priority:  medium      |  Milestone:  PostGIS 3.1.0
 Component:  postgis     |    Version:  3.0.x
Resolution:              |   Keywords:
-------------------------+---------------------------

Comment (by pramsey):

 Yes, it probably is related to support functions. You can test by re-
 defining find_srid() as an IMMUTABLE (rather than STABLE) function and see
 if the problem goes away. I suspect that PgSQL doesn't consider the
 function to pass is_pseudo_constant_for_index(). Since there's a
 workaround and the problem is rare, I'm not inclined to spend a lot of
 time trying to unpick this knot.

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