On Monday, April 21, 2025, senor <frio_cervesa(at)hotmail(dot)com> wrote:
>
> I'm mainly interested in understanding how this works or why it can't
>
Partition routing happens on fully-formed tuples. They thus must be formed
initially using only context, like defaults, attached to the partitioned
table.
You can do what you want if you directly insert into the individual
partitions, using the partitioned table as a read-only interface.
It looks like this:
https://dbfiddle.uk/Xc3cUHSO
David J.