[Qgis-user] Loading Postgis FDW tables

[Neumann, Andreas]

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
> 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
> 
> __________ 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
> 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 

 

Links:
------
[1] https://issues.qgis.org/issues/13698
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170705/25cbd2af/attachment.html>