Ticket #1844 (new enhancement)

Opened 12 months ago

Last modified 3 weeks ago

Function to drop TopoGeometry objects not found in their layers

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 2.2.0
Component: topology Version: trunk
Keywords: Cc:

Description

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

Change History

Changed 12 months ago by robe

strk -- do you consider this related to my complaint in #1186

Changed 12 months ago by strk

Yeah, sound like we can close #1186 and point here

Changed 12 months ago by strk

I've code locally for this, btw. Only I can't decide if the function should return something, and if so, what. I've been thinking a list of distinct layer_id,topogeo_id could be nice but would require some overhead.

Changed 3 weeks ago by robe

  • milestone changed from PostGIS 2.1.0 to PostGIS 2.2.0
Note: See TracTickets for help on using tickets.