Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

data_last_update field question #154

Open
mixedbredie opened this issue Mar 8, 2023 · 1 comment
Open

data_last_update field question #154

mixedbredie opened this issue Mar 8, 2023 · 1 comment

Comments

@mixedbredie
Copy link

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
Copy link
Contributor

effjot commented Mar 9, 2023

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)”.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants