Ticket #1844 (new enhancement)
Function to drop TopoGeometry objects not found in their layers
|Reported by:||strk||Owned by:||strk|
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).