git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a0ed19e) | patch
Fix MERGE with DO NOTHING actions into a partitioned table.
2025年3月29日 09:58:40 +0000 (09:58 +0000)
2025年3月29日 09:58:40 +0000 (09:58 +0000)
commit 8b6a0e2392b9fc3f9b821da705797bb54c982dc1
Fix MERGE with DO NOTHING actions into a partitioned table.

ExecInitPartitionInfo() duplicates much of the logic in
ExecInitMerge(), except that it failed to handle DO NOTHING
actions. This would cause an "unknown action in MERGE WHEN clause"
error if a MERGE with any DO NOTHING actions attempted to insert into
a partition not already initialised by ExecInitModifyTable().

Bug: #18871
Reported-by: Alexander Lakhin <exclusion@gmail.com>
Author: Tender Wang <tndrwang@gmail.com>
Reviewed-by: Gurjeet Singh <gurjeet@singh.im>
Discussion: https://postgr.es/m/18871-b44e3c96de3bd2e8%40postgresql.org
Backpatch-through: 15
src/backend/executor/execPartition.c diff | blob | blame | history
src/backend/executor/nodeModifyTable.c diff | blob | blame | history
src/test/regress/expected/merge.out diff | blob | blame | history
src/test/regress/sql/merge.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /