Fix SPLIT PARTITION hint for DEFAULT partition bounds
Alexander Korotkov <akorotkov@postgresql.org>
Author:
Alexander Korotkov <akorotkov@postgresql.org>
Date: 2026-05-19T10:54:55Z
Releases:
19 (unreleased)
Fix SPLIT PARTITION hint for DEFAULT partition bounds When ALTER TABLE ... SPLIT PARTITION specifies a DEFAULT partition, the explicit partitions do not need to cover the split partition's bound exactly. They may cover only part of it, with the DEFAULT partition covering the remaining range. However, the existing hint said that the combined bounds of the new partitions must exactly match the bound of the split partition, which is misleading for this case and inconsistent with the code comment. Fix the hint to state the actual requirement: explicit partition bounds must stay within the bounds of the split partition when a DEFAULT partition is specified. Author: Chao Li <lic@highgo.com> Reviewed-by: Alexander Korotkov <aekorotkov@gmail.com> Discussion: https://postgr.es/m/C18878AB-DEB2-4A61-9995-A035DD644B81@gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/partitioning/partbounds.c | modified | +6 −8 |
| src/test/regress/expected/partition_split.out | modified | +7 −7 |
Discussion
- Fix SPLIT PARTITION bound-overlap bug and other improvements 20 messages · 2026-05-13 → 2026-05-25