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.