Ignore partitioned tables when processing ON COMMIT DELETE ROWS
authorMichael Paquier <michael@paquier.xyz>
Mon, 5 Nov 2018 00:14:33 +0000 (09:14 +0900)
committerMichael Paquier <michael@paquier.xyz>
Mon, 5 Nov 2018 00:14:33 +0000 (09:14 +0900)
commit4bc772e2afa55f26734ff3fbdf27601db030b7e5
treea7a1a993bb652b131f872d38f2e2be1f826f5ec4
parentfa534b411c86d2e7441852282ea9f1a491a090a6
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-wWGVew@mail.gmail.com
src/backend/catalog/heap.c
src/test/regress/expected/temp.out
src/test/regress/sql/temp.sql