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 <[email protected]> > 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 <[email protected]> > >> 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 <[email protected]> >> >>> 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 >>> [email protected] >>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >>> >> >> >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
