Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ciZoM-0008IP-Ng for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Feb 2017 04:54:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ciZoM-0003St-AJ for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Feb 2017 04:54:54 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ciZmq-0006sD-Hz for pgsql-hackers@postgresql.org; Tue, 28 Feb 2017 04:53:20 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ciZmo-0002mt-GM for pgsql-hackers@postgresql.org; Tue, 28 Feb 2017 04:53:19 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 0EEF95F794; Mon, 27 Feb 2017 23:53:18 -0500 (EST) Date: Mon, 27 Feb 2017 23:53:17 -0500 From: Stephen Frost To: Kyotaro HORIGUCHI Cc: michael.paquier@gmail.com, tgl@sss.pgh.pa.us, robertmhaas@gmail.com, pavel.stehule@gmail.com, pgsql-hackers@postgresql.org Subject: Re: IF (NOT) EXISTS in psql-completion Message-ID: <20170228045317.GE9812@tamriel.snowman.net> References: <1603.1488158409@sss.pgh.pa.us> <20170227.133305.68651190.horiguchi.kyotaro@lab.ntt.co.jp> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="88WGHg/YIrmbYbNb" Content-Disposition: inline In-Reply-To: <20170227.133305.68651190.horiguchi.kyotaro@lab.ntt.co.jp> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-91-generic (x86_64) X-Uptime: 23:49:47 up 234 days, 6:14, 11 users, load average: 0.11, 0.15, 0.15 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --88WGHg/YIrmbYbNb Content-Type: text/plain; charset=us-ascii Content-Disposition: inline * Kyotaro HORIGUCHI (horiguchi.kyotaro@lab.ntt.co.jp) wrote: > I suppose it is for suggesting what kind of word should come > there, or avoiding silence for a tab. Or for symmetry with other > types of manipulation, like DROP. Another possibility is creating > multiple objects with similar names, say CREATE TABLE > employee_x1, CREATE TABLE employee_x2. Just trying to complete > existing *schema* is one more another possible objective. I don't buy any of these arguments either. I *really* don't want us going down some road where we try to make sure that hitting 'tab' never fails... Thanks! Stephen --88WGHg/YIrmbYbNb Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJYtQI9AAoJEO1sijiDR2RViBAQAK60lCMKdCat0WGmhiCbEGib iMWyTJjZDThoP5AoQLONknLWGmHbqtglQYQ/OOnGt8nZnwNSucDY4+3eWR7dKRSI 02degE4m3n7wL54Om2M8c79nDCJv+zymo7u9wyZ2lnvAcvkcb9+OLSnvoIqrM3gb xVnbH9XDf0d5KlUy6qYAF0xcAkF8SyGzVpS7l07ciWcFX+4aC4nCkV/4r7is8FQT eg3TtT59f+6m+ypwLOLIi1aJ3/U/tKPb08HDGRPlIugDcvVF8mkjNlDX6pzmniYW 6pk9D2bP3/pJkwx9TzWE7wnrQg84s0ogTHyfzzSez95VM10QJz2JKRzXrN0ydUzR xoAN5n6AfQ1A4IQ0JdI+Poqfi2TEOqHjwx4pol2u1UqK4VY5/YC/OTr1b5QfUjxv DV4RNkLZuC4rtJ6Lqt2cu3wpCGqtz6f7DJLMEEj6jVcIZngQhgqi+kJsizPIjiBz WbmBIidMb6Vs8CR4oBwmGDf7pqkNRZK4qmbbbKvxQ7XpJTbCS6LW6shUBh95Wndn jUcl+uGwxZI2aW2QgH2LJ/lLzf/OmIn2ytSD12QN5as/WhJ1S5yui+jcf0IaoR8L H0QltGILZfTiDtfhrPYDNoXYY5BrtEzErQpUGqFYsMJcWGFFmnacgYcK5bmM2/Do lK9xUFPQvKQ2O1j94IKE =2EOZ -----END PGP SIGNATURE----- --88WGHg/YIrmbYbNb--