Feature request #4774

Add area, length etc. triggers to DB Manager

Added by Paolo Cavallini over 8 years ago. Updated over 2 years ago.

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 over 8 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 over 7 years ago

  • Project changed from 27 to QGIS Application

#3 Updated by Giovanni Manghi over 7 years ago

  • Category set to DB Manager

#4 Updated by Giovanni Manghi over 7 years ago

  • Assignee deleted (Giuseppe Sucameli)

#5 Updated by Médéric RIBREUX over 4 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 over 4 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 about 3 years ago

  • Easy fix? set to No

#8 Updated by Paolo Cavallini over 2 years ago

Still true in QGIS 3

#9 Updated by Paolo Cavallini over 2 years ago

  • Subject changed from Add geometry processing to Add area, length etc. triggers to DB Manager

Also available in: Atom PDF