Known Limitations

There are a few known limitations.

• Certain kinds of SQL statements (such as CREATE TABLE foo AS select ...) produce multiple auditing records. This cannot be disabled due to the way PostgreSQL itself invokes various internal hooks.

• The plugin cannot determine the accessed object for certain statements:

  • CREATE MATERIALIZED VIEW

  • CREATE SCHEMA when no schema name is supplied. (The SQL syntax allows this in certain cases.)

  • DROP CAST

• When logging to a file, records are flushed when the standard I/O buffer fills up and/or when the session ends.

• Attempting to install a plugin compiled for one major version of PostgreSQL on another will fail. PostgreSQL 9.3 and later print a "version mismatch" message to the start-up log. In such a case the database will not come up.

  This is a limitation of PostgreSQL.