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 1iFq87-0004Be-Jc for pgsql-docs@arkaria.postgresql.org; Thu, 03 Oct 2019 01:42:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iFq85-0002HS-Gm for pgsql-docs@arkaria.postgresql.org; Thu, 03 Oct 2019 01:42:05 +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 1iFq84-0002H3-Fc for pgsql-docs@lists.postgresql.org; Thu, 03 Oct 2019 01:42:05 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iFq80-0000Li-S3 for pgsql-docs@lists.postgresql.org; Thu, 03 Oct 2019 01:42:03 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id B629F54D; Wed, 2 Oct 2019 21:41:58 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 02 Oct 2019 21:41:58 -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=fm2; bh=4zhjiQUHT0DOjtn2h6Lm7rmPjuq 9xpadwFuKCMNk8iQ=; b=OHNSSxxO4u7tWS3RLQQWsj1npprFRiK5iN7SpAROG4H lP4tY3IRQ0mUoT38neA/oP6o06G1ei8yUU7QE6FMN8GnRoL7AZ6Ss61BUoplCNqU dqD83pnT7HaVEx+GAFohYocKCfyxo22Yb8kri7kZf/1nGVflCxHj7Ux5pp6y3Yxc E03s8w6lJL38jKkerpDAtfIlFkRw1JmLqK+GP2/Q+s8vP0vdk0w+BGyHUCQspkT7 jY+8HHVXn4rtcGCrxy1A9cU2OkmictotB076B6ZYdZL0pBf1a5WHhiPHAB06ff/9 JusxBFpsXaSfISyuFiBNHFU3mWaIi4DI8zlEWvZt0mw== 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=fm3; bh=4zhjiQ UHT0DOjtn2h6Lm7rmPjuq9xpadwFuKCMNk8iQ=; b=uovpPh9+w2yzVRgkJwtrFL 8POpQqpiv1CYPvInhvu8VnibxhOv4H8v1iAlBAt4SIO52uB8GqzCLLde3DCQVAyc V9YLYr0fkYYlGTNB29qHKdnEEz0aQUHbGGG2yepDFWvxyIVNDZKRY+i1eQ6sRmRC toq0+4SYnW1kYc6QESE4rDC1hvmtxlkXFRT0WMnplpd2PIUYAkir2TjMjnJqhNaY 7SzDIjLOymXgqcvGfiul5327nCt5zVWgp3/GJas0b/mhhhUnieH2EJqyitzxYbBH jGMVhFkp232VFxJH6xZjhq3jiGIuxYrY0G/bAsPPAtUUnDuOZFvqGoRuLOZwSxHw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrgeejgdegkecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdefhedmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfk phepudduuddruddtvddrudektddrudekheenucfrrghrrghmpehmrghilhhfrhhomhepmh hitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt 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 27BA7D60065; Wed, 2 Oct 2019 21:41:56 -0400 (EDT) Date: Thu, 3 Oct 2019 10:41:54 +0900 From: Michael Paquier To: Oto Brglez Cc: pgsql-docs@lists.postgresql.org Subject: Re: "DROP INDEX" correction Message-ID: <20191003014154.GA1586@paquier.xyz> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="3MwIy2ne0vdjdPXF" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --3MwIy2ne0vdjdPXF Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi Oto, On Wed, Oct 02, 2019 at 09:55:14AM +0200, Oto Brglez wrote: > I suggest that you add a statement/explanation under Parameters > > CONCURRENTLY that would say something like >=20 > "DROP INDEX with CONCURRENTLY can only accept one index." >=20 > I hope that this message will be helpful to someone and I wish you a > pleasant day! The documentation of DROP INDEX includes already the following sentence in the paragraph for CONCURRENTLY: https://www.postgresql.org/docs/devel/sql-dropindex.html "Only one index name can be specified" -- Michael --3MwIy2ne0vdjdPXF Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl2VUeIACgkQnvQgOdby QH3a9w/+KIu1HQM5vofJ88+xpE/5Q7JH3cjTyqVJd3xTYflth1uiOBTUpWc4TkAy g1h5kjMxQshvnIdRKEIdsUsac3oQXTDKO+s+5Zgbfu/x5wznqJByIXTyD8Zt6MUb 4hmDRIjKJRwSjTvbq/VYN3ctccZv/8PeCs0zx5jBMT0y4Xfk6FQkW7UJRjEJ4haY e0GR5ctXSxGo5GKKUe5gXuUHiOG52kiAQg1M2HmSd9eennwNZKy4JKijgd8CucOO zD7cJYEXern1hjX2OWT31mASlKWf2U84Kkdl30aC9v9+WY+yC3IvX2apH7cWCyEs TCw4Mdomx88uszeZFYR/wnNWNRI5wsOz3T32bWTLoShIwnXsfADKYNo8nK8tBguJ FSq1fXe6DQwssywrFBr125aNijxVbh+h+MBwtiSv6LymE4luIrU9+CNazOaXsJfN J5kXWe1Uff3saV5ISKV7YR8n/3zGOk1P0DN3i21PVarGaC68AohU6EKw0zCBa1yp g9UwY7zUrjpFBUkQH+XXzWp19Rz7GhHpIKhUFvWQiMCyHhiCOSymlNtQZUh8kJXy dUURyykGmGQkYlMBpv+jsJ07x7TWl8H7WGsCwzQtP0uszI6Bw5S3D6jHND64Dxrt I1EXRBnGsBJmL1BwKJpUQR8nOeMeDFmZVD+gAtK3wkxKrYf7Xak= =AqAd -----END PGP SIGNATURE----- --3MwIy2ne0vdjdPXF--