[Qgis-user] Postgis layer: attributes not editable if field has a default value

[Burghardt.Scholle at stadt.wolfsburg.de]

Hi Tom,

you‘re right. It's a bug that was fixed in the current LTR nightly. Please try with this version or wait until 3.4.10.
BTW, this error does not appear with 3.6.

Regards Burghardt


Von: Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] Im Auftrag von tommaso
Gesendet: Donnerstag, 11. Juli 2019 14:09
An: qgis-user at lists.osgeo.org
Betreff: [Qgis-user] Postgis layer: attributes not editable if field has a default value

Hello,
I'm using Qgis 3.4.4 Madeira on Ubuntu 16.04 and it seems that the attributes of Postgis layers are not editable if the corresponding field has a default value at the database level.
I observed this issue with fields of type boolean and hstore.
For example, if the field "active" of the table "test" has a default value:

Table "test"
Column | Type | Modifiers
--------+---------+--------------
 id    | integer |
 name  | hstore  |
active | boolean | default true

than the field "active" is not editable in the attribute table in Qgis.

Could you please help me?

Regards Tom
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190711/99e567ee/attachment.html>