Commit changes to database creates invalid geometry

[qgib]

Author Name: Hannah Burk (Hannah Burk)
Original Redmine Issue: 9997
Affected QGIS version: 2.2.0

---

Hi,

When editing a linestring layer (connection to postgres table) commit changes caused all active geometry to become invalid in both map display and db table. This only happened after multiple saves to the db. Linestring geometry attributes can still be queried for length in postgres but validity returns an error and lines cannot be displayed in QGIS.

[qgib]

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

---

• category_id removed DB Manager

[qgib]

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

---

Not reproducable. Please provide more details.

---

• priority_id was changed from High to Normal
• status_id was changed from Open to Feedback

[qgib]

Author Name: Hannah Burk (Hannah Burk)

---

I'm not sure I would be able to reproduce the issue myself - and I don't intend to try for fear of corrupting more data. I am working with a Postgres database updating table geometry through the database connection in QGIS. I had been working through an open connection for over an hour, committing changes periodically, when a commit corrupted the geometry in the db table. The lines that I had been working on - filtered by attribute in the SQL query - became invalid. The rest of the lines we unaffected - implies the invalidity was a result of something in the SQL update/commit?

I wish I could give you more information than this. Thank you for your time!

[qgib]

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

---

unfortunately not reproducable.

---

• resolution was changed from to worksforme
• status_id was changed from Feedback to Rejected