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

PostGIS trac at osgeo.org
Fri Oct 27 05:29:53 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 robe):

 > 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

 I had tried the search_path function specific in the PostGIS 2.3/2.4 days,
 but it killed performance badly, so I had to take it out.

 The discussion about it is here - https://www.postgresql.org/message-
 id/flat/CA%2BTgmoYo1eR3011SLSbm2K%2B4X4RtYGuDuhNSkuYMgH7fomMCRg%40mail.gmail.com#1cb2569a901d89212bb3a9225ee947eb
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5525#comment:17>
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