The release notes for pg 13 advertise a new feature in https://www.postgresql.org/docs/13/release-13.html#DDL-PARTITION-PRUNING
- > > Allow BEFORE row-level triggers > <https://www.postgresql.org/docs/13/triggers.html> on partitioned tables > (Álvaro Herrera) > > These triggers cannot change which partition is the destination. > - But the manual still warns at https://www.postgresql.org/docs/13/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS BEFORE ROW triggers, if necessary, must be defined on individual > partitions, not the partitioned table. > Looks like that "limitation" can go now? Or reduced to something like: "BEFORE ROW triggers on the partitioned table cannot change which partition is the destination." Regards Erwin