I think the answer to this question is NO, but thought I'd ask. A lot of folks in PostGIS land are suffering from restore issues, materialized view issues etc. because we have functions such as
ST_Intersects Which does _ST_Intersects AND && Since _ST_Intersects is not schema qualified, during database restore (which sets the schema to the table or view schema), materialized views that depend on this do not come back. It's also a serious issue with raster, though that one can be fixed by setting search_path since the issue there doesn't use SQL inlining. So I had this bright idea of setting the search_path of the functions to where PostGIS is installed. https://trac.osgeo.org/postgis/ticket/3490 To my disappointment, I noticed our spatial indexes no longer worked if I do this since they rely on SQL inlining. Schema qualifying our function calls is not an option at this time since 1) People install postgis in different schemas so we'd have to force them to install in the same schema which I think will break a lot of 3rd party apps. 2) It's a lot of functions to hand touch. Any suggestions are welcome. Any other issues I should be aware of with ALTER FUNCTION .. set search_path.. Only other I noticed is it seems to be ignored in CREATE EXTENSION script (at least when using dynamic execute). I put it in and it seems to be entirely ignored. Thanks, Regina -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
