On Monday, April 21, 2025, senor <frio_cerv...@hotmail.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.