[postgis-tickets] [PostGIS] #5525: Revert change of reliance on pg_file_settings for postgis_topology and postgis_tiger_geocoder

[PostGIS]

#5525: Revert change of reliance on pg_file_settings for postgis_topology and
postgis_tiger_geocoder
-----------------------------------+---------------------------
 Reporter:  robe                   |      Owner:  strk
     Type:  defect                 |     Status:  new
 Priority:  medium                 |  Milestone:  PostGIS 3.3.5
Component:  build/upgrade/install  |    Version:  3.4.x
 Keywords:                         |
-----------------------------------+---------------------------
 Unfortunately the change we made at [a514af68/git] makes it impossible for
 Amazon DbaaS customers to create postgis_topology and
 postgis_tiger_geocoder


 Error is


 {{{
 postgres=> CREATE EXTENSION postgis_topology;
 ERROR:  permission denied for view pg_file_settings
 CONTEXT:  SQL statement "SELECT setting
                                            FROM
 pg_catalog.pg_file_settings
                 WHERE name OPERATOR(pg_catalog.=) 'search_path' AND
 applied"
 PL/pgSQL function addtosearchpath(character varying) line 22 at SQL
 statement
 }}}


 I'm suspect other DbaaS will be similarly impacted.

 I'm going to test this using pgextwlist to see if it triggers the same
 issue.
 If it does, I'll put pgextwlist bot in our rotation.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5525>
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.