Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dkWrN-0006nA-62 for pgsql-docs@arkaria.postgresql.org; Wed, 23 Aug 2017 14:42:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dkWrM-0005jF-5u for pgsql-docs@arkaria.postgresql.org; Wed, 23 Aug 2017 14:42:20 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dkWrK-0005is-Sh for pgsql-docs@postgresql.org; Wed, 23 Aug 2017 14:42:19 +0000 Received: from mail-lf0-x22b.google.com ([2a00:1450:4010:c07::22b]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dkWrG-0001xn-Co for pgsql-docs@postgresql.org; Wed, 23 Aug 2017 14:42:17 +0000 Received: by mail-lf0-x22b.google.com with SMTP id g77so1534266lfg.1 for ; Wed, 23 Aug 2017 07:42:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-language; bh=QZrnycJTqroGKLtGD7Udh2SD/rYpxzjcl5MrRg/pFBw=; b=fueE/b3eLE4X9JOMqo606zjtdhI5E7ZTZF04xJjYzY5FQwVHK6BCWG0BusYXrNlZ6L nGYGml/rsMqV/a6QxhxOuXapvaQOZPUtjpcKoxwufrH5Hx2x0sYcKhrLC04BTiLm2Rgp rp/PtB6ustJd91QNozYlqhtqjrEo7Yn2tFXdOgiouPnWLRvwwUi9R6k3k4XfrqynfSgj H/1rxH9x7X6XYWI/3qWarFkkW6xdUl/bg7IzrBuO3wyvX7DbPo1LGz2eikxlbrvypRsS oREdh/BIbnFkzeTrvJQXo1/zos4xrY+XOv1DfKxDQrHI3gxmKDL+QtzBQcHSlvDnoMrI WK2g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-language; bh=QZrnycJTqroGKLtGD7Udh2SD/rYpxzjcl5MrRg/pFBw=; b=S6toQjpaNUs32ZR1mWI71n2+qer64VqVpkHvDSEw9PIycV8SCIYZHoBYEf+N3mXH1/ 3TBDwZInF3B7sNwmmwRasaED01zAPFYKt7B1ri+2XWxMkzAE4HrGn3q31lR/7jq3rCxC WLQzRq6OykcTRGlvoqerUdclNABWDYh0kAaOhDGgRscfK1+1vK+yYV+djGwnI7fisFk6 5c2bIQobwqjWsaJ/z3F6jncKNmcRmflGJUQqlCna6B4WPHRBMqJTcPql8iGF1DGL31d3 vB5q1RjRYDgorJp0coCGu+9vVom6kZFgFufIH6N0+aiu9xT8R7q2HcKRRi7vU45FyBmh F2ow== X-Gm-Message-State: AHYfb5g8GmwY0U2/buhLzZuhsKVO1x29dUmlCnzeBjK+FwuMvgiJ3PTR dcMMUimV/q6fVHeb X-Received: by 10.25.161.209 with SMTP id k200mr1168949lfe.132.1503499331994; Wed, 23 Aug 2017 07:42:11 -0700 (PDT) Received: from [1.0.0.7] ([178.155.4.124]) by smtp.gmail.com with ESMTPSA id p89sm285245lje.93.2017.08.23.07.42.10 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 23 Aug 2017 07:42:10 -0700 (PDT) To: "pgsql-docs@postgresql.org" From: Alexander Lakhin Subject: Errors in documentation Message-ID: <7b769321-bbb1-49aa-2169-db6b82a71960@gmail.com> Date: Wed, 23 Aug 2017 17:42:09 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.2.1 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------994A95B5A9C9FD7047ADC9A7" Content-Language: en-US List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org This is a multi-part message in MIME format. --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hello, Please consider committing attached patches to the documentation. A pair of the patches I sent before (see https://www.postgresql.org/message-id/374e84e6-f89b-4d0a-652c-cb2449f0bfc4%40gmail.com), but they weren't committed. If some of these patches are not valid or raise any questions, please let me know. Best -- Alexander Lakhin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="alter_table-tags-comma.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="alter_table-tags-comma.patch" diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 6960032..dae6307 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -620,8 +620,8 @@ ALTER TABLE [ IF EXISTS ] name SHARE UPDATE EXCLUSIVE lock will be taken for fillfactor and autovacuum storage parameters, as well as the following planner related parameters: - effective_io_concurrency, parallel_workers, seq_page_cost - random_page_cost, n_distinct and n_distinct_inherited. + effective_io_concurrency, parallel_workers, seq_page_cost, + random_page_cost, n_distinct and n_distinct_inherited. --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="are-are.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="are-are.patch" diff --git a/doc/src/sgml/ref/alter_sequence.sgml b/doc/src/sgml/ref/alter_sequence.sgml index 3a04d07..190c8d6 100644 --- a/doc/src/sgml/ref/alter_sequence.sgml +++ b/doc/src/sgml/ref/alter_sequence.sgml @@ -89,7 +89,7 @@ ALTER SEQUENCE [ IF EXISTS ] name S The optional clause AS data_type changes the data type of the sequence. Valid types are - are smallint, integer, + smallint, integer, and bigint. diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml index f1448e7..2af8c8d 100644 --- a/doc/src/sgml/ref/create_sequence.sgml +++ b/doc/src/sgml/ref/create_sequence.sgml @@ -119,7 +119,7 @@ SELECT * FROM name; The optional clause AS data_type specifies the data type of the sequence. Valid types are - are smallint, integer, + smallint, integer, and bigint. bigint is the default. The data type determines the default minimum and maximum values of the sequence. --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="catalogs-Name_name.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="catalogs-Name_name.patch" diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index ef7054c..3126990 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -5385,7 +5385,7 @@ SCRAM-SHA-256$<iteration count>:<salt>< pubname - Name + name Name of the publication --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="copy-input_insert.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="copy-input_insert.patch" diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 8de1150..732efe6 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -482,7 +482,7 @@ COPY count For identity columns, the COPY FROM command will always write the column values provided in the input data, like - the INPUT option OVERRIDING SYSTEM + the INSERT option OVERRIDING SYSTEM VALUE. --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="create_table-fix-a-sentence.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="create_table-fix-a-sentence.patch" diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index e9c2c49..a6ca590 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -473,8 +473,8 @@ FROM ( { numeric_literal | partitioned table. The parenthesized list of columns or expressions forms the partition key for the table. When using range partitioning, the partition key can - include multiple columns or expressions (up to 32, but this limit can - altered when building PostgreSQL.), but for + include multiple columns or expressions (up to 32, but this limit can be + altered when building PostgreSQL), but for list partitioning, the partition key must consist of a single column or expression. If no B-tree operator class is specified when creating a partitioned table, the default B-tree operator class for the datatype will --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="event-trigger-table.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="event-trigger-table.patch" diff --git a/doc/src/sgml/event-trigger.sgml b/doc/src/sgml/event-trigger.sgml index 3ed14f0..c7b880d 100644 --- a/doc/src/sgml/event-trigger.sgml +++ b/doc/src/sgml/event-trigger.sgml @@ -565,6 +565,7 @@ X - - + CREATE USER MAPPING --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="failback.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="failback.patch" diff --git a/doc/src/sgml/release-9.5.sgml b/doc/src/sgml/release-9.5.sgml index 14a9b9d..7fd4dee 100644 --- a/doc/src/sgml/release-9.5.sgml +++ b/doc/src/sgml/release-9.5.sgml @@ -6918,7 +6918,7 @@ Add GUC and storage parameter to set the maximum size of GIN pending list. --> Add pg_rewind, - which allows re-synchronizing a master server after failback + which allows re-synchronizing a master server after fallback (Heikki Linnakangas) --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="indexam-structname.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="indexam-structname.patch" diff --git a/doc/src/sgml/indexam.sgml b/doc/src/sgml/indexam.sgml index ac51258..aa3d371 100644 --- a/doc/src/sgml/indexam.sgml +++ b/doc/src/sgml/indexam.sgml @@ -559,7 +559,7 @@ amgettuple (IndexScanDesc scan, a HeapTuple pointer stored at scan->xs_hitup, with tuple descriptor scan->xs_hitupdesc. (The latter format should be used when reconstructing data that might possibly not fit - into an IndexTuple.) In either case, + into an IndexTuple.) In either case, management of the data referenced by the pointer is the access method's responsibility. The data must remain good at least until the next amgettuple, amrescan, or amendscan --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="logicaldecoding-pg_stat_replication-link.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="logicaldecoding-pg_stat_replication-link.patch" diff --git a/doc/src/sgml/logicaldecoding.sgml b/doc/src/sgml/logicaldecoding.sgml index 8dcfc6c..a979913 100644 --- a/doc/src/sgml/logicaldecoding.sgml +++ b/doc/src/sgml/logicaldecoding.sgml @@ -345,7 +345,7 @@ $ pg_recvlogical -d postgres --slot test --drop-slot The pg_replication_slots view and the - pg_stat_replication + pg_stat_replication view provide information about the current state of replication slots and streaming replication connections respectively. These views apply to both physical and logical replication. --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="perform-space.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="perform-space.patch" diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml index 924f609..1346328 100644 --- a/doc/src/sgml/perform.sgml +++ b/doc/src/sgml/perform.sgml @@ -1840,7 +1840,7 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse; Increase and ; this reduces the frequency + linkend="guc-checkpoint-timeout">; this reduces the frequency of checkpoints, but increases the storage requirements of /pg_wal. --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="readded.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="readded.patch" diff --git a/doc/src/sgml/release-7.4.sgml b/doc/src/sgml/release-7.4.sgml index 1ddab66..88578dc 100644 --- a/doc/src/sgml/release-7.4.sgml +++ b/doc/src/sgml/release-7.4.sgml @@ -4254,7 +4254,7 @@ DROP SCHEMA information_schema CASCADE; The Python language no longer supports a restricted execution environment, so the trusted version of PL/Python was removed. If this situation changes, a version of PL/Python that can be used - by non-superusers will be readded. + by non-superusers will be read. diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index b26358c..c2eaa11 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -9595,7 +9595,7 @@ dumpExtension(Archive *fout, ExtensionInfo *extinfo) /* * We unconditionally create the extension, so we must drop it if it * exists. This could happen if the user deleted 'plpgsql' and then - * readded it, causing its oid to be greater than g_last_builtin_oid. + * read it, causing its oid to be greater than g_last_builtin_oid. * The g_last_builtin_oid test was kept to avoid repeatedly dropping * and recreating extensions like 'plpgsql'. */ --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="release-10-misplaced-comma.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="release-10-misplaced-comma.patch" diff --git a/doc/src/sgml/release-10.sgml b/doc/src/sgml/release-10.sgml index 269f1aa..bb85071 100644 --- a/doc/src/sgml/release-10.sgml +++ b/doc/src/sgml/release-10.sgml @@ -2882,7 +2882,7 @@ - Previously Jade, DSSSL, and + Previously Jade, DSSSL, and JadeTex were used. --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="release-10-one-man.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="release-10-one-man.patch" diff --git a/doc/src/sgml/release-10.sgml b/doc/src/sgml/release-10.sgml index 269f1aa..640f877 100644 --- a/doc/src/sgml/release-10.sgml +++ b/doc/src/sgml/release-10.sgml @@ -2868,7 +2868,7 @@ --> Overhaul documentation build - process (Alexander Lakhin, Alexander Law) + process (Alexander Lakhin) --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/x-patch; name="updateable.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="updateable.patch" diff --git a/doc/src/sgml/release-7.4.sgml b/doc/src/sgml/release-7.4.sgml index bc4f4e1..1ddab66 100644 --- a/doc/src/sgml/release-7.4.sgml +++ b/doc/src/sgml/release-7.4.sgml @@ -4506,7 +4506,7 @@ DROP SCHEMA information_schema CASCADE; JDBC Changes - Allow setNull on updateable result sets + Allow setNull on updatable result sets Allow executeBatch on a prepared statement (Barry) Support SSL connections (Barry) Handle schema names in result sets (Paul Sorenson) diff --git a/doc/src/sgml/release-old.sgml b/doc/src/sgml/release-old.sgml index d4de6b1..625874c 100644 --- a/doc/src/sgml/release-old.sgml +++ b/doc/src/sgml/release-old.sgml @@ -1228,7 +1228,7 @@ operations on bytea columns (Joe) plpython used wrong value of atttypmod (Brad McLean) Fix improper quoting of boolean values in Python interface (D'Arcy) Added addDataType() method to PGConnection interface for JDBC -Fixed various problems with updateable ResultSets for JDBC (Shawn Green) +Fixed various problems with updatable ResultSets for JDBC (Shawn Green) Fixed various problems with DatabaseMetaData for JDBC (Kris Jurka, Peter Royal) Fixed problem with parsing table ACLs in JDBC Better error message for character set conversion problems in JDBC @@ -1874,7 +1874,7 @@ operations on bytea columns (Joe) Add JDBC 3 support (Barry) Allows JDBC to set loglevel by adding ?loglevel=X to the connection URL (Barry) Add Driver.info() message that prints out the version number (Barry) -Add updateable result sets (Raghu Nidagal, Dave) +Add updatable result sets (Raghu Nidagal, Dave) Add support for callable statements (Paul Bethe) Add query cancel capability Add refresh row (Dave) --------------994A95B5A9C9FD7047ADC9A7 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --------------994A95B5A9C9FD7047ADC9A7--