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 1gkfVr-0001IB-GF for pgsql-hackers@arkaria.postgresql.org; Sat, 19 Jan 2019 01:33:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gkfVo-0004zE-7Q for pgsql-hackers@arkaria.postgresql.org; Sat, 19 Jan 2019 01:33:28 +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 1gkfVn-0004wc-JM for pgsql-hackers@lists.postgresql.org; Sat, 19 Jan 2019 01:33:27 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gkfVh-00059B-2j for pgsql-hackers@postgresql.org; Sat, 19 Jan 2019 01:33:26 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 4AF7926630; Fri, 18 Jan 2019 20:33:20 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 18 Jan 2019 20:33:20 -0500 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=fm3; bh=JGZY2DwvHqlmC90+2OxrmbjD39y 4RVs0cviMbcuCUHg=; b=e4UMTHcb2Z8ocbbC4aBnt646Tcrv/XA+5BSegBLfiPx f9/p3ELpPlF/0pPCB18bE+GX+GZp9ODpsnK8rT2wPHYrKw02xqZFjzKGQfU7z484 xsKLbSLOIF/1fykkZ+CmNzMTL2fa4NCR2XKU+7kmuNv420fjAOjQJZoU06unEoFA Vn3gpS1i/9vQ39EeezDab3ZdC0NGzUEfc77xNl4iYHyQU1cSgy8RisweOXFgzH39 cx48IXFs39zKPtBHTQoR4oNXxkz9NjekoVSnQ1m/FWFxTHAQQmarHliTkV+C8X6r 2Da3d1Co2cscMS4kvPactVzAvokKOkqzpx6sp12XYTw== 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=fm1; bh=JGZY2D wvHqlmC90+2OxrmbjD39y4RVs0cviMbcuCUHg=; b=ABeC75v0lq4ih7o4JF6FEs j8LWl2Qw4OvP8aDDJUi8rU5qXHt+2tDH6qF9QtLlakRWMYYSXgHBsp/GjZ7wgx3g aHRQjyo2oBKRxkysUii/ByYgXRkbkfnQZaIaEjG2A+UfWo6+ReilXX8c1tSW5nka 9XjPZ2OvAf8/0eOfgTdlIVEFWlcBedu7FC3X2kUZxCq52uskzd3n1BShnZc380WU AvYwnOf9Dp4mF871NZjBIWEob0q6919zl/xzWamrLy1NtscgIF56d6MTRCVqf/Sn XKunCp2w/75AuXUPZqGic6NXa1ZxRa0rtZ+BfQlG5t7Jm1yvW5Ev2q8QsIrGiIAQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtledrhedugdefhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfhuthenuceurghilhhouhhtmecufedt tdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrhhlucfvnfffucdljedtmd enucfjughrpeffhffvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghh rggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenuc fkphepuddukedrvdeguddrvdehtddrudehnecurfgrrhgrmhepmhgrihhlfhhrohhmpehm ihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (mp76f1fa0f.ap.nuro.jp [118.241.250.15]) by mail.messagingengine.com (Postfix) with ESMTPA id 8177EE455C; Fri, 18 Jan 2019 20:33:15 -0500 (EST) Date: Sat, 19 Jan 2019 10:33:12 +0900 From: Michael Paquier To: Vik Fearing Cc: Alvaro Herrera , Sergei Kornilov , Peter Eisentraut , Michael Paquier , Andreas Karlsson , PostgreSQL mailing lists , Stephen Frost , Craig Ringer Subject: Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Message-ID: <20190119013312.GC3306@paquier.xyz> References: <201901161759.voovsk55ofe7@alvherre.pgsql> <57479e55-ce26-5c00-2525-09e267c7224a@2ndquadrant.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="+KJYzRxRHjYqLGl5" Content-Disposition: inline In-Reply-To: <57479e55-ce26-5c00-2525-09e267c7224a@2ndquadrant.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --+KJYzRxRHjYqLGl5 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Jan 18, 2019 at 07:58:06PM +0100, Vik Fearing wrote: > My vote is to have homogeneous syntax for all of this, and so put it in > parentheses, but we should also allow CREATE INDEX and DROP INDEX to use > parentheses for it, too. That would be a new thing as these variants don't exist yet, and WITH is for storage parameters. In my opinion, the long-term take on doing such things is that we are then able to reduce the number of reserved keywords in the grammar. Even if for the case of CONCURRENTLY we may see humans on Mars before this actually happens, this does not mean that we should not do it moving forward for other keywords in the grammar. -- Michael --+KJYzRxRHjYqLGl5 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlxCflgACgkQnvQgOdby QH0NEg/9FYBJWYfrrZdVR8Wi+WSya0yC/Mhtrlw9Imbj0hXd49b8XLGSH9Ppe96O VtfLiKOXbC1CfaKf/lBBcuEq8DOO2A+XQImBcXCCnkmShWTYAXaL82+MlPPHrWYu JufRsUA/V5kJ12qXxU3QrwwI4iyaI/8Ltc6XMHiMOzBCWJ3gVEUOnlCOS6L7Wynq EjtXU+iTnT+oI0IXmku+yU70AIH3ny7ErXewpOFrfpMfd7jzlxCKaGMEM4dSgH28 hXPaR96EK6wunFtRdgfRDgtzmK3+1FjlgmGJpVeIVaV+aPq7zMFVtPcQVqaePAlQ 4fB5L5Z2hpE3XFHwjBQWzSspe9idEEqZM/D/NU54pn/ofrJffQBxRAjNDVcIXKIR M5ZlWoQ3Hy/sKtFXZWWgoG+vc+JqmkmrB6XZWBaQ26+d9ts0THKw57DmUoSGvcng JTOxEg/MooYV+OZHG1rmxp3ZSXj0f3Sci9gtJutXAjDSxX2XM9x6BoX/NFJ5gF9N /wHVSqb1eoymLyY1BYlV+f5yf6bHtos5gPSv/Q46bmIFNPXyNwSFO1giAlk+hglx iwib77GoLAcaK95yaZHGxo4jbSAbdp9CyJ2xGxyyA2jUKTijnyEa2Pu9rlvF+uQc lUIikR0FNUklc9COsbNvSBFrpwLrTMgGp1D82/ZiC5wz1rnVKC0= =HEUw -----END PGP SIGNATURE----- --+KJYzRxRHjYqLGl5--