[Qgis-developer] wrong attribute values for postgis data in Feature attribute form

[Raymond Nijssen]

Thanks Bernhard. I just figured that. But my layer is not a table, it is 
a view. And it seems that PostgreSQL cannot have constraints on views.

So, I think I just need to carefully select the right key field when 
loading it.

(And maybe QGIS could be slightly smarter by not suggesting a boolean 
field by default?)


On 26-03-15 11:07, Bernhard Ströbl wrote:
> Hi Raymond,
>
> Am 26.03.2015 10:57, schrieb Raymond Nijssen:
>> 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?
>
> Maybe I can, but I would need the table definition statement for it. Can
> you post it here.
> Generally speaking you should define an integer field (use bigint if you
> expect _many_ datasets) as primary key for the table like:
>
> CREATE TABLE my_points
> (
>    gid integer NOT NULL,
>    the_geom geometry(Point,my_srid),
>    other_fields,
>    CONSTRAINT my_points_pkey PRIMARY KEY (gid)
> );
>
> Bernhard
>
>>
>> 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 at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>
>>
>
>
>
> __________ Information from ESET Mail Security, version of virus
> signature database 11379 (20150326) __________
>
> The message was checked by ESET Mail Security.
> http://www.eset.com
>
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer

-- 
Terglobo
Ampèrestraat 110
5223 CT 's-Hertogenbosch
06-25314983