3liz / qgis-pgmetadata-plugin

QGIS Plugin to manage some metadata from PostgreSQL layer
GNU General Public License v2.0
12 stars 10 forks source link

data_last_update field question #154

Open mixedbredie opened 1 year ago

mixedbredie commented 1 year ago

How is the data_last_updated field intended to be used? The pgmetadata.dataset table has the creation_date and update_date fields that are populated by a trigger when the record is created or updated.

In our workflow we have users editing PostGIS tables and updates are pushed into a live database where we have the pgmetadata plugin configured. Each time a table is created or updated we have a trigger that updates the pgmetadata.dataset table by either inserting a new record or updating an existing one. The date fields are populated. The data_last_updated field is not referenced in any of the functions in the plugin and I was wondering whether this was for a manual update by a user.

effjot commented 1 year ago

I understand the data_last_updated field as a way for the “metadata administrator” to store the date of the last update of the geodata / layer itself (opposed to the last update of the metadata in update_date). According to the docs, it is the “Date of the last modification of the target data (not on the dataset item line)”.