GNOME Bugzilla – Bug 574774
Add created/modified fields, updated automatically.
Last modified: 2021-07-05 10:52:29 UTC
These fields are generally useful for investigation and will be useful for replication. We need to check that all INSERTS and UPDATES are done via some utility function, so we can update these fields.
For Postgres, we might be able to update the values via a trigger. See for instance, CREATE TRIGGER tafter AFTER INSERT OR UPDATE here: http://www.postgresql.org/docs/8.3/interactive/trigger-example.html But that might be difficult to maintain and it would not work for our sqlite backend. On the plus side, there would be no risk of using the client's local time. Note that we need to have both date and time fields for these, and we need to convert from the client's timezone to UTC.
I'm working on this in the "modification" branch in git.
*** Bug 669464 has been marked as a duplicate of this bug. ***
That branch is very old, so I should probably start again. Note that this should involve 6 extra fields: creation user, creation date, creation time, modified user, modified data, modified time. This commit, in the branch, seems to be part of that work: http://git.gnome.org/browse/glom/commit/?h=modification&id=2931e18ea2611e702b92583b0e8717525756daa5
Ok, any other thing to test just tell me.
GNOME is going to shut down bugzilla.gnome.org in favor of gitlab.gnome.org. As part of that, we are mass-closing older open tickets in bugzilla.gnome.org which have not seen updates for a longer time (resources are unfortunately quite limited so not every ticket can get handled). If you can still reproduce the situation described in this ticket in a recent and supported software version, then please follow https://wiki.gnome.org/GettingInTouch/BugReportingGuidelines and create a new ticket at https://gitlab.gnome.org/GNOME/glom/-/issues/ Thank you for your understanding and your help.