[postgis-devel] triggers for postgis topology edition

Rémi Cura remi.cura at gmail.com
Thu Feb 5 05:08:37 PST 2015

Thanks for the links.
Of course I tried your pluggin a while ago.

I chose a trigger based solution precisely because it doesn't require
application specific code
(and thus it could be also used with another GIS, or a we application).

This forbid me to use feature specific to QGIS, and of course dedicated


2015-02-05 13:09 GMT+01:00 Sandro Santilli <strk at keybit.net>:

> On Thu, Feb 05, 2015 at 01:00:19PM +0100, Rémi Cura wrote:
> > Yep,
> > enabling/disabling seems necessary because as you said,
> > and is very easy to do (ALTER TABLE table DISABLE TRIGGER USER;)
> > enabling the trigger and importing data in topology would be at best
> slower,
> > , probably very hard to write
> > , and at worst impossible (infinite trigger call).
> >
> > I also have the concurrent editing in mind, but I don't aim at doing an
> > un-breakable topology for my first try.
> > simply allowing reasonable edition in qgis, where the user understand
> > topology and doesn't break things:
> One idea, had you tried QGIS own topology editing mode ?
> That is, it can make it so that when you move a vertex in one layer
> it moves the equivalent vertices in all other layers.
> I think I automatically enabled that for topology primitive layers
> at one point but later reverted it because it was done the wrong way.
> See
> https://github.com/qgis/QGIS/commit/314c783b211fb75c2056cb272047739b1874eeaf
> >  - edition not modifying topology : moving non-isolated node, changing
> geom
> > of edges (excluding first/last point, no crossing other edges)
> >  - edition modifying topology : create a node (split edge if necessary),
> > delete a node(heal edge if necessary), adding/deleting edged between
> > existing node
> Did you see my plugin as an alternative approach ?
> https://plugins.qgis.org/plugins/pgtopoeditor/
> --strk;
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20150205/0ef077ce/attachment.html>

More information about the postgis-devel mailing list