Horton

Re: DOC: fixes multiple errors in alter table doc

Chao Li <li.evan.chao@gmail.com>

View thread
From: Chao Li <li.evan.chao@gmail.com>
To: Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-12-19T05:26:38Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. doc: Clarify that COLUMN is optional in ALTER TABLE ... ADD/DROP COLUMN.


> On Dec 18, 2025, at 15:22, Chao Li <li.evan.chao@gmail.com> wrote:
> 
> Hi Hacker,
> 
> While working on a patch these days, my eyes are on the “alter table” doc, and found multiple errors:
> 
> 1. Several sub-commands are missed in the top “action” list:
> 
>    * ALTER COLUMN SET <sequence-option>
>    * ALTER COLUMN RESTART
>    * RENAME
>    * SET SCHEMA
>    * ATTACH PARTITION
>    * DETACH PARTITION
>    * MERGE PARTITION
>    * SPLIT PARTITION
> 
> 2. In sub-command details section, "ADD COLUMN [ IF NOT EXISTS ]” missed “[]" with “COLUMN”, which is misleading, because “COLUMN” is actually optional.
> 
> 3. For all “alter column” sub-commands, "ALTER [ COLUMN ]” are omitted, which is also confusing, because none of other sub-commands omit their prefix part.
> 
> This patch fixed all these issue.
> 
> <v1-0001-doc-clarify-and-complete-ALTER-TABLE-syntax-in-re.patch>

CF entry created: https://commitfest.postgresql.org/patch/6328/

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/