Hello all,
looking at the pgaudit logs I can not see the event status of DDL or DML.
All rows are “state: INPROGRESS”
e.g. the following two rows in the audit trail:
2025-09-09 14:20:21.010 GMT,“postgres”,“hrprod”,84139,“[local]”,68c03794.148ab,11,“INSERT”,2025-09-09 14:20:04 GMT,1/4,768,DEBUG,00000,“CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 768/1/0 (used)”,“insert into dummy values (1);”,“psql”,“client backend”,0
2025-09-09 14:51:08.444 GMT,“postgres”,“hrprod”,86684,“[local]”,68c03d25.1529c,21,“CREATE TABLE”,2025-09-09 14:43:49 GMT,2/10,772,DEBUG,00000,“CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 772/1/1”,"CREATE TABLE ““DEMO_HR_ROLES””
( ““USERID”” VARCHAR(100),
""ROLEID"" VARCHAR(100)
) ;",“psql”,“client backend”,0
What am I missing?
Thanks,
Frank