v.13.3 Trigger Before Insert

Поиск
Список
Период
Сортировка
От Max Tomich
Тема v.13.3 Trigger Before Insert
Дата
Msg-id SYBPR01MB543726A0B7D8250BD915C3E7A6A89@SYBPR01MB5437.ausprd01.prod.outlook.com
обсуждение исходный текст
Список 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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: [EXTERNAL] Re: pg_basebackup behavior on non-existent slot
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)?