pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Fix tablespace handling in MERGE/SPLIT partition commands. 2+ messages / 1 participants [nested] [flat]
* pgsql: Fix tablespace handling in MERGE/SPLIT partition commands. @ 2024-07-15 04:17 Fujii Masao <fujii@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Fujii Masao @ 2024-07-15 04:17 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix tablespace handling in MERGE/SPLIT partition commands. As commit ca4103025d stated, new partitions without a specified tablespace should inherit the parent relation's tablespace. However, previously, ALTER TABLE MERGE PARTITIONS and ALTER TABLE SPLIT PARTITION commands always created new partitions in the default tablespace, ignoring the parent's tablespace. This commit ensures new partitions inherit the parent's tablespace. Backpatch to v17 where these commands were introduced. Author: Fujii Masao Reviewed-by: Masahiko Sawada Discussion: https://postgr.es/m/abaf390b-3320-40a5-8815-ef476db5cfe7@oss.nttdata.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/c0868966253218d83caeeac4bfd92ca6f4994537 Modified Files -------------- doc/src/sgml/ref/alter_table.sgml | 6 ++++-- src/backend/commands/tablecmds.c | 2 +- src/test/regress/expected/partition_merge.out | 23 +++++++++++++++++++++++ src/test/regress/expected/partition_split.out | 26 ++++++++++++++++++++++++++ src/test/regress/sql/partition_merge.sql | 12 ++++++++++++ src/test/regress/sql/partition_split.sql | 13 +++++++++++++ 6 files changed, 79 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Fix tablespace handling in MERGE/SPLIT partition commands. @ 2024-07-15 04:18 Fujii Masao <fujii@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Fujii Masao @ 2024-07-15 04:18 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix tablespace handling in MERGE/SPLIT partition commands. As commit ca4103025d stated, new partitions without a specified tablespace should inherit the parent relation's tablespace. However, previously, ALTER TABLE MERGE PARTITIONS and ALTER TABLE SPLIT PARTITION commands always created new partitions in the default tablespace, ignoring the parent's tablespace. This commit ensures new partitions inherit the parent's tablespace. Backpatch to v17 where these commands were introduced. Author: Fujii Masao Reviewed-by: Masahiko Sawada Discussion: https://postgr.es/m/abaf390b-3320-40a5-8815-ef476db5cfe7@oss.nttdata.com Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/929390e4d860b641f72aece70280e66114bffbd0 Modified Files -------------- doc/src/sgml/ref/alter_table.sgml | 6 ++++-- src/backend/commands/tablecmds.c | 2 +- src/test/regress/expected/partition_merge.out | 23 +++++++++++++++++++++++ src/test/regress/expected/partition_split.out | 26 ++++++++++++++++++++++++++ src/test/regress/sql/partition_merge.sql | 12 ++++++++++++ src/test/regress/sql/partition_split.sql | 13 +++++++++++++ 6 files changed, 79 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-07-15 04:18 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-07-15 04:17 pgsql: Fix tablespace handling in MERGE/SPLIT partition commands. Fujii Masao <fujii@postgresql.org> 2024-07-15 04:18 pgsql: Fix tablespace handling in MERGE/SPLIT partition commands. Fujii Masao <fujii@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox