Top
Enterprise Postgres 16 Release Notes

2.9.1 Repairing Unwanted Output in the Audit Log

Incompatibility

In Fujitsu Enterprise Postgres 16, we changed the audit log so that it no longer contains unwanted information at the end.

Fujitsu Enterprise Postgres 15 SP2 or earlier

Some audit logs contain unwanted content at the end.

[Example]

Input: INSERT INTO trig_test VALUES ('new value');
Part of the audit log: NOTICE:  AUDIT: SESSION,WRITE,,[local],,pg_regress/class,,baz,,11,2,INSERT,,TABLE,public.trig_audit,,"INSERT INTO trig_audit SELECT 'I', now(), user, NULL, NEW.*","(""new value"")  trig_audit AFTER ROW INSERT 16484 trig_test trig_test public 0  f"
Fujitsu Enterprise Postgres 16

Prevent unwanted from being output to the audit log.

[Example]

Input: INSERT INTO trig_test VALUES ('new value');
Part of the audit log: NOTICE:  AUDIT: SESSION,WRITE,,[local],,pg_regress/class,,baz,,11,2,INSERT,,TABLE,public.trig_audit,,"INSERT INTO trig_audit SELECT 'I', now(), user, NULL, NEW.*","(""new value"")"

Action method

None.