When I use the Feature info tool with the Auto open form option
selected, the form shows different values compared to the identify
results. The Identify results are correct.
Here's a screenshot:
http://terglobo.nl/downloads/qgis_attribute_form_bug.png
I am using QGIS Testing (just updated) on
Hi Raymond,
I thought it might be views because I never had any problems with
tables. When defining views you should include a field
1) that is a primary key in the table it comes from and
2) whose values are unique in the view.
example: view with _one_ owner per parcel (parcels may be
Hi,
Raymond, you can use the row_number function to add a primary key to your
view.
Something like :
CREATE OR REPLACE view myview as
SELECT row_number () over ()::integer as id, fieldA, Field ...
from mytable .
will add an unique integer field _id_ to your view. And this one can be
used in
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
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)
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
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
...@terglobo.nl
To: qgis-developer@lists.osgeo.org
Subject: Re: [Qgis-developer] wrong attribute values for postgis data
in Feature attribute form
Message-ID: 5513dc52.8040...@terglobo.nl
Content-Type: text/plain; charset=utf-8; format=flowed
Thanks Bernhard. I just figured that. But my layer
Thanks all for pointing things out!
My view did have a unique id, it is just a sub set of another table. So
by selecting it everything is solved.
On 26-03-15 11:45, Matthias Kuhn wrote:
Hi Raymond,
The feature shown in the identify result is the one queried with the
geographic location.