[postgis-devel] [PostGIS] #877: st_estimated_extent returns error on empty table

PostGIS trac at osgeo.org
Mon Mar 21 06:44:02 PDT 2011


#877: st_estimated_extent returns error on empty table
---------------------+------------------------------------------------------
 Reporter:  martins  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 1.5.3
Component:  postgis  |     Version:  1.5.X        
 Keywords:           |  
---------------------+------------------------------------------------------
 To reproduce:
 > create table t(gid serial);
 > select addgeometrycolumn('t','g',4326,'GEOMETRY',2);
 > vacuum analyze t;
 > select st_estimated_extent('t','g');
 ERROR:  LWGEOM_estimated_extent: couldn't locate table within current
 schema

 This is especially annoying for us, because we must execute
 estimated_extent inside a transaction.

 Could the function be changed to return NULL instead of an error in this
 case?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/877>
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-devel mailing list