Invalid table name on Postgresql

[dschoschu]

Q	A
auditor version	dev-master 8edca5b
PHP version	8.2.15
Database	PostgreSQL

Summary

We use a table called "user" which is a reserved keyword in PostgreSQL. So we have to quote it. For Doctrine the table name is "user". When using Auditor to audit the user table, it builds a table name for the audit table, but does not remove the quotes. So the table name is invalid.

I am not sure how SQLite and MySQL handle this, so it could be an edge case.

Current behavior

No insert happens on audited and audit table. No error is reported.

How to reproduce

Audit a table called "user" in PostgreSQL.
Possibly any reserved word of the database vendor. Haven't tried that.

Expected behavior

Auditor builds a valid table name for reserved keywords or at least an error is reported.

Alternative solution

If the change to generate a "valid" audit table name is too complex, a possible solution could be to provide a configuration option to manually specify an audit table name.

[DamienHarper]

@dschoschu thanks for the report, it is fixed in master