[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