Inserting data on version views not working in 2.18 (OK in 2.14)

[qgib]

Author Name: Paolo Cavallini (@pcav)
Original Redmine Issue: 16552
Affected QGIS version: 2.18.7
Redmine category:db_manager

---

• create a PostGIS DB
• create a simple geometric table
• DB Manager > Table > Verioning
• add the view to the canvas
• start editing
• insert a feature
• Commit errors:

ERROR: 1 feature(s) not added.
Provider errors:
PostGIS error while adding features: ERRORE:  non è possibile eseguire INSERT RETURNING sulla relazione "version_current"
NOTA: È necessaria una regola ON INSERT DO INSTEAD non condizionale con una clausola RETURNING.

Which translates approx to:

ERROR: cannot perform
INSERT RETURNING on relation "version_current"
HINT: You need an unconditional ON INSERT DO INSTEAD rule with a
RETURNING clause.

The same operation on the same view works smoothly on QGIS 2.14.

---

Related issue(s): #23997 (relates)
Redmine related issue(s): 16083

---

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• priority_id was changed from Normal to High

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• resolution was changed from to duplicate

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• status_id was changed from Closed to Open
• resolution was changed from duplicate to

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• relates was configured as problem with ON INSERT TO ... DO INSTEAD postgres rules  #23997

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Fixed in 8b263e4 and 3f7f95e

---

• resolution was changed from to fixed/implemented
• status_id was changed from Open to Closed