large update: multiple prs

2ndQuadrant / audit-trigger

Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.

Other

657 stars 241 forks source link

large update: multiple prs #48

Closed iloveitaly closed 1 year ago

iloveitaly commented 1 year ago

This PR includes a bunch of the changes from the other PRs:

converted from hstore to jsonb
Add a function to stop auditing a table.
Added option to not track insert statements.
remove unused variables
add pk to the table schema

In case it's easier to review in one big shot

jenast commented 11 months ago

Thanks. This worked well for me after changing the type of row_id to 'text' in audit.logged_actions. That way you can monitor tables with different datatypes as primary keys as row_id is cast to text.