[postgis-users] cleaning topology stuff in db

[Rémi Cura]

Hm sligthly more annoying :
if deleting table relation, we can no more drop the topology or create it

This is annoying robustness issue.

Cheers,
Rémi-C



2013/12/3 Rémi Cura <remi.cura at gmail.com>

> 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/a072ce12/attachment.html>