Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iJvnh-0003Rt-ER for pgsql-docs@arkaria.postgresql.org; Mon, 14 Oct 2019 08:33:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iJvkV-0002Wr-5d for pgsql-docs@arkaria.postgresql.org; Mon, 14 Oct 2019 08:30:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iJvjS-0001us-B5 for pgsql-docs@lists.postgresql.org; Mon, 14 Oct 2019 08:29:34 +0000 Received: from mail-lj1-x236.google.com ([2a00:1450:4864:20::236]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iJvjL-0002hx-Ln for pgsql-docs@postgresql.org; Mon, 14 Oct 2019 08:29:33 +0000 Received: by mail-lj1-x236.google.com with SMTP id y3so15730183ljj.6 for ; Mon, 14 Oct 2019 01:29:27 -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=Es8TWZqNU86ULA83hF3KmguSudPDcgcyH/UBOlJuCUk=; b=Y4FLxQD0wcJ9+NTEqFbRJBzxaDStUW5Btptc09F/R8mAnhefc479wR5bN3GD1BAhvR satUUOzNkub1YzjbNha929B/7Vfomhd2nZKenx4XmenytwfOoiEDZkQWgPOU7IRwB2S8 84Z2j1YBG0HevsF6qsmMWzuYsUq3UsvipnomWH3A1HoFYu5RgKz692fPJe46YAIo+5FV 8kCjkhsr3wtYBTfQWQE2kLefxHv5VibVbWNBgOpOWvsSDIjUQjg+nYf8H+mzoC8XiP2h 2fyc4vmdD5SX03TZ5RBH2Uyahit73rGIB3qvuJqo8AvLVsI38j/Q48Iz+DWXIfcAxnD+ c3wA== 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=Es8TWZqNU86ULA83hF3KmguSudPDcgcyH/UBOlJuCUk=; b=LnC9H3JfGs/JpiMuy/FeO8UdbShRLO5TO/XnOFsJc/q60HmFXiuCnSCT5gCVeDMaWK enl0L5aQ+lLEVDj5gbnpS5kr/y2Vv6vDTqVG5E+/SPBAnrd73L2bTR6jKMQDlsaPom0G apoQCzdxQc8A/XRKVX9rU6uBw+8VV+24Sb8SY11L3toD8rkPwOHtlkgWeQHgPhOtHs8r q6AT8D5pbkBzueN04KFSqnKaO5t2voHTWYe/2djiISaJ9wx1MvH9A7cD7d2tLCsQFzsm fZ2OJsxmJNaHFW7Jc5eCOBNhfMD9GogyNPxFzUuspbw9q6eY/uVfq3fz7l0us5iU8dYw pm7A== X-Gm-Message-State: APjAAAVXWtVedJIAVhBHFgSbMxbI80f41njPSH49+YLUTjP718R4+9EE SgcU46t841Q7T6rfIJfCoCp7hAwz X-Google-Smtp-Source: APXvYqyIYY9R9sJHmEBgDpX0N6yVB0ZeKrZfHyUyI2cY0F+ZVnuZSyaIxn9fyGTLWgn85AClDhXuGw== X-Received: by 2002:a2e:8602:: with SMTP id a2mr18304853lji.20.1571041764492; Mon, 14 Oct 2019 01:29:24 -0700 (PDT) Received: from [1.0.0.7] ([178.155.4.8]) by smtp.gmail.com with ESMTPSA id k21sm3952169lfm.68.2019.10.14.01.29.23 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 14 Oct 2019 01:29:23 -0700 (PDT) To: "pgsql-docs@postgresql.org" From: Alexander Lakhin Subject: Miscellaneous minor fixes Message-ID: Date: Mon, 14 Oct 2019 11:29:22 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.7.2 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------F5C82585F251EC34E9E91D63" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------F5C82585F251EC34E9E91D63 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Hello, Please consider fixing minor inconsistencies and typos in doc/. (fix-contributor-name.patch is for REL_12_STABLE only) Best regards, Alexander --------------F5C82585F251EC34E9E91D63 Content-Type: text/x-patch; name="copy-consistency.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="copy-consistency.patch" diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 5e2992ddac..3e6f9cd532 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -1015,22 +1015,22 @@ COPY table_name [ ( filename' | STDIN } [ [ WITH ] [ BINARY ] - [ DELIMITER [ AS ] 'delimiter' ] - [ NULL [ AS ] 'null string' ] + [ DELIMITER [ AS ] 'delimiter_character' ] + [ NULL [ AS ] 'null_string' ] [ CSV [ HEADER ] - [ QUOTE [ AS ] 'quote' ] - [ ESCAPE [ AS ] 'escape' ] + [ QUOTE [ AS ] 'quote_character' ] + [ ESCAPE [ AS ] 'escape_character' ] [ FORCE NOT NULL column_name [, ...] ] ] ] COPY { table_name [ ( column_name [, ...] ) ] | ( query ) } TO { 'filename' | STDOUT } [ [ WITH ] [ BINARY ] - [ DELIMITER [ AS ] 'delimiter' ] - [ NULL [ AS ] 'null string' ] + [ DELIMITER [ AS ] 'delimiter_character' ] + [ NULL [ AS ] 'null_string' ] [ CSV [ HEADER ] - [ QUOTE [ AS ] 'quote' ] - [ ESCAPE [ AS ] 'escape' ] + [ QUOTE [ AS ] 'quote_character' ] + [ ESCAPE [ AS ] 'escape_character' ] [ FORCE QUOTE { column_name [, ...] | * } ] ] ] @@ -1046,13 +1046,13 @@ COPY { table_name [ ( COPY [ BINARY ] table_name FROM { 'filename' | STDIN } - [ [USING] DELIMITERS 'delimiter' ] - [ WITH NULL AS 'null string' ] + [ [USING] DELIMITERS 'delimiter_character' ] + [ WITH NULL AS 'null_string' ] COPY [ BINARY ] table_name TO { 'filename' | STDOUT } - [ [USING] DELIMITERS 'delimiter' ] - [ WITH NULL AS 'null string' ] + [ [USING] DELIMITERS 'delimiter_character' ] + [ WITH NULL AS 'null_string' ] --------------F5C82585F251EC34E9E91D63 Content-Type: text/x-patch; name="extend-consistency.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="extend-consistency.patch" diff --git a/doc/src/sgml/extend.sgml b/doc/src/sgml/extend.sgml index 8dc2b893f7..a3046f22d0 100644 --- a/doc/src/sgml/extend.sgml +++ b/doc/src/sgml/extend.sgml @@ -856,7 +856,7 @@ SELECT pg_catalog.pg_extension_config_dump('my_config', 'WHERE NOT standard_entr dynamically from one version to the next, you should provide update scripts that make the necessary changes to go from one version to the next. Update scripts have names following the pattern - extension--oldversion--newversion.sql + extension--old_version--target_version.sql (for example, foo--1.0--1.1.sql contains the commands to modify version 1.0 of extension foo into version 1.1). --------------F5C82585F251EC34E9E91D63 Content-Type: text/x-patch; name="fix-contributor-name.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="fix-contributor-name.patch" diff --git a/doc/src/sgml/release-12.sgml b/doc/src/sgml/release-12.sgml index 04f4effa8a..126d6144a4 100644 --- a/doc/src/sgml/release-12.sgml +++ b/doc/src/sgml/release-12.sgml @@ -3917,7 +3917,7 @@ Author: Michael Paquier Yuming Wang YunQiang Su Yuri Kurenkov - Yusuke Egashita + Yusuke Egashira Yuzuko Hosoya Zhou Digoal --------------F5C82585F251EC34E9E91D63 Content-Type: text/x-patch; name="prepare-consistency.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="prepare-consistency.patch" diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml index 9f786cd3ad..4e5e96a401 100644 --- a/doc/src/sgml/ref/prepare.sgml +++ b/doc/src/sgml/ref/prepare.sgml @@ -165,7 +165,7 @@ PREPARE name [ ( PostgreSQL is using for a prepared statement, use , for example -EXPLAIN EXECUTE stmt_name(parameter_values); +EXPLAIN EXECUTE name(parameter_values); If a generic plan is in use, it will contain parameter symbols $n, while a custom plan --------------F5C82585F251EC34E9E91D63 Content-Type: text/x-patch; name="role-inherits.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="role-inherits.patch" diff --git a/doc/src/sgml/ref/set_role.sgml b/doc/src/sgml/ref/set_role.sgml index 9ab0d6af04..a4842f363c 100644 --- a/doc/src/sgml/ref/set_role.sgml +++ b/doc/src/sgml/ref/set_role.sgml @@ -64,7 +64,7 @@ RESET ROLE Using this command, it is possible to either add privileges or restrict - one's privileges. If the session user role has the INHERITS + one's privileges. If the session user role has the INHERIT attribute, then it automatically has all the privileges of every role that it could SET ROLE to; in this case SET ROLE effectively drops all the privileges assigned directly to the session user --------------F5C82585F251EC34E9E91D63--