[PostGIS] #5525: ERROR: permission denied for view pg_file_settings

[PostGIS]

#5525: ERROR:  permission denied for view pg_file_settings
---------------------+---------------------------
  Reporter:  robe    |      Owner:  strk
      Type:  defect  |     Status:  assigned
  Priority:  medium  |  Milestone:  PostGIS 3.3.5
 Component:  build   |    Version:  3.3.x
Resolution:          |   Keywords:  pgextwlist
---------------------+---------------------------
Comment (by robe):

 I was able to replicate the issue.

 The postgis_tiger_geocoder is marked as nonsuperuser, so regular users can
 install it even without pgextwlist

 Do as a super user
 {{{
 CREATE EXTENSION postgis;
 CREATE EXTENSION fuzzystrmatch;
 }}}


 Then do as a non-super user


 {{{
 CREATE EXTENSION postgis_tiger_geocoder;
 }}}


 Yields error:

 {{{
 ERROR:  permission denied for view pg_file_settings
 CONTEXT:  SQL statement "SELECT setting
                                            FROM pg_file_settings
                 WHERE name = 'search_path' AND applied"
 PL/pgSQL function tiger.postgis_extension_addtosearchpath(text) line 23 at
 SQL statement

 SQL state: 42501
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5525#comment:23>
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.