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 > [email protected] > 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 > [email protected] > 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 [email protected] 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
_______________________________________________ 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
