Bug report #13907
PostgreSQL triggers - QGIS freezes when saving layer edits
|Affected QGIS version:||2.12.0||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||invalid|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||21929|
Using PostgreSQL triggers saving layer edits gets slower and slower every time when saving a layer edit. The problem occurs after a few up to a few dozen saved layer edits. Finally QGIS freezes completely.
I've tried the posted triggers in the folowing link:
#3 Updated by Sandro Santilli over 5 years ago
- Crashes QGIS or corrupts data changed from Yes to No
- Status changed from Open to Feedback
Do I understand correctly it still happens without any trigger defined ?
What kind of edits do you make ?
Can you provide a step-by-step guide on how to reproduce ?
I'm unchecking "causes crash or corruption" as I understand there's no corruption and no crash (but a freeze, which may be prevented by closing qgis after some edits, and re-opening, right ?)
#4 Updated by Paul Kanelli over 5 years ago
Meanwhile I suppose it's neither a trigger nor a PostGIS issue. Most of the time I'm just adding new features. QGIS gets slower every time saving layer edits. After restarting QGIS everything is fine again until saving a few layer edits. I will provide a step by step guide within the next few days.