Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ag0vr-0004Od-3j for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Mar 2016 02:11:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ag0vq-0007s7-Md for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Mar 2016 02:11:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ag0uU-0006K5-E5 for pgsql-hackers@postgresql.org; Wed, 16 Mar 2016 02:10:06 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84_2) (envelope-from ) id 1ag0uR-0006Dy-44 for pgsql-hackers@postgresql.org; Wed, 16 Mar 2016 02:10:05 +0000 Received: from auth2-smtp.messagingengine.com ([66.111.4.228]) by mail.gmx.com (mrgmx102) with ESMTPSA (Nemesis) id 0LfYqz-1a0PoW2agD-00p3Eq for ; Wed, 16 Mar 2016 03:10:01 +0100 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailauth.nyi.internal (Postfix) with ESMTP id 38CE121031 for ; Tue, 15 Mar 2016 22:10:00 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute5.internal (MEProxy); Tue, 15 Mar 2016 22:10:00 -0400 X-Sasl-enc: gbnD1S53xwDTToCxFySY3NYXW6VLn5Wx05a3+LZVkrWF 1458094200 Received: from [10.0.0.4] (c-73-13-69-21.hsd1.pa.comcast.net [73.13.69.21]) by mail.messagingengine.com (Postfix) with ESMTPA id E948B68018D; Tue, 15 Mar 2016 22:09:59 -0400 (EDT) Subject: Re: IF (NOT) EXISTS in psql-completion To: Kyotaro HORIGUCHI , pgsql-hackers@postgresql.org References: <20160205.170901.60679714.horiguchi.kyotaro@lab.ntt.co.jp> From: Peter Eisentraut Message-ID: <56E8C077.2000903@gmx.net> Date: Tue, 15 Mar 2016 22:09:59 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:38.0) Gecko/20100101 Thunderbird/38.6.0 MIME-Version: 1.0 In-Reply-To: <20160205.170901.60679714.horiguchi.kyotaro@lab.ntt.co.jp> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:1mIxBXZ4POAcskB71NzI48OsbYpS58yAZZ7H7XwWVp5EbJvjCdF N4zmTLPHchYy7aaCFZzj7LxN7+dh8NUYN/uG0D/gxJr7F/WEkf6gEoXwjz3pLLbgmUVJez7 Acen/bnwcStoUPulFriVw19NvtylsmZLJlw6BNcw2GLfm4hvvRqwNjSc+Va6z8hvkTYMdiw lvSD5LzXh0qn0cxEvUNHA== X-UI-Out-Filterresults: notjunk:1;V01:K0:+3oNMt6+5rM=:Hanyq6Mdl6TcZ96eel/bwv +CSnNw5/7xWm306zbkFjbRSro4vpkgk8XJhVc4PaSYRohDrjyUMn9J/kCFX2s83LxWWrWn54B YRI45LIVXAZNPiC2ZfaHSTkUdQDINJJZjHfxIEb/DPhkha1emOWKFEF1B3VORgBIJCrGGvui3 ePqGU7Tvmr4VWxX25giXoL/+zU+W4O/baUJkQTvgi8FoeA3pbmX71nuMDX5eEyCo7EI79UmBU TbiVjaG1yyoNaNYPYttz2VyAvBao8tWsY7lamoHWlvbnMhNCjxlkXRJQgQUz528Uf5mFHro8E 2Ipakh5YC6jVi8EGFjbY/HMe8TiL0uGXooSKNPY4S6oKTBw8E9aJtFTGfa0u7HLK7cNkz+2Y6 LcQ/rCXnsHkpa/oyXyOvbi3IEJvLMhwbyoOq/8rA0WAe30LNtBHyPBqtVcPdHpUmdVPtwZZ/G lXEOGyPVXBvrNN8J30IkHHlU9zN4RDjO+hXkgb32ZwhZG9+N9/IqGWFhpTSTG/2IyJf0evWcA 6dgaDGwgsw6ulwyoE4M+IodjP6feo2B4PDIsq+JJez4bsAIqoADRFfdG01jC3QypXRGq6ntQf NGrqUXeZ5hNYoBV10AZQaEnJT99I0UnMdoOgNRHr8hwJc+J6CZ16BGUVl7cNEv3InRlYYRijD p1FtQTkIzRbSz9L/BKY9xufRzxOD+pbmneY1HXprvyJl9CyV6cPfMNOoq2ja8BGozWMNLQB/d l7U51DTaPugJL9bZG5IBysT0h5LLKHmI0pxcZrBlFo+079Wx172NVtTx+YMyOGv3Lar5NhX1R WqaV0FR X-Pg-Spam-Score: -2.6 (--) 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 On 2/5/16 3:09 AM, Kyotaro HORIGUCHI wrote: > I considered how to make tab-completion robust for syntactical > noises, in other words, optional words in syntax. Typically "IF > (NOT) EXISTS", UNIQUE and TEMPORARY are words that don't affect > further completion. To repeat the question I raised in the previous commit fest about tab completion: Why do you want tab completion for IF NOT EXISTS? When you tab complete, the completion mechanism will show you whether the item in question exists. What is the use case? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers