v.13.3 Trigger Before Insert

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.

Browse pgsql-bugs by date

  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