Opened 10 years ago

Closed 10 years ago

#921 closed defect (invalid)

populate_geometry_columns() does not add parent tables

Reported by: pcav Owned by: pramsey
Priority: medium Milestone: PostGIS 2.0.0
Component: postgis Version: 1.5.X
Keywords: Cc: strk

Description

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.

Change History (2)

comment:1 Changed 10 years ago 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.

comment:2 Changed 10 years ago by pcav

Resolution: invalid
Status: newclosed

You are right. Thanks for clarifying.

Note: See TracTickets for help on using tickets.