[PostGIS] #5790: Postgis-functions in Materialized views fail in Postgres 17 due to not fully qualified search path

PostGIS trac at osgeo.org
Sun Oct 27 14:29:45 PDT 2024


#5790: Postgis-functions in Materialized views fail in Postgres 17 due to not
fully qualified search path
----------------------+---------------------------
  Reporter:  maxbo    |      Owner:  robe
      Type:  defect   |     Status:  closed
  Priority:  high     |  Milestone:  PostGIS 3.4.4
 Component:  postgis  |    Version:  3.4.x
Resolution:  fixed    |   Keywords:
----------------------+---------------------------
Changes (by Regina Obe <lr@…>):

 * resolution:   => fixed
 * status:  reopened => closed

Comment:

 In [changeset:"a914ff72de3bb627288c463f3918b4e40980a793/git" a914ff7/git]:
 {{{#!CommitTicketReference repository="git"
 revision="a914ff72de3bb627288c463f3918b4e40980a793"
 MISSING SCHEMA qualifications

     Schema qualify all uses of spatial_ref_sys and postgis functions in
 postgis.sql.in script
     Schema qualify postgis and raster functions and types in
 rtpostgis.sql.in

     Closes #5790 for PostGIS 3.4.4
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5790#comment:7>
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