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 ------ REL_11_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/948af52324fb0ab635ebb1c1379980dbfc589aba 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(+)
