pgsql: doc: Fix misleading synopsis for CREATE/ALTER PUBLICATION. - Mailing list pgsql-committers

From Fujii Masao
Subject pgsql: doc: Fix misleading synopsis for CREATE/ALTER PUBLICATION.
Date
Msg-id E1vOd2m-001fZ5-31@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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 <smithpb2250@gmail.com>
Reviewed-by: Chao Li <lic@highgo.com>
Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
Discussion: https://postgr.es/m/CAHut+PtsyvYL3KmA6C8f0ZpXQ=7FEqQtETVy-BOF+cm9WPvfMQ@mail.gmail.com
Backpatch-through: 15

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/246ec4a51c16f27133a293f63aa8bc86ca4fe630

Modified Files
--------------
doc/src/sgml/ref/alter_publication.sgml  |  8 ++++++--
doc/src/sgml/ref/create_publication.sgml | 10 +++++++---
2 files changed, 13 insertions(+), 5 deletions(-)


pgsql-committers by date:

Previous
From: Álvaro Herrera
Date:
Subject: pgsql: Fix new test for CATCACHE_FORCE_RELEASE builds
Next
From: Fujii Masao
Date:
Subject: pgsql: doc: Fix misleading synopsis for CREATE/ALTER PUBLICATION.