]> granicus.if.org Git - postgresql/commit
Ignore partitioned tables when processing ON COMMIT DELETE ROWS
authorMichael Paquier <michael@paquier.xyz>
Mon, 5 Nov 2018 00:15:08 +0000 (09:15 +0900)
committerMichael Paquier <michael@paquier.xyz>
Mon, 5 Nov 2018 00:15:08 +0000 (09:15 +0900)
commit948af52324fb0ab635ebb1c1379980dbfc589aba
treebcf6b05b64bce58d63ad5257269d2e855c6f6f2e
parent84010b9989d92bd7fb4a4b7c0e96dbe81ef101f4
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