MIME-Version: 1.0
In-Reply-To: <D8FD5BAF-2AC0-4289-B96E-D3BD99599BE6@gmail.com>
References: <CAEoWx2=mYhCfsnHaN96Qqwq5b0GVS2YgO3zpVqPPRd_iO52wRw@mail.gmail.com>
 <90F9169D-135C-45E5-8221-4F79DAED98E2@gmail.com> <CAKFQuwbWNCX1M1e9_-3P9RVGo10huPjuqdL74FJ+-a5EW791KA@mail.gmail.com>
 <D559C6FA-E101-47F3-BCDF-CEA7FFDF6154@gmail.com> <CAKFQuwZ+o6La5DyK9_-L2gpeiKNvGMbR78UjocO4++JkyZaRHw@mail.gmail.com>
 <A8FA43A6-415E-421A-B3EC-CAB68756975D@gmail.com> <CAKFQuwabxFyFQob=RfKOV3upjxwomAzmGzSouN-h2ypuXz+dZg@mail.gmail.com>
 <46DA7611-C18D-4782-AEFF-F861ECDEFA5C@gmail.com> <CAKFQuwZaquUrTOhfmJ2CenwiyAHx4nORQ0kB01sL+z5pCBuLFQ@mail.gmail.com>
 <CAEoWx2mUiCYJEBuo5D74gi7pHfNz82b54oDHjZNtrXRFDnBPOg@mail.gmail.com>
 <CAKFQuwbQ=L8w8jEaB8_gW-RrNv2_V-VrFYBump7__z-vh-QJWw@mail.gmail.com>
 <CAEoWx2nwoBtWX3=UOQQpGZOuRH5vNv2PHqeFHqDPdiKGaOigiA@mail.gmail.com>
 <CAKFQuwZyJNBN+N5Qtcg0aG6ZpOFvQV5m=cALLgv7g3u1Sz-tZw@mail.gmail.com>
 <245AA9F3-7577-46D6-990C-C308A9F36E82@gmail.com> <CAKFQuwZr_GLBOOLohfEcKVVTcP9D+nzVdUUKabYbXWXRnOFjnA@mail.gmail.com>
 <CAEoWx2=CK=QEvpL5HSgFEuFqjO2Q1sDy6a2G-s-+zv+RzB3mTw@mail.gmail.com>
 <CAN4CZFNoLSUcVKcOOJgOtTkDuOseCL5j9MQr3tGjb3btD=jHNQ@mail.gmail.com>
 <CAKFQuwZwAuO3qXEeqxwV6vM+89BkB-aSkcXqDGG8e_xBy_Q3Xw@mail.gmail.com>
 <C3E25893-E862-4EA4-825C-BEB5CE3B62C2@gmail.com> <CAKFQuwa9OEJ_sygQi3fNKxzQz7M6V7-zu=4fL0rquXCjudUoyw@mail.gmail.com>
 <D8FD5BAF-2AC0-4289-B96E-D3BD99599BE6@gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 25 Jan 2026 22:38:16 -0700
Message-ID: <CAKFQuwbXVypHH=tQEGo-PskaOjnaPwheh7m-PBw-4QDd8bJMeg@mail.gmail.com>
Subject: Re: docs: clarify ALTER TABLE behavior on partitioned tables
To: Chao Li <li.evan.chao@gmail.com>
Cc: Postgres hackers <pgsql-hackers@lists.postgresql.org>, 
	Zsolt Parragi <zsolt.parragi@percona.com>, Amit Kapila <amit.kapila16@gmail.com>
Content-Type: multipart/alternative; boundary="000000000000fa2fb4064943e9f6"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbXVypHH%3DtQEGo-PskaOjnaPwheh7m-PBw-4QDd8bJMeg%40mail.gmail.com>
Precedence: bulk

--000000000000fa2fb4064943e9f6
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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>
> ```
>

=E2=80=A6are renamed implicitly, ONLY is not allowed, and the command canno=
t=E2=80=A6(and
drop the mention of table renaming).

Or:

=E2=80=9CWhen applied to a partitioned table=E2=80=99s 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.=E2=80=9D

I find the repeated use of =E2=80=9Ctable=E2=80=9D =E2=80=9Cname(d)=E2=80=
=9D and =E2=80=9Crename(d)=E2=80=9D in one
sentence worth avoiding.

David J.

--000000000000fa2fb4064943e9f6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sunday, January 25, 2026, Chao Li &lt;<a href=3D"mailto:li.evan.chao@gma=
il.com">li.evan.chao@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail=
_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:=
1ex"><br>
How about this:<br>
```<br>
&lt;para&gt;<br>
=C2=A0When applied to a partitioned table to rename columns or constraints,=
<br>
=C2=A0the corresponding partition columns and constraints are renamed<br>
=C2=A0implicitly. &lt;literal&gt;ONLY&lt;/literal&gt; is not allowed, and t=
he command<br>
=C2=A0cannot be used on individual partitions. When the rename target is th=
e<br>
=C2=A0table name, only the named table is renamed.<br>
&lt;/para&gt;<br>
```<br>
</blockquote><div><br></div><div>=E2=80=A6are renamed implicitly, ONLY is n=
ot allowed, and the command cannot=E2=80=A6(and drop the mention of table r=
enaming).</div><div><br></div><div>Or:</div><div><br></div><div>=E2=80=9CWh=
en applied to a partitioned table=E2=80=99s name only the parent is changed=
, partitions must be renamed separately.=C2=A0 However, column or constrain=
t renaming must be done on the parent without ONLY, the corresponding parti=
tion columns or constraints will be renamed implicitly.=E2=80=9D</div><div>=
<br></div><div>I find the repeated use of =E2=80=9Ctable=E2=80=9D =E2=80=9C=
name(d)=E2=80=9D and =E2=80=9Crename(d)=E2=80=9D in one sentence worth avoi=
ding.</div><div><br></div><div>David J.</div><div><br></div>

--000000000000fa2fb4064943e9f6--