Hi,
Yes - same here - the key parameter is empty.
In earlier QGIS versions I could manually select the primary key column
- but this option to define the pkey column is now gone?
Andreas
On 2017-07-05 15:42, Nicolas Boisteault wrote:
> 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 [1]].
>
> [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
Links:
------
[1] https://issues.qgis.org/issues/13698
_______________________________________________
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
