Opened 9 years ago

Last modified 3 years ago

#1185 new enhancement

Need DropTopoGeometryTable function

Reported by: robe Owned by: strk
Priority: medium Milestone: PostGIS Fund Me
Component: topology Version: master
Keywords: Cc:


Such a function should drop the table and remove all related relation records.

Change History (4)

comment:1 Changed 9 years ago by strk

Technically, a TopoGeometry is independent from the table it's attached to. You may have literal TopoGeometry values, or have them used in multiple places.

Substancially a TopoGeometry is fully defined by the relation table AND the layer record (which specifies how to interpret the definition). Dropping the layer record makes indeed the TopoGeometry definition useless.

I agree on implementing DropTopoGeometryTable?, but I feel the need to somehow validate TopoGeometry object references (the topology.TopoGeometry object type) to catch malformations like the ones introduced by, for instance, saving a TopoGeometry object in a private/backup table and then dropping the referee using this function thus making the copied TopoGeometry a dangling reference.

comment:2 Changed 9 years ago by strk

Milestone: PostGIS 2.0.0PostGIS 2.1.0

comment:3 Changed 7 years ago by robe

Milestone: PostGIS 2.1.0PostGIS Future

sounds complicated --> punt

comment:4 Changed 3 years ago by robe

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.