kvesteri / postgresql-audit

Audit trigger for PostgreSQL
BSD 2-Clause "Simplified" License
126 stars 28 forks source link

Specify the column names when inserting new audit rows #49

Closed quantus closed 4 years ago

quantus commented 4 years ago

In our project the order of the columns in our database doesn't match the one used by the INSERT statements in the create_activity function. We noticed this issue as we manually compared our database functions to the ones specified in our SQLAlchemy metadata. This will become an minor issue for us as we're planning to add automated tests for the database schema.