[Qgis-user] QGIS 3 - Joins

[Karl Magnus Jönsson]

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-bounces at lists.osgeo.org] För Burghardt.Scholle at stadt.wolfsburg.de
Skickat: den 18 oktober 2019 12:09
Till: b.j.kobben at utwente.nl; qgis-user at 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.kobben at utwente.nl [mailto:b.j.kobben at utwente.nl]
> Gesendet: Freitag, 18. Oktober 2019 11:53
> An: Scholle, Burghardt (15-3 GIS); qgis-user at 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.Scholle at stadt.wolfsburg.de" <qgis-user-bounces at lists.osgeo.org
> on behalf of Burghardt.Scholle at 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.scholle at stadt.wolfsburg.de
> 
> 
> 
>     _______________________________________________
>     Qgis-user mailing list
>     Qgis-user at 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 at lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user