<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi,</p>
<p>Yes - same here - the key parameter is empty.</p>
<p>In earlier QGIS versions I could manually select the primary key column - but this option to define the pkey column is now gone?</p>
<p>Andreas</p>
<p>On 2017-07-05 15:42, Nicolas Boisteault wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"><span style="white-space: nowrap;">Hi Andreas,</span><br /> <br /> <span style="white-space: nowrap;">I tested with QGIS 2.18.10 and I also have this issue.</span><br /> <br /> When I look in the error message I can see that the connection string has an empty key parameter.<br /> <br /> I guess that QGIS can't find the primary key because it is not exposed in the foreign table.<br /> <br /> 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 [<a href="https://issues.qgis.org/issues/13698">0</a>].<br /> <br /> <br /> <span style="white-space: nowrap;">[0] <a href="https://issues.qgis.org/issues/13698">https://issues.qgis.org/issues/13698</a></span><br /> <br /> <br /> <span style="white-space: nowrap;">Le 05/07/2017 à 15:18, Bernhard Ströbl a écrit :</span>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><span style="white-space: nowrap;">Hi Andreas,</span><br /> <br /> I have not used fdw for postgres, but use views based on dblink instead, which works perfectly in QGIS (2.14)<br /> My fdw tables from MySql and ORACLE are not shown either in QGIS when trying to load a layer.<br /> <br /> Bernhard<br /> <br /> <span style="white-space: nowrap;">Am 05.07.2017 um 14:35 schrieb Neumann, Andreas:</span>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><span style="white-space: nowrap;">Hi,</span><br /> <br /> <span style="white-space: nowrap;">I have troubles loading FDW layers (in my case postgres_fdw linked from</span><br /> <span style="white-space: nowrap;">another DB on the same server). I get an error message stating that the</span><br /> <span style="white-space: nowrap;">layer is an "invalid layer". In pgAdmin the respective user can access</span><br /> <span style="white-space: nowrap;">and display the data and it is correctly registered in the</span><br /> <span style="white-space: nowrap;">public.geometry_columns view.</span><br /> <br /> <span style="white-space: nowrap;">Do you have any idea why FDW tables shouldn't be loadable in QGIS?</span><br /> <br /> <span style="white-space: nowrap;">Thanks,</span><br /> <br /> Andreas<br /> <br /> <br /> <br /> <span style="white-space: nowrap;">__________ Information from ESET Mail Security, version of virus</span><br /> <span style="white-space: nowrap;">signature database 15696 (20170705) __________</span><br /> <br /> <span style="white-space: nowrap;">The message was checked by ESET Mail Security.</span><br /> <span style="white-space: nowrap;"><a href="http://www.eset.com">http://www.eset.com</a></span><br /> <br /> <br /> _______________________________________________<br /> <span style="white-space: nowrap;">Qgis-user mailing list</span><br /> <span style="white-space: nowrap;"><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a></span><br /> <span style="white-space: nowrap;">List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br /> <span style="white-space: nowrap;">Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br /> </blockquote>
<br /> <br /> <br /> __________ Information from ESET Mail Security, version of virus signature database 15696 (20170705) __________<br /> <br /> <span style="white-space: nowrap;">The message was checked by ESET Mail Security.</span><br /> <span style="white-space: nowrap;"><a href="http://www.eset.com">http://www.eset.com</a></span><br /> <br /> <br /> _______________________________________________<br /> <span style="white-space: nowrap;">Qgis-user mailing list</span><br /> <span style="white-space: nowrap;"><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a></span><br /> <span style="white-space: nowrap;">List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br /> <span style="white-space: nowrap;">Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span></blockquote>
<br /> _______________________________________________<br /> <span style="white-space: nowrap;">Qgis-user mailing list</span><br /> <span style="white-space: nowrap;"><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a></span><br /> <span style="white-space: nowrap;">List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span><br /> <span style="white-space: nowrap;">Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></span></div>
</blockquote>
<p><br /></p>
</body></html>