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

PostGIS trac at osgeo.org
Thu Oct 26 10:02:08 PDT 2023


#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/upgrade/install  |    Version:  3.3.x
Resolution:                         |   Keywords:  pgextwlist
------------------------------------+---------------------------
Comment (by strk):

 The original problem description is in #5442 which reports 2 problems:
   1. Changing boot value based on current value rather than bool value
   2. Changing session value based on boot val rather than current val

 Jeff is my understanding of the problem correct ?

 Regina: would there be any problem to set per-function search_path rather
 than fully qualified all those pg_catalog calls ? That hurts my eyes :)
 My proposed solution for that is in
 https://git.osgeo.org/gitea/postgis/postgis/pulls/161
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5525#comment:16>
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.


More information about the postgis-tickets mailing list