[postgis-users] cleaning topology stuff in db

[Rémi Cura]

For records :

I add to desactivate trigger on "layer" to delete manually rows concerning
deleted schema, then reactivate trigger, then delete from "topology" the
line concerning schema,
then drop schema,
then use the function to create a topology



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

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