PGXN

Contents

To delete entries in the audit table pgMemento offers a simple API to remove logs caused by one transaction (delete_txid_log) or one event (delete_table_event_log). One has to be sure that deleting logs changes the audit trail of the data. Historic versions of tuples and tables will get lost.

There are also functions to remove all logs by table and schema name from the data and even the schema log tables. But in case you want to remove a table's audit trail you should use drop_table_audit.