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

PostGIS trac at osgeo.org
Tue Oct 22 14:29:09 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:
----------------------+---------------------------
Comment (by Paul Ramsey <pramsey@…>):

 In [changeset:"db1750887985f849c1fbffbb8cfcd040307f38da/git" db17508/git]:
 {{{#!CommitTicketReference repository="git"
 revision="db1750887985f849c1fbffbb8cfcd040307f38da"
 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
 References #5790 for PostGIS 3.6.0
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5790#comment:5>
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