[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