[Qgis-user] Loading Postgis FDW tables

[Nicolas Boisteault]

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