[postgis-users] cleaning topology stuff in db

[Rémi Cura]

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 <strk at keybit.net>

> 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 <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
> > >>>
> > >>
> > >>
> > >
>
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > 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
> 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/24b49a8f/attachment.html>