[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):


 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