Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1viOaH-0052O1-1t for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Jan 2026 03:08:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1viOaG-004VIW-1f for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Jan 2026 03:08:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1viOaG-004VIO-0b for pgsql-hackers@lists.postgresql.org; Wed, 21 Jan 2026 03:08:40 +0000 Received: from mail-oi1-x230.google.com ([2607:f8b0:4864:20::230]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1viOaE-001dt5-1p for pgsql-hackers@lists.postgresql.org; Wed, 21 Jan 2026 03:08:40 +0000 Received: by mail-oi1-x230.google.com with SMTP id 5614622812f47-45c87d82bd2so4232182b6e.1 for ; Tue, 20 Jan 2026 19:08:38 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1768964917; cv=none; d=google.com; s=arc-20240605; b=Ccc0RC5j+Zaco/vOUZEW2FC+N1KQdbRn9QdwNz/rnqQnrg+704GjUKmHJz90JSc8Sw sqw8KrRmAAV81zM8WzvyHs9vmKA/ZziZGegv78cl1oH2z/kGhMo5aoSNrRHuzGfflzGL rGeevRyamSsmNatL0qr/py+k0rJ3wvkATdN3v3rk9IMw9WYRgmuect3syYxvatUIA5TG wGFRWzOEvjaZiOdUn4XDkb1xmhB+K5D+v/SX4VbTrcQEMDuiT1U7htQB517nrOHtxGII YAmqXSnn89GEMcBY8WIq/afcbcceVG1kRdR08ogxMfE65FF+cWaLqckOwaJv80TtK9f8 NXMg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=mNzzlOF8pkLUOa4vyDgX4N/AvTjYg9BN3n5pSKV9v5c=; fh=2yAa+1jZWBZ78HRwgvhE6JapS1feuaDT8NcRMstGHPM=; b=ZKCNPdr88XPYdbV4UmslCVJFTTYg6qE+7Mr7HHsMesY7asrUkF+wobUZgRZ/GuqLZG /OqN1NENwLy616/sb47o5AQoEa3WWa83aKtnfdpgoTDRlLSYa7Tjl8TnCgSiC8AO4Psj Mqnp+qbN6T00tIDLC4ndUnyupzned7jkZpyDHvVDA8VfDFUpPGTFkSXw1u1cNVX+gzSK 456Vu6Z0L1d6wGksp/AThfSaJ9OpNMgN4AORKrFnsPvHLMLEwVEhwafjhBgKZ0Y7Sv3o fne1saIp/XD2pHK9E7GU7uoxliJz2vnv9vJ7PnBDMXIp9anevN99M29oDNZR1XvdW4+E sUiA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1768964917; x=1769569717; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=mNzzlOF8pkLUOa4vyDgX4N/AvTjYg9BN3n5pSKV9v5c=; b=FNnWE3257w80lDRFsVikaOun9bVKRvy2pPPXfHKz7Fwde+BME524uM1JCrIH/PR/Gv GkFC2jPZVI7rPBvx/mBmEIwkrCKJyl5p1BOhK5rlhuMoV1LEBc5R3sc1StXLP0nY6ZTa iW/OqxGV2VeUXrV1HDiOsMaPgwAN6nJlX9la0hl9P1dCC716ci1S9OPqmR4eqf4bweaq wqur+ni5HKoelAyo6jBgm+P2EPb/66aNylrWJ9GaRKkdRVVyKBu+BNseDUIcoXGRBA6A Dh4cs9e8uI1a4NH0hsGcxs9kiAbqHJpQLoBORNhRIRxAURwFpsjnm7Chynrp/IBQCJFR SyDQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768964917; x=1769569717; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=mNzzlOF8pkLUOa4vyDgX4N/AvTjYg9BN3n5pSKV9v5c=; b=YW5PrkjeMbkQOF39EiEQZPFX5AKueDGFw8ZwLF3IDlvUNX58AE33g7YdUNETyxTMYw S39UlwrjlO6rB+A+qfPmL34xCThSZlaUN3F0C3f0ZDxR27WVCLyLrMP15MgpxiYeYYxW EvvWfnyvNHa8p3VlnDb7z9VQbF+aZ5fbS/GaXJymvT5+g+Dojxekadod7++xcLt5zNMs b7ZGMMjHZgJM1hryjD5Mf4grsa8zEigZQn4bSQZmR+mc1WFMrAOe+9BwGpREG3FBBWjO ml+Kwrbyl23Fd6PBT0sqeB020qaDJO3HkLBLfkCel+d29vZl5D4Ulfkh7jhuIqLdVW12 5PSQ== X-Gm-Message-State: AOJu0YyJRDln2FQWG6GWgDqYSUnSUyoI3uFVpTwLh0BAzX6k3Ad7zyOj gARr5CZstFPj+ZP/Z6x5toT1/t+fWDlyxuVcNmWV/szO+hjbIeVx7M//qX+ZzWey8ymAm7ObjBD XygERF9WL5FOHHuokaUSVUocGuHwuhpo= X-Gm-Gg: AY/fxX5L+RaITPMQo5ol0DUkaFjRFxgHsebO2+1wdEbRB7q8CAlQpL2cnBIgBk4VKrj C4YJcbC/kY89gsmylgGe7Qpye1uQk6QO/rusbROMCv1C0FCvUon4Usn3IO/jp9ydiK8h95OsJCL JtPONN9qNojUvxsX0s2A/3YM8MNDT3rBKsQQhBGyBDmhW+dbAmvnjyEW69YpnfHrlaTLbm7pSQl hgYV7YpvWhLlTiyOLBUKJajEMrOgEt/L3vKkdu49X/VdyKOXAT+g5OmQhZcTLjLrQViVq76 X-Received: by 2002:a05:6820:490f:b0:65c:f821:9dd3 with SMTP id 006d021491bc7-661179f9e7bmr6437984eaf.70.1768964916717; Tue, 20 Jan 2026 19:08:36 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ac9:7756:0:b0:619:b970:e659 with HTTP; Tue, 20 Jan 2026 19:08:36 -0800 (PST) In-Reply-To: <245AA9F3-7577-46D6-990C-C308A9F36E82@gmail.com> References: <90F9169D-135C-45E5-8221-4F79DAED98E2@gmail.com> <46DA7611-C18D-4782-AEFF-F861ECDEFA5C@gmail.com> <245AA9F3-7577-46D6-990C-C308A9F36E82@gmail.com> From: "David G. Johnston" Date: Tue, 20 Jan 2026 20:08:36 -0700 X-Gm-Features: AZwV_QhqOBdf1qZCQCc1TBWIrFBgaI5EtcRExCrVAMousE4lKWTxUbmHy7VLIkE Message-ID: Subject: Re: docs: clarify ALTER TABLE behavior on partitioned tables To: Chao Li Cc: Postgres hackers , Amit Kapila Content-Type: multipart/alternative; boundary="0000000000007b2bf40648dd3d93" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007b2bf40648dd3d93 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, January 20, 2026, Chao Li wrote: > > > > On Jan 21, 2026, at 09:09, David G. Johnston > wrote: > > > > On Mon, Jan 19, 2026 at 1:20=E2=80=AFAM Chao Li wrote: > > > > Thanks again for your review. I have integrated all your edits to v4. > Once you consider the changes are okay, can you please mark the CF entry > [1] as Ready for Committer? > > > > > > v5 Attached with a delta. > > > > There exists described behaviors in the notes that are being removed > that need to be retained; pertaining to inheritance setups. I put a note > in place of the removals pointing out that when inheritance is being used > for partitioning the rules for partitioned tables apply (implied 'unless > otherwise noted') and that local/independent objects can always be > addressed normally. I then incorporated the notes into the appropriate > sub-command sections. Please give it a sanity check since I'm still > getting my head around all this. > > > > David J. > > > > .patch> > > Hi David, > > Thanks for your continuous review. I just checked the delta: > The tweaks all look good. David J. --0000000000007b2bf40648dd3d93 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, January 20, 2026, Chao Li <li.evan.chao@gmail.com> wrote:


> On Jan 21, 2026, at 09:09, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
> On Mon, Jan 19, 2026 at 1:20=E2=80=AFAM Chao Li <li.evan.chao@gmail.com> wrote:
>
> Thanks again for your review. I have integrated all your edits to v4. = Once you consider the changes are okay, can you please mark the CF entry [1= ] as Ready for Committer?
>
>
> v5 Attached with a delta.
>
> There exists described behaviors in the notes that are being removed t= hat need to be retained; pertaining to inheritance setups.=C2=A0 I put a no= te in place of the removals pointing out that when inheritance is being use= d for partitioning the rules for partitioned tables apply (implied 'unl= ess otherwise noted') and that local/independent objects can always be = addressed normally.=C2=A0 I then incorporated the notes into the appropriat= e sub-command sections.=C2=A0 Please give it a sanity check since I'm s= till getting my head around all this.
>
> David J.
>
> <v5-0001-docs-clarify-ALTER-TABLE-behavior-on-partitioned-.patch><v5-0002-delta.patch>

Hi David,

Thanks for your continuous review. I just checked the delta:

The tweaks all look good.

David J.
=C2=A0
--0000000000007b2bf40648dd3d93--