Обсуждение: DOC: fixes multiple errors in alter table doc

Поиск
Список
Период
Сортировка

DOC: fixes multiple errors in alter table doc

От
Chao Li
Дата:
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/




Вложения

Re: DOC: fixes multiple errors in alter table doc

От
Chao Li
Дата:

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