[postgis-users] cleaning topology stuff in db

[Rémi Cura]

That would mean
_create a function bollean table_exists(qualified_tablename)
and use it to safeguard (if exist, no change, else, skip) in all the
postgis topology functions.

Not hard, but a lot's of impacted functions.

Cheers,
Rémi-C



2013/12/3 Sandro Santilli <strk at keybit.net>

> 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;
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131203/4aa68906/attachment.html>