[postgis-users] cleaning topology stuff in db

[Rémi Cura]

Thanks !
Any chance you would have the garbage collection in sql ?

The trouble is that when you have a row in layer referencing nothing, you
can't make it reference something, because you cannot ad a topogeom column
with it's name.
Anyway not a big deal.

Cheers,

Rémi-C


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

> On Tue, Dec 03, 2013 at 04:50:40PM +0100, Rémi Cura wrote:
> > Hey all,
> > somebody has a trick to clean all the topology infrastructure in DB?
> >
> > I mean ensuring that there is no orphan in "relation", that "layer"
> > references existing tables, and so on?
>
> Garbage collection for "relation" is available as a tool in
> the "postgis topology editor" plugin of qgis.
>
> Rows in "layers" may still be important to keep even if the so-called
> "deploy table" disappeared (a TopoGeometry still exists even if not
> deployed to any table).
>
> --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/1fe365f5/attachment.html>