Feature request #4774
Add area, length etc. triggers to DB Manager
Status: | Open | ||
---|---|---|---|
Priority: | Normal | ||
Assignee: | - | ||
Category: | DB Manager | ||
Pull Request or Patch supplied: | No | Resolution: | |
Easy fix?: | No | Copied to github as #: | 14631 |
Description
With triggers. See PostGIS Manager
History
#1 Updated by Oleg Seliverstov almost 13 years ago
Add GUI tools for PostGIS Spatial Measurements and Geometry Processing Functions
http://www.postgis.org/docs/reference.html
#2 Updated by Giovanni Manghi almost 12 years ago
- Project changed from 27 to QGIS Application
#3 Updated by Giovanni Manghi almost 12 years ago
- Category set to DB Manager
#4 Updated by Giovanni Manghi almost 12 years ago
- Assignee deleted (
Giuseppe Sucameli)
#5 Updated by Médéric RIBREUX almost 9 years ago
- Status changed from Open to Feedback
Hello, bug triage...
I think this is implemented in QGIS 2.13 (the sql dictionnary of DB Manager has measurement and processing functions).
Is there anything missing on this old feature request ?
#6 Updated by Paolo Cavallini almost 9 years ago
- Status changed from Feedback to Open
Sorry I was unclear. I'm talking about the old function present in the previous PostGIS Manager, not ported to DB Manager.
With that, the user could easily add a new column with the geom measurement (area, perimeter, length etc. as appropriate), and at the same time adding a trigger for the update of the values on update or insert.
#7 Updated by Giovanni Manghi over 7 years ago
- Easy fix? set to No
#8 Updated by Paolo Cavallini almost 7 years ago
Still true in QGIS 3
#9 Updated by Paolo Cavallini almost 7 years ago
- Subject changed from Add geometry processing to Add area, length etc. triggers to DB Manager