[postgis-devel] [PostGIS] #1844: Function to drop TopoGeometry objects not found in their layers

[PostGIS]

#1844: Function to drop TopoGeometry objects not found in their layers
-------------------------+--------------------------------------------------
 Reporter:  strk         |       Owner:  strk         
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.1.0
Component:  topology     |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------
 It happens that TopoGeometry objects exist in the "relation" table but are
 not reachable from their layer tables anymore. A simple DELETE or UPDATE
 on the layer table could be the cause of this.

 It would be useful to have a function to drop all such "orphaned" objects.

 Not sure how to threat objects associated with non deployed or otherwise
 invalid layers (layers for which the associated schema.table.column
 doesn't exist).

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1844>
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.