Hi Alexandre, On Mon, 10. Mar 2014 at 12:03:54 +0000, Alexandre Neto wrote: > I then noticed that using the last method, QGIS fails to identify a good > candidate for a primary key. Selecting it in the primary key, solves the > problem.
QGIS just offers all integer fields as candidate. It doesn't select any. > Using DB Manager (add layer to canvas), QGIS sucessfully identify the > possible primary key and everything goes well. > I think this was not happening in 2.0.1. Can anyone confirm this? I think that changed before 2.0.1. QGIS used to identify which view field are primary keys in the underlying tables, but that makes sense if the view is a selection of that table, which is just a very small subset of possible views. E.g. for joins between two tables being a primary key in one of the table, doesn't mean that the attribute is also unique in the view. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de QGIS PSC member (RM) Germany IRC: jef on FreeNode -- norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502 _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer