Re: typos
Alvaro Herrera <alvherre@alvh.no-ip.org>
CCing Amit K, because I propose a few relatively minor changes to
logical rep docs.
On 2022-Apr-13, Justin Pryzby wrote:
> $ git grep -F ", the default)"
> doc/src/sgml/ref/create_publication.sgml: partition's row filter (if the parameter is false, the default) or the root
>
> Maybe what's needed is more like this.
>
> If the publication contains a partitioned table, and the publication parameter
> <literal>publish_via_partition_root</literal> is false (the default), then the
> row filter is taken from the partition; otherwise, the row filter is taken
> from the root partitioned table.
Yeah, more invasive rewording seems called for. I propose this:
For publications containing partitioned tables, the row filter for each
partition is taken from the published partitioned table if the
publication parameter <literal>publish_via_partition_root</literal> is true,
or from the partition itself if it is false (the default).
I think we should also mention that this parameter affects row filters,
in the <varlistentry> for the WITH clause. Currently it has
<term><literal>publish_via_partition_root</literal> (<type>boolean</type>)</term>
<listitem>
<para>
This parameter determines whether changes in a partitioned table (or
on its partitions) contained in the publication will be published
using the identity and schema of the partitioned table rather than
that of the individual partitions that are actually changed; the
latter is the default. Enabling this allows the changes to be
replicated into a non-partitioned table or a partitioned table
consisting of a different set of partitions.
</para>
I propose to add
<term><literal>publish_via_partition_root</literal> (<type>boolean</type>)</term>
<listitem>
<para>
This parameter determines whether changes in a partitioned table (or
on its partitions) contained in the publication will be published
using the identity and schema of the partitioned table rather than
that of the individual partitions that are actually changed; the
latter is the default. Enabling this allows the changes to be
replicated into a non-partitioned table or a partitioned table
consisting of a different set of partitions.
</para>
<para>
This parameter also affects how row filters are chosen for partitions;
see below for details.
</para>
More generally, I think we need to connect the WHERE keyword with "row
filters" more explicitly. Right now, the parameter reference says
If the optional <literal>WHERE</literal> clause is specified, rows for
which the <replaceable class="parameter">expression</replaceable>
evaluates to false or null will not be published. Note that parentheses
are required around the expression. It has no effect on
<literal>TRUNCATE</literal> commands.
I propose to make it "If the optional WHERE clause is specified, it
defines a <firstterm>row filter</firstterm> expression. Rows for which
the row filter expression evaluates to false ..."
> $ git grep 'zstd.*product' doc
> doc/src/sgml/config.sgml: <literal>zstd</literal> (if <productname>PostgreSQL</productname>
> $ git grep 'ZSTD.*product' doc
> doc/src/sgml/install-windows.sgml: <term><productname>ZSTD</productname></term>
> doc/src/sgml/install-windows.sgml: Required for supporting <productname>ZSTD</productname> compression
> doc/src/sgml/installation.sgml: You need <productname>ZSTD</productname>, if you want to support
> doc/src/sgml/installation.sgml: Build with <productname>ZSTD</productname> compression support.
I don't see any official sources calling it all-uppercase ZSTD. In a
quick non-scientific survey, most seem to use Zstd or zstd. The
non-abbreviated official name is Zstandard, but it's hard to find any
places using that spelling, and I don't think our docs are a place to
educate people on what the official name or pronunciation is.
I propose we standardize on <productname>Zstd</productname> everywhere.
Users can look it up if they're really interested.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
Commits
-
Fix typos and grammar in code and test comments
- 45edde037efc 15.0 landed
-
Standardize references to Zstandard as <productname>
- 586955dddecc 15.0 landed
-
CREATE PUBLICATION ref: Minor tweaks to row filters
- bb85eec6fe91 15.0 landed
-
Add missing spaces after single-line comments
- a00fd066b1b6 15.0 landed
-
Docs: fix some spelling mistakes and also do some wordsmithing
- ac8be0cb9578 15.0 landed
-
Remove extraneous blank lines before block-closing braces
- 24d2b2680a8d 15.0 landed
-
Docs: wording improvement for compute_query_id = regress
- ea669b808838 14.3 landed
- a59746d31126 15.0 landed
-
Docs: tidy up various usages of the productname tag
- fdc18ea23b39 15.0 landed
-
Docs: adjust wording about basebackup_to_shell's required_role GUC
- d27323db7c45 15.0 landed
-
Docs: adjust pg_upgrade syntax to mark -B as optional
- 9144fa27dd7f 13.7 landed
- e286be5d0531 14.3 landed
- 0f0b76b67a06 15.0 landed
-
Docs: avoid confusing use of the word "synchronized"
- af3e3a9b4f52 12.11 landed
- e22fd217ec5b 13.7 landed
- 3a95dfe4025f 14.3 landed
- 55ff3563d8fa 15.0 landed
-
Fix grammatical errors and typos in logical replication docs.
- aeebb8bf233e 15.0 landed
-
Docs: Mention that relpersistence is for sequences now too
- e0064f0ff6df 15.0 landed
-
Fix various typos and spelling mistakes in code comments
- b0e5f02ddc83 15.0 landed
-
Docs: Fix various mistakes and typos
- bba3c35b29d0 15.0 landed