[Qgis-user] Error editing PK values in "Add record" form

Rafa García Castillo ragaca at gmail.com
Wed Mar 7 23:31:39 PST 2018


   Hi everybody,

  I´m testing QGIS 3.0 in Windows 10. I think I have found an error in the
"Add record" form when you are editing a PostgreSQL table without geometry
and the table primary key (PK) is composed of two fields (or more) from the
table.

  I suppose QGIS thinks a PK field has to be unique, and that´s true for
most of the cases, but when you have a PK composed of more than one field,
is the combination of these fields what it has to be unique, not the fields
individually. Now, in QGIS 3.0, if you write a value for one of the PK
fields that it is already in the table, it doesn't let you insert that
value, even if the combination of the values that compound the PK is unique.

  I attach two screenshot:
    -"Add record" button
    -"Add record" form not letting you insert a value

  Thanks in advance

  Rafa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180308/6ccafe10/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: add_record_button.jpg
Type: image/jpeg
Size: 1341 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180308/6ccafe10/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: add_record_form.jpg
Type: image/jpeg
Size: 17309 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180308/6ccafe10/attachment-0001.jpg>


More information about the Qgis-user mailing list