[postgis-tickets] [PostGIS] #4549: ST_Dump results in geometry_dump does not exists when postgis schema not in search_path
    PostGIS 
    trac at osgeo.org
       
    Thu Oct 17 10:21:20 PDT 2019
    
    
  
#4549: ST_Dump results in geometry_dump does not exists when postgis schema not in
search_path
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.5.4
Component:  postgis  |    Version:  2.5.x
 Keywords:           |
---------------------+---------------------------
 Here is a test to exercise the issue:
 {{{
 CREATE SCHEMA IF NOT EXISTS postgis;
 CREATE EXTENSION postgis SCHEMA postgis;
 CREATE TABLE g AS
 SELECT postgis.ST_Collect(postgis.ST_Point(i,i+1) ) AS geom
 FROM generate_series(-10,30) AS i;
 SELECT foo
 FROM g, postgis.ST_Dump(g.geom) AS foo;
 }}}
 Results in error:
 {{{
 ERROR:  relation "geometry_dump" does not exist
 }}}
 {{{
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4549>
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