pg-audit-json
pg-audit-json copied to clipboard
Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.
See #7 for more context.
I noticed that `application_name` is not being saved. Turns out the call to [`current_setting`](https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SET) has a wrong `setting_name` parameter: instead of ```sql current_setting('audit.application_name', true) ``` it should be simply ```sql...
Update statement fails on table that has logging enabled. The same values as insert statement succeeds. ``` 2019-05-13 03:59:30.029 UTC [63903] ERROR: operator does not exist: jsonb - jsonb at...
It's common to get the change history for a specific row/record so it helps if a new column can be added to the log table which stores the primary key...