[postgis-devel] [PostGIS] #921: populate_geometry_columns() does not add parent tables

PostGIS trac at osgeo.org
Mon Apr 25 13:58:59 PDT 2011


#921: populate_geometry_columns() does not add parent tables
---------------------+------------------------------------------------------
 Reporter:  pcav     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  1.5.X        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 Paolo,

 You have an example of this, I find it a bit hard to believe since
 inherited tables are no different from others and I don't recall
 populate_geometry_columns going out of its way to ignore these.  I can see
 this happening if a parent table is missing the necessary constraints to
 determine the geometry type /srid/dimension or it's children consist of
 multiple kinds of geometry types.

 This is a bit of a different issue and has nothing to do with inheritance.
 For example in my dataset, I ran populate_geometry_columns and it didn't
 register two of my tables (the parent and a child that is composed of
 polygons and multipolygons).  I think this is because there is no single
 type that it can ascribe to the geometry type aside from GEOMETRY.  It's
 questionable how useful that would be to register though.

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