Hi Andreas,
I tested with QGIS 2.18.10 and I also have this issue.
When I look in the error message I can see that the connection string
has an empty key parameter.
I guess that QGIS can't find the primary key because it is not exposed
in the foreign table.
You can use the DB manager to add your layer even if you won't see your
table in the treeview because of this bug [0].
[0] https://issues.qgis.org/issues/13698
Le 05/07/2017 à 15:18, Bernhard Ströbl a écrit :
Hi Andreas,
I have not used fdw for postgres, but use views based on dblink
instead, which works perfectly in QGIS (2.14)
My fdw tables from MySql and ORACLE are not shown either in QGIS when
trying to load a layer.
Bernhard
Am 05.07.2017 um 14:35 schrieb Neumann, Andreas:
Hi,
I have troubles loading FDW layers (in my case postgres_fdw linked from
another DB on the same server). I get an error message stating that the
layer is an "invalid layer". In pgAdmin the respective user can access
and display the data and it is correctly registered in the
public.geometry_columns view.
Do you have any idea why FDW tables shouldn't be loadable in QGIS?
Thanks,
Andreas
__________ Information from ESET Mail Security, version of virus
signature database 15696 (20170705) __________
The message was checked by ESET Mail Security.
http://www.eset.com
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
__________ Information from ESET Mail Security, version of virus
signature database 15696 (20170705) __________
The message was checked by ESET Mail Security.
http://www.eset.com
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
