Ignore partitioned tables when processing ON COMMIT DELETE ROWS Those tables have no physical storage, making this option unusable with partition trees as at commit time an actual truncation was attempted. There are still issues with the way ON COMMIT actions are done when mixing several action types, however this impacts as well inheritance trees, so this issue will be dealt with later.
Reported-by: Rajkumar Raghuwanshi Author: Amit Langote Reviewed-by: Michael Paquier, Tom Lane Discussion: https://postgr.es/m/cakcux6mhgcjsib_egqeaefgx462qztncu8qcaj2hzwm-wwg...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/4bc772e2afa55f26734ff3fbdf27601db030b7e5 Modified Files -------------- src/backend/catalog/heap.c | 7 +++++++ src/test/regress/expected/temp.out | 17 +++++++++++++++++ src/test/regress/sql/temp.sql | 14 ++++++++++++++ 3 files changed, 38 insertions(+)