Re: docs: clarify ALTER TABLE behavior on partitioned tables - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: docs: clarify ALTER TABLE behavior on partitioned tables
Date
Msg-id CAKFQuwbXVypHH=tQEGo-PskaOjnaPwheh7m-PBw-4QDd8bJMeg@mail.gmail.com
Whole thread Raw
In response to Re: docs: clarify ALTER TABLE behavior on partitioned tables  (Chao Li <li.evan.chao@gmail.com>)
Responses Re: docs: clarify ALTER TABLE behavior on partitioned tables
List pgsql-hackers
On Sunday, January 25, 2026, Chao Li <li.evan.chao@gmail.com> wrote:

How about this:
```
<para>
 When applied to a partitioned table to rename columns or constraints,
 the corresponding partition columns and constraints are renamed
 implicitly. <literal>ONLY</literal> is not allowed, and the command
 cannot be used on individual partitions. When the rename target is the
 table name, only the named table is renamed.
</para>
```

…are renamed implicitly, ONLY is not allowed, and the command cannot…(and drop the mention of table renaming).

Or:

“When applied to a partitioned table’s name only the parent is changed, partitions must be renamed separately.  However, column or constraint renaming must be done on the parent without ONLY, the corresponding partition columns or constraints will be renamed implicitly.”

I find the repeated use of “table” “name(d)” and “rename(d)” in one sentence worth avoiding.

David J.

pgsql-hackers by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: Newly created replication slot may be invalidated by checkpoint
Next
From: Bertrand Drouvot
Date:
Subject: Re: Flush some statistics within running transactions