On Tue, Dec 03, 2013 at 05:55:54PM +0100, Rémi Cura wrote: > For records : > > I add to desactivate trigger on "layer" to delete manually rows concerning > deleted schema, then reactivate trigger, then delete from "topology" the
Have you tried DropTopoGeometryColumn ? --strk; > 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 -- () ASCII ribbon campaign - against html e-mail /\ http://www.asciiribbon.org - against proprietary attachments _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
