[postgis-tickets] [PostGIS] #3490: Create perl script to add in the ALTER FUNCTION set path calls

[PostGIS]

#3490: Create perl script to add in the ALTER FUNCTION set path calls
-------------------------+-------------------------------------------------
  Reporter:  robe        |      Owner:  robe
      Type:  defect      |     Status:  new
  Priority:  blocker     |  Milestone:  PostGIS 2.2.2
 Component:  postgis     |    Version:  2.2.x
Resolution:              |   Keywords:  restore, materialized views,
                         |  foreign tables, raster
-------------------------+-------------------------------------------------
Changes (by robe):

 * keywords:   => restore, materialized views, foreign tables, raster


Comment:

 Okay I think I have an 80% winner here.  I revised the script to not put
 in search path on SQL functions that are not marked as STRICT.

 C, plpgsql, and STRICT sql functions can't be inlined, so for those it's
 fine that search_path makes inlining not possible.

 This should fix partly:

 #3076 (it will handle ST_Distance for example, however it will not handle
 ST_DWithin in postgres fdw and materialized views.

 #3012 - this will fix since ST_AsLatLonText will now have a function
 search path.

 #3277 - this will be fixed too since non of the constraint functions are
 non strict and are for the most part plpgsql

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