Adds ability to replay edits and log views

haubourg commented 7 years ago

And also merges PR #20 #22 #21 Authors: Sylvain Beorchia, Hugo Mercier, Régis Haubourg (all from Oslandia) This PR adds:

a new function to create a instead of row level trigger for auditing views.
a new table logged_relation is added to keep track of identifier columns used to replay updates or deletes for views (primary keys are not accessible through catalog views)
a new function replay_event(event_id) is also added to ease replaying stored actions.

This PR goes in sync with a QGIS plugin (A great Open Source GIS tool) that allows to search logged actions and replay old edits. It can be found here https://github.com/qwat/pg-history-viewer

We'd love to see that merged so that the postgresql community keeps one only reference for that awesome audit trigger. Please tell me if that sounds possible.

haubourg commented 7 years ago

If anyone is interested, we decided to host the sql scripts with the QGIS plugin using it for history searching and replaying in this repository https://github.com/qwat/pg-history-viewer It currently is not different from this PR but it can became a real fork once. Please ping here if the repo is revived one day.

ringerc commented 5 years ago

I don't intend to merge this, it considerably expands the scope and makes things too complex for the intended purpose. I appreciate that you shared it, but I don't want to merge on master.

haubourg commented 5 years ago

@ringerc thanks for letting us know. Is the audit trigger still maintained on your side?

ringerc commented 5 years ago

@haubourg Not meaningfully so. I simply lack the time at this point. It really needs to be jsonb-ified.

2ndQuadrant / audit-trigger

Adds ability to replay edits and log views #26