Yep, but the table with the topogeometry column was deleted, so no way to use classical function.
It is somehow worrisome that the system can finish in such a lock (I agree it is not a good practice to delete all table in a schema where there is topology). But, you can't prevent people from wrecking everything ? ;-) Cheers, Rémi-C 2013/12/3 Sandro Santilli <[email protected]> > 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 >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
