[postgis-users] cleaning topology stuff in db

Sandro Santilli strk at keybit.net
Tue Dec 3 09:34:56 PST 2013


On Tue, Dec 03, 2013 at 06:19:13PM +0100, Rémi Cura wrote:
> Yep, but the table with the topogeometry column was deleted,
> so no way to use classical function.

We could make the DropGeometryColumn function tolerant
to the fact that the column isn't there anymore while
still having it cleanup topology.layer. Ticket and patch ?

> It is somehow worrisome that the system can finish in such a lock (I agree
> it is not a good practice to delete all table in a schema where there is
> topology).
> But, you can't prevent people from wrecking everything ? ;-)

There seems to be disabled support for reducing those cases:
https://github.com/postgis/postgis/blob/2.1.0/topology/topology.sql.in#L663-L668

--strk;


More information about the postgis-users mailing list