Hi! It could work editing views if you set up some triggers or rules for editing the view.
Karl-Magnus -----Ursprungligt meddelande----- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För burghardt.scho...@stadt.wolfsburg.de Skickat: den 18 oktober 2019 12:09 Till: b.j.kob...@utwente.nl; qgis-user@lists.osgeo.org Ämne: Re: [Qgis-user] QGIS 3 - Joins Hi Barend, you're right, I know this way and use it a lot as well. Unfortunately I have to edit features in this layer and that doesn't work with views. Burghardt > -----Ursprüngliche Nachricht----- > Von: b.j.kob...@utwente.nl [mailto:b.j.kob...@utwente.nl] > Gesendet: Freitag, 18. Oktober 2019 11:53 > An: Scholle, Burghardt (15-3 GIS); qgis-user@lists.osgeo.org > Betreff: Re: [Qgis-user] QGIS 3 - Joins > > Another way would be to leave the joining up to Postgres, i.e. create a VIEW > with the Join and load that view as a layer in QGIS... > -- > Barend Köbben > > On 18/10/2019, 10:16, "Qgis-user on behalf of > burghardt.scho...@stadt.wolfsburg.de" <qgis-user-boun...@lists.osgeo.org > on behalf of burghardt.scho...@stadt.wolfsburg.de> wrote: > > Dear list, > > I have a postgres layer that is connected to other postgres lookup tables > via > joins. QGIS does not take these joins into account when copying a layer (to > another project) or when creating style or layer files. This is really > annoying if > you have to rebuild the joins by hand over and over again. Am I doing > something wrong? In the dialog window "Edit Vector Join" I see no further > ways. I only activated the option "Cache join layer in virtual memory". > > Any hint is appreciated, thanks. > I'm using QGIS LTR 3.4.12 > > Regards > Burghardt > > *************** > > Stadt Wolfsburg > Geschäftsbereich IT - 15-3 GIS > Rathaus E, Zi. E 313, Porschestraße 47A, D-38440 Wolfsburg > Tel +49 5361 28-2531 > Fax +49 5361 28-1765 > mailto:burghardt.scho...@stadt.wolfsburg.de > > > > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user