ERROR: no partition of relation "audit_data_log" found for row
Is result of an attempt to dynamically create partition and sub partition by having BEFORE INSERT TRIGGER that executes FUNCTION.
This function would create partition and sub partition if they NOT EXISTS on table audit_data_log created as partitioned.
Trigger:
create trigger sp_audprattrigger
before insert on audit_data_log
for each row execute procedure create_partsub();
It would be nice if this feature works.
This would be as paving your path as go.
Kind Regards.
Max.