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 1jZ1Pn-0005io-GO for pgsql-docs@arkaria.postgresql.org; Thu, 14 May 2020 00:07:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jZ1Pm-00011b-AC for pgsql-docs@arkaria.postgresql.org; Thu, 14 May 2020 00:07:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jZ1Pk-00011T-EY for pgsql-docs@lists.postgresql.org; Thu, 14 May 2020 00:07:54 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jZ1Pf-0007pv-CS for pgsql-docs@postgresql.org; Thu, 14 May 2020 00:07:51 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 350D34C8; Wed, 13 May 2020 20:07:43 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Wed, 13 May 2020 20:07:43 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=AMypuCTgdEKMImPFFfLYRi2B+5N eajLyj1BU0N3gpDA=; b=HeVtUWCFIIgA4v0JzHipdfTLdsz62rOAOX1/nxYJjYp MYLj8GK2scBdxXDj2Bfbe/ZdSxJrRWedjzM7lp5ZJ5nGz8CUJto7cmQjIKJEpXzJ 784hFAKQqyVxwoDGj0s8NwmnTdVtC/lSFu0lTkpkhpoB38SE683Chxq/6XqNPyl5 hk+JFImwass5QzAj6O6QcI4wmiHZDkBGLamZnaifDmEfIK+R7ANRBWUXAa5PhnzE mW2EIqi6bLlYglVZN2rCYdpcEhAv3ghTBVvqpHgFukmm6MqJVNZoXLmP3eNQZjRw xR1dfHb+WHbAFP3Xn6obrSAUTn+y6Rm/eccSzlv7fzw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=AMypuC TgdEKMImPFFfLYRi2B+5NeajLyj1BU0N3gpDA=; b=PxNEa/VoartYvg/tyepwQD f373YBcLVeBAyHvbAuBp1uNi3HssFOBY+k62UgJAPW0DWa4PqiL9Nfymqhc7tMwx QAI1oGLK0abxxwnHQZ3fwZ0YPCGsLaAcPjViL24IbOtE/AInUGOD3dBliSow0qLI 4++pWV3hSFYTLNCTR3gts/jqNaKPmtaftzS7qhGrf5v8zvH+2TZkK8+nMZEvQkfS 4QgoK2rAT4CPkoYpLxa4ET3Mf+HqV10i5murTgZ7A1HTEUFd4SX4lzy6vZmIyKEZ K3C6IGS5q/cGqiQiG7gpEr/oJ1STTZKKI86PszXPX5k58kZQzfMLWOEXkxtp8AEQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedrleehgdeftdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepvdegudeuhfdtueeltedtveejheeh ieevueeigeelteegleejleeiueeiheegvefhnecukfhppeduuddurddutddvrddukedtrd dukeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhep mhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id B12FF3280064; Wed, 13 May 2020 20:07:40 -0400 (EDT) Date: Thu, 14 May 2020 09:07:38 +0900 From: Michael Paquier To: Marina Polyakova Cc: daniel@yesql.se, a.lakhin@postgrespro.ru, pgsql-docs@postgresql.org Subject: Re: Missing comma? Message-ID: <20200514000738.GA166343@paquier.xyz> References: <5B3957FE-D31E-4838-B35C-C2F0EEC3E557@yesql.se> <6fa8ba75057b16f88010c2b945f720c0@postgrespro.ru> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="gBBFr7Ir9EOA20Yy" Content-Disposition: inline In-Reply-To: <6fa8ba75057b16f88010c2b945f720c0@postgrespro.ru> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --gBBFr7Ir9EOA20Yy Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, May 13, 2020 at 05:17:43PM +0300, Marina Polyakova wrote: > 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. Yes, I agree that this last "or default" in the docs does not make much sense, because we always enforce REPLICA_IDENTITY_NOTHING if there is no replica identity. > diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml > index 02ddebae99d98110a8dd290dd4cb0c980adf7984..034a08f80ea4269f131e7e1383ba482fd76d9344 100644 > --- a/doc/src/sgml/catalogs.sgml > +++ b/doc/src/sgml/catalogs.sgml > @@ -1936,7 +1936,7 @@ SCRAM-SHA-256$<iteration count>:&l > d = default (primary key, if any), > n = nothing, > f = all columns, > - i = index with indisreplident set, or default > + i = index with indisreplident set (if any) > > And you don't need the ("if any") either here, no? REPLICA_IDENTITY_INDEX means that we have an index associated with the replica identity so it seems to me that this last part can just be removed. -- Michael --gBBFr7Ir9EOA20Yy Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl68i8oACgkQnvQgOdby QH2Sjg//aqoed6UBAxTUPNGjSuWSzj5yYc0CsYyu8uuW+xI0YlMb8aSrtY39gTSP 7kIn9iSPKTORiv13sdMZ3Wprz8WaD4WhRHJ0Ry8b6LERGDLY6nxVgrPNVzdoO3vj LcvsGaEEcTdNbwZ2WK7pXAZlrFXF57/Eoj6wprrjk0UhRvwPEtkKaEpjamPg9iVT vG0OJ4HqdY78nJtqQ73C+iSbgcQkHqIYQpcbwE7p0boXeCALXcNFSMLg4T4PT0Rc jBUahupegF06vA1Snku5EmGtI0nWHlQSonhdgogtAUC6vkQ4e/jk53cAv3JyyxgY Zya47n0ltmrekD+q4YX8oFYxPkeGbFcEDa+mrLzruOzjdKQxxQmfeLD7aEFx8sPr /XGXY4qhgdkeo5IcdSotbEH2B4EWUtdkUCjoqU2vBcucnf5y1zsmohLofDhc8350 aFqMJlRKA/RflWjKj4AiCPaQ6f548OnA74d+GvJfTql/xZnQkKD4KumuzBgnHeTb RXurvasMiR1SqdaNMvtZlFG/24EByhjEiFKzOgLSSBF1M+1wQ8v82G3ktDpy4ft/ Ben89jA9AXe9hE2J5qbVilmNyHEcmOJS+RtGMFpFahxc2ipDwPnMWVteWfMLFVgU a1XHaSQu94HXJkENI6ep4Ub0I8OxVAaWvD5qmqf6wVoWSU/vR7Q= =VnKh -----END PGP SIGNATURE----- --gBBFr7Ir9EOA20Yy--