From: Alexander Lakhin <exclusion@gmail.com>
Subject: Some typos in documentation
To: "pgsql-docs@postgresql.org" <pgsql-docs@postgresql.org>
Message-ID: <9b5a3a85-899a-ae62-dbab-1e7943aa5ab1@gmail.com>
Date: Sun, 13 Jan 2019 00:17:07 +0300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.2.1
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="------------610F644C5485D8A04F256AAE"
Content-Language: ru-RU
Precedence: bulk

This is a multi-part message in MIME format.
--------------610F644C5485D8A04F256AAE
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Hello,
While cross-checking the unique words in doc/ I found a few typos.

REL9_6_STABLE
transcations
(Also there are two 'transcation's in src/bin/psql/po/tr.po, probably
these are typos too.)

REL_10_STABLE+
PQencryptPasswodConn

pg_current_logfiles -- there is only the "pg_current_logfile" function.

NOCONNECT -- this option was replaced with "connect = false" by commit
b807f5982.

LockFileCreateWrite -- Should be spelled as LockFileCreateWRITE (as in
pgstat.c) or LockFileCreateWRITE in pg.stat.s should use CamelCase in
whole. I don't find any dependencies so I would prefer the latter.

REL_11_STABLE+
pg_execute_server_programs -- I could find only the
pg_execute_server_program role in pg_authid.dat.

All the corresponding patches are attached.

Best regards,
Alexander


--------------610F644C5485D8A04F256AAE
Content-Type: text/x-patch;
 name="transcations.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="transcations.patch"

diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml
index da3a900dc1..5f3adc98c9 100644
--- a/doc/src/sgml/maintenance.sgml
+++ b/doc/src/sgml/maintenance.sgml
@@ -594,7 +594,7 @@ SELECT datname, age(datfrozenxid) FROM pg_database;
     scans every page in the table that is not already all-frozen, it should
     set <literal>age(relfrozenxid)</> to a value just a little more than the
     <varname>vacuum_freeze_min_age</> setting
-    that was used (more by the number of transcations started since the
+    that was used (more by the number of transactions started since the
     <command>VACUUM</> started).  If no <structfield>relfrozenxid</>-advancing
     <command>VACUUM</> is issued on the table until
     <varname>autovacuum_freeze_max_age</> is reached, an autovacuum will soon


--------------610F644C5485D8A04F256AAE
Content-Type: text/x-patch;
 name="PQencryptPasswodConn.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="PQencryptPasswodConn.patch"

diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml
index e8ec495d03..ad2e3a4466 100644
--- a/doc/src/sgml/libpq.sgml
+++ b/doc/src/sgml/libpq.sgml
@@ -6106,7 +6106,7 @@ char *PQencryptPasswordConn(PGconn *conn, const char *passwd, const char *user,
 char *PQencryptPassword(const char *passwd, const char *user);
 </synopsis>
       <function>PQencryptPassword</> is an older, deprecated version of
-      <function>PQencryptPasswodConn</>. The difference is that
+      <function>PQencryptPasswordConn</>. The difference is that
       <function>PQencryptPassword</> does not
       require a connection object, and <literal>md5</> is always used as the
       encryption algorithm.


--------------610F644C5485D8A04F256AAE
Content-Type: text/x-patch;
 name="pg_current_logfiles.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="pg_current_logfiles.patch"

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 0915be0d6d..8fd1288dca 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -16153,7 +16153,7 @@ SET search_path TO <replaceable>schema</> <optional>, <replaceable>schema</>, ..
     optional parameter. The return value is <literal>NULL</literal> when the
     log format requested is not a configured
     <xref linkend="guc-log-destination">.  The
-    <function>pg_current_logfiles</function> reflects the contents of the
+    <function>pg_current_logfile</function> reflects the contents of the
     <filename>current_logfiles</> file.
    </para>
 

--------------610F644C5485D8A04F256AAE
Content-Type: text/x-patch;
 name="NOCONNECT.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="NOCONNECT.patch"

diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml
index 4c63ebb7b0..c221d2a080 100644
--- a/doc/src/sgml/ref/pg_dump.sgml
+++ b/doc/src/sgml/ref/pg_dump.sgml
@@ -1246,7 +1246,7 @@ CREATE DATABASE foo WITH TEMPLATE template0;
   <para>
    When dumping logical replication subscriptions,
    <application>pg_dump</application> will generate <command>CREATE
-   SUBSCRIPTION</command> commands that use the <literal>NOCONNECT</literal>
+   SUBSCRIPTION</command> commands that use the <literal>connect = false</literal>
    option, so that restoring the subscription does not make remote connections
    for creating a replication slot or for initial table copy.  That way, the
    dump can be restored without requiring network access to the remote


--------------610F644C5485D8A04F256AAE
Content-Type: text/x-patch;
 name="LockFileCreateWRITE.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="LockFileCreateWRITE.patch"

diff --git a/src/backend/postmaster/pgstat.c b/src/backend/postmaster/pgstat.c
index 302c331c49..ac658dcb24 100644
--- a/src/backend/postmaster/pgstat.c
+++ b/src/backend/postmaster/pgstat.c
@@ -3745,7 +3745,7 @@ pgstat_get_wait_io(WaitEventIO w)
 			event_name = "LockFileCreateSync";
 			break;
 		case WAIT_EVENT_LOCK_FILE_CREATE_WRITE:
-			event_name = "LockFileCreateWRITE";
+			event_name = "LockFileCreateWrite";
 			break;
 		case WAIT_EVENT_LOCK_FILE_RECHECKDATADIR_READ:
 			event_name = "LockFileReCheckDataDirRead";


--------------610F644C5485D8A04F256AAE
Content-Type: text/x-patch;
 name="pg_execute_server_programs.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="pg_execute_server_programs.patch"

diff --git a/doc/src/sgml/file-fdw.sgml b/doc/src/sgml/file-fdw.sgml
index 955a13ab7d..d80142b4fd 100644
--- a/doc/src/sgml/file-fdw.sgml
+++ b/doc/src/sgml/file-fdw.sgml
@@ -188,7 +188,7 @@
  <para>
   Changing table-level options requires being a superuser or having the privileges
   of the default role <literal>pg_read_server_files</literal> (to use a filename) or
-  the default role <literal>pg_execute_server_programs</literal> (to use a program),
+  the default role <literal>pg_execute_server_program</literal> (to use a program),
   for security reasons: only certain users should be able to control which file is
   read or which program is run.  In principle regular users could be allowed to
   change the other options, but that's not supported at present.


--------------610F644C5485D8A04F256AAE--