Hi Raymond, The feature shown in the identify result is the one queried with the geographic location.
For some reason the feature shown in the feature form is not a copy of the identified data (feature) but queried again with its feature id. For the views on pg databases I have here, the primary key of the main source table is shown (which is the first field of the query that defines the view), so it is fine by default. Not sure about the heuristics used to get the default PK field. Matthias On 03/26/2015 10:57 AM, Raymond Nijssen wrote: > Thanks Regis, that was exactly the issue. The (boolean!) field > 'inonderzoek' was used as a key. When I change that to 'gid' in the > Add PostGIS Table dialog, everything works correctly. > > Can anyone tell me why QGIS picks that boolean field for most of my > tables? Can I change that behaviour by changing my database structure? > > http://terglobo.nl/downloads/qgis_add_postgis_table_wrong_key.png > > And how can the identify results be correct anyway? > > Tnx, > Raymond > > > dbname='bag' host=localhost port=5432 user='postgres' sslmode=disable > key='inonderzoek' estimatedmetadata=true srid=28992 type=POLYGON > table="bagactueel"."pandactueelbestaand" (geovlak) sql= > > > > On 26-03-15 10:34, Régis Haubourg wrote: >> Hi, I have seen such troubles when the choosen primary key from qgis >> side is >> not unique . >> >> Symptoms: selecting one feature select severals unrelated features of >> the >> same layer. relation with attributes is broken also. >> >> Can you check in your layer's definition (general tab of layer >> properties) >> if you choose gid field as key, and check if it is really unique in >> postgis? >> >> Cheers >> Régis >> >> >> >> -- >> View this message in context: >> http://osgeo-org.1560.x6.nabble.com/wrong-attribute-values-for-postgis-data-in-Feature-attribute-form-tp5195518p5195523.html >> Sent from the Quantum GIS - Developer mailing list archive at >> Nabble.com. >> _______________________________________________ >> Qgis-developer mailing list >> Qgis-developer@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/qgis-developer >> >
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer