[postgis-tickets] [PostGIS] #2560: view xxx depends on function st_union(geometry)

PostGIS trac at osgeo.org
Sun Feb 23 05:55:17 PST 2014


#2560: view xxx depends on function st_union(geometry)
-----------------------------------+----------------------------------------
 Reporter:  strk                   |       Owner:  strk         
     Type:  defect                 |      Status:  new          
 Priority:  medium                 |   Milestone:  PostGIS 2.1.2
Component:  build/upgrade/install  |     Version:  2.1.x        
 Keywords:                         |  
-----------------------------------+----------------------------------------

Comment(by strk):

 The query to find "ST_*" named aggregates and their schema:

 select n.nspname, p.proname, p.proargtypes from pg_proc p, pg_namespace n
 where p.pronamespace = n.oid and p.proisagg and p.proname ~ 'st_.*';

 I confirm your finding with current 2.1 branch.

 Seems to be only a problem with postgis, not with raster:
 {{{
  nspname |     proname      |   proargtypes
 ---------+------------------+-----------------
  public  | st_makeline      | 1773725
  public  | st_polygonize    | 1773725
  public  | st_collect       | 1773725
  public  | st_union         | 1773725
  public  | st_accum         | 1773725
  public  | st_memunion      | 1773725
  public  | st_memcollect    | 1773725
  public  | st_3dextent      | 1773725
  public  | st_extent        | 1773725
  postgis | st_union         | 1774451 25
  postgis | st_union         | 1774451
  postgis | st_union         | 1774451 23
  postgis | st_union         | 1774451 23 25
  postgis | st_union         | 1774451 1774905
  postgis | st_samealignment | 1774451
 (15 rows)
 }}}

 I'm looking at it.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2560#comment:23>
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