Re: Odd behavior of statement triggers with transition tables on partitions

2025-08-08 Thread Etsuro Fujita
On Tue, Jul 15, 2025 at 5:26 PM Etsuro Fujita wrote: > Yet another thing I noticed about transition tables is $SUBJECT: > > create table parent (a text, b int) partition by list (a); > create table child partition of parent for values in ('AAA'); > create function dump_insert() returns trigger lan

Odd behavior of statement triggers with transition tables on partitions

2025-07-15 Thread Etsuro Fujita
Yet another thing I noticed about transition tables is $SUBJECT: create table parent (a text, b int) partition by list (a); create table child partition of parent for values in ('AAA'); create function dump_insert() returns trigger language plpgsql as $$ begin raise notice 'trigger = %, new