[postgis-users] cleaning topology stuff in db

[Sandro Santilli]

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