doc: Fix misleading synopsis for CREATE/ALTER PUBLICATION.
authorFujii Masao <[email protected]>
Thu, 27 Nov 2025 14:30:51 +0000 (23:30 +0900)
committerFujii Masao <[email protected]>
Thu, 27 Nov 2025 14:31:36 +0000 (23:31 +0900)
commitd7977668eec65363012797302b492adff1578274
tree18e353cdef4c4dd1892ae7e72c8db2616c70bd23
parentb5511fed500eb526a547f38597307552fa7acd08
doc: Fix misleading synopsis for CREATE/ALTER PUBLICATION.

The documentation for CREATE/ALTER PUBLICATION previously showed:

        [ ONLY ] table_name [ * ] [ ( column_name [, ... ] ) ] [ WHERE ( expression ) ] [, ... ]

to indicate that the table/column specification could be repeated.
However, placing [, ... ] directly after a multi-part construct was
misleading and made it unclear which portion was repeatable.

This commit introduces a new term, table_and_columns, to represent:

        [ ONLY ] table_name [ * ] [ ( column_name [, ... ] ) ] [ WHERE ( expression ) ]

and updates the synopsis to use:

        table_and_columns [, ... ]

which clearly identifies the repeatable element.

Backpatched to v15, where the misleading syntax was introduced.

Author: Peter Smith <[email protected]>
Reviewed-by: Chao Li <[email protected]>
Reviewed-by: Fujii Masao <[email protected]>
Discussion: https://postgr.es/m/CAHut+PtsyvYL3KmA6C8f0ZpXQ=7FEqQtETVy-BOF+cm9WPvfMQ@mail.gmail.com
Backpatch-through: 15
doc/src/sgml/ref/alter_publication.sgml
doc/src/sgml/ref/create_publication.sgml