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 1gc19r-00088v-Rt for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Dec 2018 04:51:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gc19q-000841-FS for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Dec 2018 04:51:02 +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 1gc19q-00083t-51 for pgsql-hackers@lists.postgresql.org; Wed, 26 Dec 2018 04:51:02 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gc19l-00026w-TG for pgsql-hackers@lists.postgresql.org; Wed, 26 Dec 2018 04:51:00 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 437DF21820; Tue, 25 Dec 2018 23:50:57 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Tue, 25 Dec 2018 23:50:57 -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=rwGhr+dKLCNx46Sn/u40zjPZnjC uKcrfSJQF1pTvqZI=; b=B9dVwrhx0uaIsUJ1RUnCLxXM3Kv/c6pFNnEjllA5W1G TrMGFKZrsKtmuTqtwLTmm87RTkho5T+0XnYw3ffORrkbIZeB12rm4FDD+OuoJF8t Urszo3igvvMRf+QJgsCPX1QA82wjU+LTZ/bPTYfK8hI7OaMCbC8OIMbTHBwWGGJc nNHvOsD8mGZJokjkmtSATUDazOytN1RR/CCwg/V7yY41RG4X8gtygUPXB8vtkXBH kVDv5tgi29sH2OTphiVJN4Vi2OayWHxqJ+QafmQNOkGAJrM501AX1lmjO/uOrJCR A55/40fXe4k6SDySSPF7vXtIwWCK8kk2OmnzUYsrniA== 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=rwGhr+ dKLCNx46Sn/u40zjPZnjCuKcrfSJQF1pTvqZI=; b=vAZnji1aFktNYTfYFqnBLE sAVNHzc4viVKZZR9mnE8ui9cGfb4ssiFiM/VyKQ745VXxuTA43rNbGcocNjvrWno Z5wpfu+UmeoSwNbu4RHDDqWTOM5DBKKrTXagY6uAWbRRoXH4/y5T7drSXzumae7z N3LuVA+CqgdT3/pym6HszXuBBlBg+HOC7FTM2a/eQpebaRfQQeIhVSxochHIdEjd I/KFYX/zKQ2uckPoBrJCL1JYKl5kdeq4On96yzP07GkVyDjvN2qJlPCqSDexsglH ZxblfReXfD9HjTwIRsEow8Fj2IhvSlo9zkgAtpCPOtYpO2Tzsu0O40DhaZEk+Q1w == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtkedrudekgedgjeekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfquhhtnecuuegrihhlohhuthemucef tddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlhcuvffnffculdefhe dmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgt hhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqne cuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfkphepuddukedrvdeguddr vdehtddrfeegnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquh hivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (mp76f1fa22.ap.nuro.jp [118.241.250.34]) by mail.messagingengine.com (Postfix) with ESMTPA id 1E3FDE4445; Tue, 25 Dec 2018 23:50:54 -0500 (EST) Date: Wed, 26 Dec 2018 13:50:52 +0900 From: Michael Paquier To: Tatsuro Yamada Cc: Kyotaro HORIGUCHI , pgsql-hackers@lists.postgresql.org Subject: Re: Tab completion for ALTER INDEX|TABLE ALTER COLUMN SET STATISTICS Message-ID: <20181226045052.GG2234@paquier.xyz> References: <20181219052705.GD19856@paquier.xyz> <830f4ef8-577e-53ed-4017-adad9c21d2e2@lab.ntt.co.jp> <20181219092255.GC680@paquier.xyz> <1c45ffd5-0a03-7608-43d8-a828253c0c52@lab.ntt.co.jp> <20181220013831.GJ27104@paquier.xyz> <9e5c22ec-6071-5495-0265-b7a96afb1a15@lab.ntt.co.jp> <20181221071300.GA1343@paquier.xyz> <5be2c21a-9a15-8200-0c76-6bc936ef69f7@lab.ntt.co.jp> <20181225052703.GE2334@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="VaKJWhUROU/xPxjb" Content-Disposition: inline In-Reply-To: <20181225052703.GE2334@paquier.xyz> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --VaKJWhUROU/xPxjb Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Dec 25, 2018 at 02:27:03PM +0900, Michael Paquier wrote: > Thanks, I have committed this one after making the logic to ignore > column numbers a bit smarter, one problem being that "ALTER INDEX foo > ALTER COLUMN" would try to suggest SET STATISTICS directly, which is > incorrect. Instead I have tweaked the completion so as COLUMN is > added after "ALTER INDEX foo ALTER". This could be completed later > with the column numbers, in a way similar to what ALTER TABLE does. Could you rebase the latest patch please? The latest version sent does not apply anymore:=20 [1]: https://www.postgresql.org/message-id/bcecaf0e-ab92-8271-6887-da213aea= 9dac@lab.ntt.co.jp -- Michael --VaKJWhUROU/xPxjb Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlwjCKwACgkQnvQgOdby QH1sbg//aNunOKq+YUW0dZqrtzHYHiKF/+QWX5DKe9hR2zq+SWxijb0Zi0m3bTkR 9IPwmghB2s5qjMuXldrXC8vrpr2kBAjTXAY91/f53J8XyeAgYEgaFaDouNoLmC9M aSFp7e2sSi6Xe6NBWE/MHVERYVvlW9KTXlq6hqySoEi2fzGWZWiWpo5pFvtIwDpT G46pSjVLoBaEPjZVNlkSBLepA9iY8I3CO+JF76TkdJuweLpqo/R2ZsxlOFXrmIyr grW7NUolDXZhoW8rnnJ3PRiNj8t87SewQ6B54wSJe2WFtSC5p1g92nwJj8s8LjSV UDNeAS5cY1heOVMsTr3tbgL6f8Q5zhly6HHPh+8hSxnaexUIVXejP2RiTns6+mhO B/Zco0j4EKd4+t1X2+H0q3+NkvOhgW1maM1+mVprMokF8HTkUBQsUQsUl8azMona jTi8U7n90nuDukfZmZD03AEu+mEHgiQdnWuA6YTRw0Zk9KFQSvQgcrQqDlhLxtg5 /YF9T3yudLNQAGPfDUAhQuyvIAhFCb0SeOD37FMREwf3GZzWYnWXYTkgPUi789C8 g96S5T8/dJn1VjvlVjeeW0X/EekcMBPhjxLeBCtx3VakKYML/MOfiQ5psfNrmDyZ yuwqpQ3Sz5cM+V2m3OvbDHlCNRgErecjOd4gPTaCwCvfCqJg2Yo= =0Btf -----END PGP SIGNATURE----- --VaKJWhUROU/xPxjb--