[postgis-tickets] [PostGIS] #3076: Unqualified function calls break postgres_fdw compatibiliy

[PostGIS]

#3076: Unqualified function calls break postgres_fdw compatibiliy
-----------------------+---------------------------
  Reporter:  fphilipe  |      Owner:  robe
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 2.3.0
 Component:  postgis   |    Version:  2.1.x
Resolution:            |   Keywords:  restore
-----------------------+---------------------------
Changes (by robe):

 * keywords:   => restore


Comment:

 I think I have a plan.  This is a mockup of it,

 https://trac.osgeo.org/postgis/browser/trunk/postgis/postgis_functions_search_path.sql

 but once I test this I'll be braver and just have it generate a script to
 do this for all functions (messing with strks' perl scripts to generate
 this additional script (one for postgis proper and one for raster).

 For 2.3, we can fold this in the create extension, update extension
 process.  For older, I'm just going to have it as a stand-alone script
 with an FAQ that people should run the script after every install and
 upgrade to be able to easily restore their backups and also make there fdw
 and materialized views work.

 Sadly there is a downside.  Downside being I can't have the search path
 change in the ALTER EXTENSION  .. SCHEMA change.  Unless I introduce event
 triggers (which someone in code-sprint suggested) which pramsey at
 codesprint gave a sour face too.

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