populate_geometry_columns() does not add parent tables

[pcav]

Inheritance is a nice PG feature: ​http://www.postgresql.org/docs/9.0/static/ddl-inherit.html

CREATE TABLE daughter () inherits (mother);

Unfortunately, it seems that populate_geometry_columns() does not take into account parent tables, that are not added to geometry_columns, and have to be added by hand.

[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.

[pcav]

You are right. Thanks for clarifying.