[Qgis-user] edit joined fields

[Rémi Bovard]

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>

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/f6738f51/attachment.html>