Horton

Thread

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.

  1. DOC: fixes multiple errors in alter table doc

    Chao Li <li.evan.chao@gmail.com> — 2025-12-18T07:22:09Z

    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.

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

  2. Re: DOC: fixes multiple errors in alter table doc

    Chao Li <li.evan.chao@gmail.com> — 2025-12-19T05:26:38Z

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