Opened 8 years ago

Last modified 3 years ago

#1844 new enhancement

Function to drop TopoGeometry objects not found in their layers

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS Fund Me
Component: topology Version: master
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 (6)

comment:1 Changed 8 years ago by robe

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

comment:2 Changed 8 years ago by strk

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

comment:3 Changed 8 years 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.

comment:4 Changed 7 years ago by robe

Milestone: PostGIS 2.1.0PostGIS 2.2.0

comment:5 Changed 5 years ago by strk

Milestone: PostGIS 2.2.0PostGIS Future

comment:6 Changed 3 years ago by robe

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.