[Qgis-user] Loading Postgis FDW tables

[Nicolas Boisteault]

Hi, 

I confirm the bug on QGIS 2.8.10 nightly. I have the column which should
permit the selection of the primary key but it is empty for materialized
view. 

Le 2017-07-05 16:46, Neumann, Andreas a écrit : 

> 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 [1]
> 
> 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 [2]
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user [3]
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user [3] 
> 
> __________ Information from ESET Mail Security, version of virus signature database 15696 (20170705) __________
> 
> The message was checked by ESET Mail Security.
> http://www.eset.com [2]
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user [3]
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user [3]

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user [3]
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user [3] 

 

Links:
------
[1] https://issues.qgis.org/issues/13698
[2] http://www.eset.com
[3] https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170706/d30b3ab6/attachment.html>