Bug report #13907
PostgreSQL triggers - QGIS freezes when saving layer edits
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Data Provider/PostGIS | ||
| 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 |
Description
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:
History
#1
Updated by Paul Kanelli over 8 years ago
- Assignee deleted (
Jürgen Fischer) - Target version set to Version 2.14
Seems it is not a PostgSQL trigger issue. On Windows 7 QGIS 2.12.3 gets slower every time when saving a layer edit. Can someone edit the title?
#2
Updated by Paul Kanelli over 8 years ago
Layer is a PostgreSQL/PostGIS table.
#3
Updated by Sandro Santilli over 8 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 about 8 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.
#5
Updated by Nyall Dawson about 8 years ago
Try disabling all plugins. This behaviour is typical of badly behaved plugins.
#6
Updated by Paul Kanelli about 8 years ago
- Status changed from Feedback to Closed
I've uninstalled all plugins and now everything seems to work. Many thanks!
#7
Updated by Giovanni Manghi about 8 years ago
- Resolution set to invalid