Commits on Aug 6, 2026
-
docs: clarify ALTER TABLE behavior on partitioned tables
Document how individual ALTER TABLE sub-commands behave when applied to partitioned tables. The existing ALTER TABLE documentation provides limited or incomplete information about how commands interact with partitioned tables, leaving users to infer behavior from experimentation. This patch systematically clarifies, for each relevant sub-command, whether changes propagate to existing partitions, can be applied independently to partitions, and how the ONLY keyword behaves. In addition, clarify in CREATE TABLE documentation which parent table settings are inherited by newly created partitions and which are not. This makes explicit that while most definition-level properties are inherited from the partitioned table, certain per-relation settings (such as ownership, schema, replica identity, row-level security, and per-attribute statistics/options) are not, unless explicitly specified. No behavior is changed by this patch; it is purely a documentation update intended to make existing semantics explicit and easier to understand. Author: Chao Li <lic@highgo.com> Author: David G. Johnston <David.G.Johnston@Gmail.com> Reviewed-by: David G. Johnston <David.G.Johnston@Gmail.com> Reviewed-by: Zsolt Parragi <zsolt.parragi@percona.com> Discussion: https://postgr.es/m/CAEoWx2=mYhCfsnHaN96Qqwq5b0GVS2YgO3zpVqPPRd_iO52wRw@mail.gmail.com
authored and Commitfest Bot committed
Aug 6, 2026