audit-trigger

audit-trigger copied to clipboard

ritschwumm

change 3 occurrences of CREATE INDEX to CREATE INDEX IF NOT EXISTS so audit.sql can be rerun without error. (Amended file attached if it is acceptable) [audit.zip](https://github.com/2ndQuadrant/audit-trigger/files/6906049/audit.zip)

simondh

This has the option to not trigger the audit on inserts. Should be backwards compatible, although I must admit I did not test that as I don't have a setup...

peterbecker

Enhancement: View displaying list of tables/schemas for which auditing is enabled

1

Hi, I think it would be really useful to include a simple view that shows the tables for which auditing is enabled, as otherwise the only way of knowing is...

archaeogeek

Add a function to stop auditing a table.

1

A helper function to stop auditing a table.

openbrian

Just converted from hstore to jsonb

12

- Removed hstore dependency; - Using jsonb builtin type; - Postgres 10+.

michelmilezzi

On you [documentation](https://wiki.postgresql.org/wiki/Audit_trigger_91plus) page you say: >>>

pbryant-phew

How do I use to audit tables in different schemas ?

5

How do I use to audit tables in different schemas ? Our database has 4 different schemes. Ex: scfinadmhppq.client

OsvaldoTCF

Statement only trigger not consistent with ORMs

1

Statement only trigger not consistent with ORMs ! I would like to highlight that using statement only mode does not produces whole SQL when using with ORMs. The statement only...

ernitishkumar

action column is char(1) instead of text

1

another bonus is that the index for that column is a lot smaller

The-Alchemist