[postgis-tickets] [PostGIS] #3391: For "parent" tables with INHERITS st_estimatedextent might collect the extent from the "child" tables

PostGIS trac at osgeo.org
Thu Dec 10 01:45:56 PST 2015


#3391: For "parent" tables with INHERITS st_estimatedextent might collect the
extent from the "child" tables
-------------------------+---------------------------
 Reporter:  elpaso       |      Owner:  pramsey
     Type:  enhancement  |     Status:  new
 Priority:  medium       |  Milestone:  PostGIS 2.2.1
Component:  postgis      |    Version:  2.2.x
 Keywords:               |
-------------------------+---------------------------
 This problem arises when dealing with huge parent tables that have
 "children" with INHERITS.
 Even if the children tables have statistics and return st_estimatedextent
 correctly, running  st_estimatedextent on the parent table return an
 error:

 ERROR:  stats for "base_table_good.geom" do not exist

 Would it be possible to return the st_estimatedextent collecting that of
 the children tables (if available) instead of returning an error?

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3391>
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