v1-0001-Add-missing-parameters.patch
application/octet-stream
Filename: v1-0001-Add-missing-parameters.patch
Type: application/octet-stream
Part: 0
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch v1-0001
Subject: Add missing parameters
| File | + | − |
|---|---|---|
| doc/src/sgml/ref/alter_publication.sgml | 22 | 10 |
| doc/src/sgml/ref/create_publication.sgml | 40 | 8 |
From 5d394e65625393561cc8a9b99ef897d3b74157fd Mon Sep 17 00:00:00 2001
From: Peter Smith <peter.b.smith@fujitsu.com>
Date: Wed, 8 Apr 2026 13:33:21 +1000
Subject: [PATCH v1] Add missing parameters
---
doc/src/sgml/ref/alter_publication.sgml | 32 +++++++++++-----
doc/src/sgml/ref/create_publication.sgml | 48 ++++++++++++++++++++----
2 files changed, 62 insertions(+), 18 deletions(-)
diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml
index aa32bb169e9..9853ee5ff91 100644
--- a/doc/src/sgml/ref/alter_publication.sgml
+++ b/doc/src/sgml/ref/alter_publication.sgml
@@ -163,19 +163,21 @@ ALTER PUBLICATION <replaceable class="parameter">name</replaceable> RENAME TO <r
<listitem>
<para>
Name of an existing table. If <literal>ONLY</literal> is specified before the
- table name, only that table is affected. If <literal>ONLY</literal> is not
- specified, the table and all its descendant tables (if any) are
- affected. Optionally, <literal>*</literal> can be specified after the table
- name to explicitly indicate that descendant tables are included.
+ <replaceable class="parameter">table_name</replaceable>, only that table
+ is affected. If <literal>ONLY</literal> is not specified, the table and
+ all its descendant tables (if any) are affected. Optionally,
+ <literal>*</literal> can be specified after the
+ <replaceable class="parameter">table_name</replaceable> to explicitly
+ indicate that descendant tables are included.
</para>
<para>
- Optionally, a column list can be specified. See <xref
- linkend="sql-createpublication"/> for details. Note that a subscription
- having several publications in which the same table has been published
- with different column lists is not supported. See
- <xref linkend="logical-replication-col-list-combining"/> for details of
- potential problems when altering column lists.
+ Optionally, a <replaceable class="parameter">column_name</replaceable>
+ list can be specified. See <xref linkend="sql-createpublication"/> for
+ details. Note that a subscription having several publications in which
+ the same table has been published with different column lists is not
+ supported. See <xref linkend="logical-replication-col-list-combining"/>
+ for details of potential problems when altering column lists.
</para>
<para>
@@ -189,6 +191,16 @@ ALTER PUBLICATION <replaceable class="parameter">name</replaceable> RENAME TO <r
</listitem>
</varlistentry>
+ <varlistentry>
+ <term><replaceable class="parameter">column_name</replaceable></term>
+ <listitem>
+ <para>
+ Name of an existing column of table
+ <replaceable class="parameter">table_name</replaceable>
+ </para>
+ </listitem>
+ </varlistentry>
+
<varlistentry>
<term><replaceable class="parameter">schema_name</replaceable></term>
<listitem>
diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml
index 0ac576d3f10..d26d75c7962 100644
--- a/doc/src/sgml/ref/create_publication.sgml
+++ b/doc/src/sgml/ref/create_publication.sgml
@@ -79,15 +79,45 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
</listitem>
</varlistentry>
+ <varlistentry id="sql-createpublication-params-table_name">
+ <term><replaceable class="parameter">table_name</replaceable></term>
+ <listitem>
+ <para>
+ Name of an existing table.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="sql-createpublication-params-column_name">
+ <term><replaceable class="parameter">column_name</replaceable></term>
+ <listitem>
+ <para>
+ Name of an existing column of table
+ <replaceable class="parameter">table_name</replaceable>
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="sql-createpublication-params-schema_name">
+ <term><replaceable class="parameter">schmema_name</replaceable></term>
+ <listitem>
+ <para>
+ Name of an existing schema.
+ </para>
+ </listitem>
+ </varlistentry>
+
<varlistentry id="sql-createpublication-params-for-table">
<term><literal>FOR TABLE</literal></term>
<listitem>
<para>
Specifies a list of tables to add to the publication. If
- <literal>ONLY</literal> is specified before the table name, only
+ <literal>ONLY</literal> is specified before the
+ <replaceable class="parameter">table_name</replaceable>, only
that table is added to the publication. If <literal>ONLY</literal> is not
specified, the table and all its descendant tables (if any) are added.
- Optionally, <literal>*</literal> can be specified after the table name to
+ Optionally, <literal>*</literal> can be specified after the
+ <replaceable class="parameter">table_name</replaceable> to
explicitly indicate that descendant tables are included.
This does not apply to a partitioned table, however. The partitions of
a partitioned table are always implicitly considered part of the
@@ -104,7 +134,8 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
</para>
<para>
- When a column list is specified, only the named columns are replicated.
+ When a <replaceable class="parameter">column_name</replaceable> list is
+ specified, only the named columns are replicated.
The column list can contain stored generated columns as well. If the
column list is omitted, the publication will replicate all non-generated
columns (including any added in the future) by default. Stored generated
@@ -202,11 +233,12 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
</para>
<para>
For inherited tables, if <literal>ONLY</literal> is specified before the
- table name, only that table is excluded from the publication. If
- <literal>ONLY</literal> is not specified, the table and all its descendant
- tables (if any) are excluded. Optionally, <literal>*</literal> can be
- specified after the table name to explicitly indicate that descendant
- tables are excluded.
+ <replaceable class="parameter">table_name</replaceable>, only that table
+ is excluded from the publication. If <literal>ONLY</literal> is not
+ specified, the table and all its descendant tables (if any) are excluded.
+ Optionally, <literal>*</literal> can be specified after the
+ <replaceable class="parameter">table_name</replaceable> to explicitly
+ indicate that descendant tables are excluded.
</para>
<para>
For partitioned tables, only the root partitioned table may be specified
--
2.47.3