From: | Max Tomich <v-mtomich(at)cuscal(dot)com(dot)au> |
---|---|
To: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | v.13.3 Trigger Before Insert |
Date: | 2021-09-28 12:57:59 |
Message-ID: | SYBPR01MB543726A0B7D8250BD915C3E7A6A89@SYBPR01MB5437.ausprd01.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-09-28 13:39:36 | Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? |
Previous Message | Dimitri Fontaine | 2021-09-28 11:12:51 | Re: [EXTERNAL] Re: pg_basebackup behavior on non-existent slot |