[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 10:04:24 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:  new
  Priority:  high     |  Milestone:  PostGIS 3.4.4
 Component:  postgis  |    Version:  3.4.x
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by Regina Obe <lr@…>):

 In [changeset:"b5fbbdd742effd92bca5f235c22c4fcc39d99c34/git" b5fbbdd/git]:
 {{{#!CommitTicketReference repository="git"
 revision="b5fbbdd742effd92bca5f235c22c4fcc39d99c34"
 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:3>
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