Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jYsCm-0005Gx-7t for pgsql-docs@arkaria.postgresql.org; Wed, 13 May 2020 14:17:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jYsCl-000613-62 for pgsql-docs@arkaria.postgresql.org; Wed, 13 May 2020 14:17:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jYsCk-00060w-QD for pgsql-docs@lists.postgresql.org; Wed, 13 May 2020 14:17:51 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jYsCh-0004CN-HK for pgsql-docs@postgresql.org; Wed, 13 May 2020 14:17:49 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 1816D21C66F8; Wed, 13 May 2020 17:17:44 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru X-Spam-Flag: NO X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=x tagged_above=-99 required=4 WHITELISTED tests=[] autolearn=unavailable Received: from mail.postgrespro.ru (unknown [93.174.131.138]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id DA81021C66C7; Wed, 13 May 2020 17:17:43 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1589379463; bh=ghGjc4oaKbxS9TGStB4DlEfMKa5IiA8+7n0RDysh4YM=; h=Date:From:To:Cc:Subject:In-Reply-To:References; b=NdMAuUdkhDU+nxZbWxaz+ux/vfLh8P7ApD2iu85UFNr0PWqndXwOBnsv9oMxoaUah gpN3sz5noJpV9rTBaeyYaxC6DVfoJVnDpKrJoQzxfWHTIIzCsMdJDYFm0m92PUTZEe hUXe8nCemLMcgoZoueh2gri0i/XIm7gWqobZDHsk= MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_35fd66266b707da3f9ab4c9e65b7f8d4" Content-Transfer-Encoding: 8bit Date: Wed, 13 May 2020 17:17:43 +0300 From: Marina Polyakova To: daniel@yesql.se Cc: a.lakhin@postgrespro.ru, pgsql-docs@postgresql.org Subject: Re: Missing comma? In-Reply-To: <5B3957FE-D31E-4838-B35C-C2F0EEC3E557@yesql.se> References: <5B3957FE-D31E-4838-B35C-C2F0EEC3E557@yesql.se> User-Agent: Roundcube Webmail/1.4.0 Message-ID: <6fa8ba75057b16f88010c2b945f720c0@postgrespro.ru> X-Sender: m.polyakova@postgrespro.ru Organization: Postgres Professional List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=_35fd66266b707da3f9ab4c9e65b7f8d4 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=UTF-8; format=flowed Thanks! P.S. Looking at the final sentence: "Columns used to form “replica identity” for rows: d = default (primary key, if any), n = nothing, f = all columns, i = index with indisreplident set, or default" in my opinion it's a little unclear what "or default" means at the end, because the comma is used to separate enumeration elements ("d = default <...>, n = nothing, f = all columns, i = index <...>") and inside the element description ("i = index with indisreplident set, or default"). Therefore here is an additional patch from me to clarify this place, thanks to Alexander Lakhin for help. On 2020-05-13 16:23, Daniel Gustafsson wrote: >> On 13 May 2020, at 12:20, Marina Polyakova >> wrote: > >> https://www.postgresql.org/docs/current/catalog-pg-class.html says >> "Columns used to form “replica identity” for rows: d = default >> (primary key, if any), n = nothing, f = all columns i = index with >> indisreplident set, or default". Am I wrong, or is there a missing >> comma (or other punctuation mark) before "i = index"?.. > > I agree with this, there should be a comma between "f = all columns" > and "i = > index with.." per the below: > > diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml > index ce33df9e58..cbd76e1bf5 100644 > --- a/doc/src/sgml/catalogs.sgml > +++ b/doc/src/sgml/catalogs.sgml > @@ -1935,7 +1935,7 @@ SCRAM-SHA-256$<iteration > count>:&l > Columns used to form replica identity for rows: > d = default (primary key, if any), > n = nothing, > - f = all columns > + f = all columns, > i = index with > indisreplident set, or default > > > > cheers ./daniel -- Marina Polyakova Postgres Professional: http://www.postgrespro.com The Russian Postgres Company --=_35fd66266b707da3f9ab4c9e65b7f8d4 Content-Transfer-Encoding: base64 Content-Type: text/x-diff; name=diff_relreplident_index_desc.patch Content-Disposition: attachment; filename=diff_relreplident_index_desc.patch; size=708 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sIGIvZG9jL3NyYy9zZ21sL2Nh dGFsb2dzLnNnbWwKaW5kZXggMDJkZGViYWU5OWQ5ODExMGE4ZGQyOTBkZDRjYjBjOTgwYWRmNzk4 NC4uMDM0YTA4ZjgwZWE0MjY5ZjEzMWU3ZTEzODNiYTQ4MmZkNzZkOTM0NCAxMDA2NDQKLS0tIGEv ZG9jL3NyYy9zZ21sL2NhdGFsb2dzLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL2NhdGFsb2dzLnNn bWwKQEAgLTE5MzYsNyArMTkzNiw3IEBAIFNDUkFNLVNIQS0yNTYkPHJlcGxhY2VhYmxlPiZsdDtp dGVyYXRpb24gY291bnQmZ3Q7PC9yZXBsYWNlYWJsZT46PHJlcGxhY2VhYmxlPiZsCiAgICAgICAg PGxpdGVyYWw+ZDwvbGl0ZXJhbD4gPSBkZWZhdWx0IChwcmltYXJ5IGtleSwgaWYgYW55KSwKICAg ICAgICA8bGl0ZXJhbD5uPC9saXRlcmFsPiA9IG5vdGhpbmcsCiAgICAgICAgPGxpdGVyYWw+Zjwv bGl0ZXJhbD4gPSBhbGwgY29sdW1ucywKLSAgICAgICA8bGl0ZXJhbD5pPC9saXRlcmFsPiA9IGlu ZGV4IHdpdGggPHN0cnVjdGZpZWxkPmluZGlzcmVwbGlkZW50PC9zdHJ1Y3RmaWVsZD4gc2V0LCBv ciBkZWZhdWx0CisgICAgICAgPGxpdGVyYWw+aTwvbGl0ZXJhbD4gPSBpbmRleCB3aXRoIDxzdHJ1 Y3RmaWVsZD5pbmRpc3JlcGxpZGVudDwvc3RydWN0ZmllbGQ+IHNldCAoaWYgYW55KQogICAgICAg PC9lbnRyeT4KICAgICAgPC9yb3c+CiAK --=_35fd66266b707da3f9ab4c9e65b7f8d4--