QGIS 3.4 Incorrect handling of Postgres serial columns

[qgib]

Author Name: Scott Werkema (@ScottWerkema)
Original Redmine Issue: 20397
Affected QGIS version: 3.4.0
Redmine category:data_provider/postgis

---

Starting with QGIS 3.4, I am unable to digitize multiple features between saves for PostGIS layers with a serial column that has a unique constraint. It appears the serial column's default text is triggering QGIS unique constraint enforcement.

Note: In the attached screenshot, structure_id is the primary key column.

---

• Screen Shot 2018-11-07 at 09.27.29.png (Scott Werkema)

---

Related issue(s): #28251 (relates)
Redmine related issue(s): 20431

---

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• priority_id was changed from Normal to High
• operating_system was changed from macOS 10.14.1 to

[qgib]

Author Name: Burghardt Scholle (Burghardt Scholle)

---

I can confirm your description with QGIS DEV code revision 7cce9b3. After digitizing a new feature I have to save first before I can continue with the next feature. Otherwise I get the same error message in the PostGIS-Tab of the log:

2018-11-16T09:53:49 WARNING Query: DECLARE qgis_1774 BINARY CURSOR FOR SELECT "gid","datum"::text,"bearbeiter"::text,"veranstaltung"::text,"beschriftung"::text,"name"::text,"flaechentyp"::text,"farbe"::text,"schraff_width"::text,"schraff_width_prt"::text,"schraff_size"::text,"schraff_size_prt"::text,"schraff_winkel"::text,"umrissfarbe"::text,"umrisstyp"::text,"umrissstaerke"::text,"umrissstaerke_prt"::text,"umfang"::text,"flaeche"::text,"bemerkung"::text,"last_change"::text FROM "geofachdaten"."gis_digi_a_geo" WHERE ("gid" = 'nextval(''gis_digi_a_geo_gid_seq''::regclass)') LIMIT 1 returned 7 [ERROR: invalid input syntax for integer: »nextval('gis_digi_a_geo_gid_seq'::regclass)«
LINE 1: ...OM "geofachdaten"."gis_digi_a_geo" WHERE ("gid" = 'nextval('...

This significantly impairs the workflow during digitization.

[qgib]

Author Name: Harrissou Santanna (@DelazJ)

---

What happens if "evaluate default values on provider side" is checked in the project settings, as suggested in #28251?

[qgib]

Author Name: Jan Lippmann (@j-lippmann)

---

see also here #28251

when you hide the serial field in the form you can add more than one feature without save each feature

BUT then you can run into this issue: #28253

[qgib]

Author Name: Harrissou Santanna (@DelazJ)

---

• relates was configured as no possibility to confirm in the attribut form while add more than one feature (postgres) #28251

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

Most likely broken by 963fdd5#diff-ad7e488f21bc920cdf5407f3b17f5c42

[qgib]

Author Name: David Signer (@signedav)

---

Applied in changeset 32b7d7e.

---

• done_ratio was changed from 0 to 100
• status_id was changed from Open to Closed