[Qgis-user] edit joined fields

[Rémi Bovard]

Thanks for your input Vincent, I wasn't aware about that.

Rémi


2014-04-22 13:44 GMT+02:00 Vincent Picavet <vincent.ml at oslandia.com>:

> Hello,
>
> Le mardi 22 avril 2014 10:10:13, Rémi Bovard a écrit :
> > Hi Stefan,
> >
> > Just a note, wouldn't it be better to have one table being given the 1-1
> > relationship?
> >
> > In any case, with PostGIS you can create a view, add rules on it (update,
> > insert, delete) and the load this editable view in QGIS. Something like:
> >
> > ON UPDATE TO <view> DO INSTEAD UPDATE <table> SET <attribute>=
> > new.<attribute>
>
> Rules on PostgreSQL are an old system and not recommended.
> It is advised to use triggers instead for this kind of use case.
>
> Note that latest PostgreSQL versions have automatic writeable views (for
> simple views), no need to do anything to activate it.
> http://www.postgresql.org/docs/9.3/static/sql-createview.html
>
> Vincent
>
>
> >
> > HTH
> >
> > Rémi
> >
> > 2014-04-22 9:47 GMT+02:00 matteo <matteo.ghetta at gmail.com>:
> > > -----BEGIN PGP SIGNED MESSAGE-----
> > > Hash: SHA1
> > >
> > > > my problem is that both of my layers are stored in a Postgis
> > > > database and it does not help me if I have to create a new layer
> > > > which would then not refer to the original tables anymore. Of
> > > > course, a workaround could be a new layer inside the database that
> > > > would then update the original tables with a trigger function. But
> > > > I was wondering if there is an easier way to go in QGIS.
> > >
> > > if your layers are stored in a PostGIS database I should give up.. For
> > > now I'm not a PostGIS guru.. :(
> > >
> > > good luck!
> > >
> > > Matteo
> > >
> > >
> > > -----BEGIN PGP SIGNATURE-----
> > > Version: GnuPG v1.4.12 (GNU/Linux)
> > > Comment: Using GnuPG with Icedove - http://www.enigmail.net/
> > >
> > > iQEcBAEBAgAGBQJTVh6fAAoJEBy7UYf0gaEOdNwH/imIlzH9qnUAbxxZOTPy/wka
> > > 6gawQvw21iLMlmOFD2g7PwhqjEvzW+fRkRTVzvGQnOIoJfM6bPirAf6zrTmY3znU
> > > 2lyJsEwdFSkABGHOfgelv6KwF/T2uBJqBJ6ourCIrGx2KWYTYR3EYV401+gaw6eh
> > > aHLBREQ7GyMbc7ERNqAVKuyuZ98Ya/TfT3lRBVJA9oWIGGkoEW7MS5/+Q4ge92sK
> > > 03hK+Hp+7wv5CVW7K8zbCQeaHcXc52sChU1YmW3Yl2Hu9vxyTuRA161gDbXEStXs
> > > qFxVH98ItTYk7Y2jiaTulJMp61Ktk8G7WN4RT8bgEsjpfB9h+kc4LhUMiaOrxFI=
> > > =dPqA
> > > -----END PGP SIGNATURE-----
> > > _______________________________________________
> > > Qgis-user mailing list
> > > Qgis-user at lists.osgeo.org
> > > http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20140422/52f27c47/attachment.html>