2

I've been correcting our address point file using various methods to identify points that need to be corrected, with the final step being a manual move the point (or by the Numerical Vertex Edit) to its corrected location using QGIS.

What I'd like to do is update the MODIFIED_DATE field automatically when the geometry is moved.

The address points live in PostGIS.

I can see that by setting the Field Edit Widget type to DATE/TIME, and then identifying the point and enabling the 'Auto open form' option, the date will be updated.

But can the date value be updated when the geometry is moved, by some type of dynamic field, or other method?

Improve this question

1 Answer 1

Reset to default
1

A trigger on the date field is what you're looking for. Here's a good example:

http://www.revsys.com/blog/2006/aug/04/automatically-updating-a-timestamp-column-in-postgresql/

This will allow the database to handle the date updates automatically, you don't have to worry about it.

Improve this answer
1
  • Interesting! Let me try that out and report back! Thank you!
    – Inactivated Account
    Commented Oct 15, 2015 at 16:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.