From fcc434047d09428d48341c6faeb29e9bd9d95a4e Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Tue, 25 Jan 2022 10:49:44 +0900 Subject: [PATCH] doc: Fix some grammar This is an extraction of the user-visible changes done in 410aa24, including all the relevant documentation parts. Author: Justin Pryzby Discussion: https://postgr.es/m/20220124030001.GQ23027@telsasoft.com Backpatch-through: 10 --- doc/src/sgml/config.sgml | 4 ++-- doc/src/sgml/ddl.sgml | 4 ++-- doc/src/sgml/perform.sgml | 2 +- doc/src/sgml/protocol.sgml | 2 +- doc/src/sgml/ref/pg_receivewal.sgml | 7 +++---- doc/src/sgml/ref/select_into.sgml | 2 +- 6 files changed, 10 insertions(+), 11 deletions(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index d886012fe52..434ad74768f 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -7577,8 +7577,8 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; This parameter specifies the default table access method to use when creating tables or materialized views if the CREATE command does not explicitly specify an access method, or when - SELECT ... INTO is used, which does not allow to - specify a table access method. The default is heap. + SELECT ... INTO is used, which does not allow + specifying a table access method. The default is heap. diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 8515c0e63a4..e36a9b1e2e3 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -3978,7 +3978,7 @@ ALTER TABLE measurement ATTACH PARTITION measurement_y2008m02 holding an ACCESS EXCLUSIVE lock on that partition. It is recommended to drop the now-redundant CHECK constraint after the ATTACH PARTITION is complete. If - the table being attached is itself a partitioned table then each of its + the table being attached is itself a partitioned table, then each of its sub-partitions will be recursively locked and scanned until either a suitable CHECK constraint is encountered or the leaf partitions are reached. @@ -3993,7 +3993,7 @@ ALTER TABLE measurement ATTACH PARTITION measurement_y2008m02 the partition being attached. This operation will be performed whilst holding an ACCESS EXCLUSIVE lock on the DEFAULT partition. If the DEFAULT partition - is itself a partitioned table then each of its partitions will be + is itself a partitioned table, then each of its partitions will be recursively checked in the same way as the table being attached, as mentioned above. diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml index 8ee340f67d7..5f4de2824e4 100644 --- a/doc/src/sgml/perform.sgml +++ b/doc/src/sgml/perform.sgml @@ -1295,7 +1295,7 @@ nd | {"1, 2": 33178, "1, 5": 33178, "2, 5": 27435, "1, 2, 5": 33178} Multivariate MCV Lists - Another type of statistics stored for each column are most-common value + Another type of statistic stored for each column are most-common value lists. This allows very accurate estimates for individual columns, but may result in significant misestimates for queries with conditions on multiple columns. diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml index 3783ebea477..a8220531102 100644 --- a/doc/src/sgml/protocol.sgml +++ b/doc/src/sgml/protocol.sgml @@ -2070,7 +2070,7 @@ The commands accepted in replication mode are: streaming starts on timeline tli; otherwise, the server's current timeline is selected. The server can reply with an error, for example if the requested section of WAL has already - been recycled. On success, server responds with a CopyBothResponse + been recycled. On success, the server responds with a CopyBothResponse message, and then starts to stream WAL to the frontend. diff --git a/doc/src/sgml/ref/pg_receivewal.sgml b/doc/src/sgml/ref/pg_receivewal.sgml index 80502c44c01..f0c76fa69dc 100644 --- a/doc/src/sgml/ref/pg_receivewal.sgml +++ b/doc/src/sgml/ref/pg_receivewal.sgml @@ -83,9 +83,8 @@ PostgreSQL documentation First, scan the directory where the WAL segment files are written and - find the newest completed segment file, using as starting point the - beginning of the next WAL segment file. This is calculated independently - on the compression method used to compress each segment. + find the newest completed segment file, using as the starting point the + beginning of the next WAL segment file. @@ -93,7 +92,7 @@ PostgreSQL documentation If a starting point cannot be calculated with the previous method, the latest WAL flush location is used as reported by the server from - a IDENTIFY_SYSTEM command. + an IDENTIFY_SYSTEM command. diff --git a/doc/src/sgml/ref/select_into.sgml b/doc/src/sgml/ref/select_into.sgml index e82e416d607..afdfae6c235 100644 --- a/doc/src/sgml/ref/select_into.sgml +++ b/doc/src/sgml/ref/select_into.sgml @@ -107,7 +107,7 @@ SELECT [ ALL | DISTINCT [ ON ( expression In contrast to CREATE TABLE AS, SELECT - INTO does not allow to specify properties like a table's access + INTO does not allow specifying properties like a table's access method with or the table's tablespace with . Use if necessary. Therefore, the default table -- 2.39.5