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 1mJT6D-0007bH-Hn for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Aug 2021 04:04:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mJT6C-0000v4-7C for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Aug 2021 04:04:12 +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 1mJT6B-0000uw-VK for pgsql-hackers@lists.postgresql.org; Fri, 27 Aug 2021 04:04:11 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mJT66-0004jS-NO for pgsql-hackers@lists.postgresql.org; Fri, 27 Aug 2021 04:04:10 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.west.internal (Postfix) with ESMTP id 3FE913200971; Fri, 27 Aug 2021 00:04:05 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Fri, 27 Aug 2021 00:04:05 -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=gif7+SMh+addCgRaEz8zTleEqSh sV3rjWA9muwged7Y=; b=SXIMdvbKkVuJdo8FzhmZFU8Rtu9jQzlQadl11MEScSe Nhk9/Hh3zhHXFwOEywdlDhhdHG5tnCsLZkixyrEkmZTUf+u7A7g/OySqGMBsqj6z NrnXYAWgwDOnOXrGy6WRllMPizVPefNPAHy0ZDR1kD4EOHD7rX8YQ7Jwcxt1+Grg m1majob7Nx9WYxlDJzNOICNxcEhGq3j8JL1s0BWOlIIEbKjIMrFIlPEW3G0G+x+2 OPb78/0QND4rrF2TVCLVPg9o2QN84mlOFccW/pKDYtGbRRwFStQuVrQ9kgMo6b08 U8saSI3Crycydg1/5BTDmtNxw3SItd6Rch4VFCc6qjg== 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=gif7+S Mh+addCgRaEz8zTleEqShsV3rjWA9muwged7Y=; b=I76IWr05KwwP7jv3Bi3YtP 4S/+B0FgSGB5g7n4p9yAnE6hvSCg1f2KM577M0+7ajJc1TfJtyA2owRmoxQs83QR Zo8kcvbNVRaLXbvP3pUdROuc0LJ4+PNsbSYVqHTGY/UmCsUwEmf6NrT0sfzPpbxD NPTg1xCZVwr7UMmRszS3ZumWYMAUcWIjwPdlDRjVz99zmKo858eZr91vv6V8GN7w hog+ijWMKxI8ISmtIKB/bm7EeaNw55Y5DBMu4DpxQARiXoDhkh3U+s5t8bBfQu4d fmQCy+iw94Qy+msiXwEL0ctrJfUZfIGikzrSXJ7UVukpDz5FJqGUAe+GNy3R40mg == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrudduvddgkedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt jeenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeevfefgueegvdejfeejffekhfef teekledvgedvfeegfedujeeutdekheeigfelueenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 27 Aug 2021 00:04:02 -0400 (EDT) Date: Fri, 27 Aug 2021 13:04:00 +0900 From: Michael Paquier To: Dagfinn Ilmari =?iso-8859-1?Q?Manns=E5ker?= Cc: pgsql-hackers@lists.postgresql.org Subject: Re: [PATCH] Tab completion for =?utf-8?Q?A?= =?utf-8?B?TFRFUiBUQUJMRSDigKYgQUREIOKApg==?= Message-ID: References: <87bl6ehhpl.fsf@wibble.ilmari.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="D6owGmyqdXKwRmGl" Content-Disposition: inline In-Reply-To: <87bl6ehhpl.fsf@wibble.ilmari.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --D6owGmyqdXKwRmGl Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Aug 03, 2021 at 12:48:38PM +0100, Dagfinn Ilmari Manns=C3=A5ker wro= te: > The other day I noticed that there's no tab completion after ALTER TABLE > =E2=80=A6 ADD, so here's a patch. In addition to COLUMN and all the table > constraint types, it also completes with the list of unique indexes on > the table after ALTER TABLE =E2=80=A6 ADD =E2=80=A6 USING INDEX. I was reading this patch (not actually tested), and that's a clear improvement. One extra thing that could be done here is to complete with types for a ALTER TABLE ADD COLUMN foo. We could as well have a list of columns after UNIQUE or PRIMARY KEY, but that feels like extra cream on top of the cake. In short I am fine with what you have here. -- Michael --D6owGmyqdXKwRmGl Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmEoZDAACgkQnvQgOdby QH2fww/9Fp64k3hwKgIjn61oH7c+1MiZquKZsZev4bB4TzgkVzIbhdnzT8IHS9Gr 6QFrppYAgGPjt4h8Hj4pJ1OvEWl28Fmv6C7pRtsceRetXU0LIQHzGdP7OAZ1Yu/S h4DS5lxQJ6U+To7ZfRe2w/lmkJMHa9NVCF8HfeJWV4TO5jt9JgOeS0d7ya97bUvo iD80y1UKVzVcL2Veg7IRbWzPzdbGMaM5Rl1fD+I87pe8qrBa3Y6Mc/GPoX5b3yA+ m5pxgVoDCAKkbRi1UeNtdOZyi5hTAPZx4Oj7oej8QLxl9hDc76YLyQ7Ep8SHsWvw Aqio7Yl0Seq36QmI32H3Is+emV8yFw70Yh0XJVaB6O+x1jFjdxxfYygmzl92fIXl GG71tkjfMWTc6/A595PnuKqR1TwJpbJ5xAYD4iME1kGXQCl1jXTHsEMKB9YnSyys sJeIpRy7wmCYvwd+sYFAH+yqgmdW5vatYc5BoxUKZd8vM/CjT2jbv5CS+xfrHsKO 52poN36XmQe43yjfzft7iP8SDvbG07/3KAyIDw5k6QsH+LaqbmO/id6GczR+JIm6 aABkGTb1FYvnqsTZNeEIoSHeQL59n3kOGVPSvia6SqDXY6ZtcU7sZMINXznzB703 OvHDDq6q7q6LIBj8ddcS3XPAdBkI5PXcGJwYJHUtktqAoxSYAJg= =5XnE -----END PGP SIGNATURE----- --D6owGmyqdXKwRmGl--