Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aiPcb-0005zQ-7v for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Mar 2016 16:57:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1aiPca-00006V-AH for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Mar 2016 16:57:32 +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 1aiPcZ-00006F-Ba for pgsql-hackers@postgresql.org; Tue, 22 Mar 2016 16:57:31 +0000 Received: from linode.thelabyrinth.net ([198.58.117.137] helo=mail.thelabyrinth.net) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1aiPcX-0007WR-3T for pgsql-hackers@postgresql.org; Tue, 22 Mar 2016 16:57:30 +0000 Received: from desktop.home.thelabyrinth.net (unknown [98.204.177.190]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dsteele) by mail.thelabyrinth.net (Postfix) with ESMTPSA id ADD6B12D13; Tue, 22 Mar 2016 16:57:28 +0000 (UTC) Subject: Re: IF (NOT) EXISTS in psql-completion To: Kyotaro HORIGUCHI References: <20160205.170901.60679714.horiguchi.kyotaro@lab.ntt.co.jp> <56E8C077.2000903@gmx.net> <20160316.130117.113925687.horiguchi.kyotaro@lab.ntt.co.jp> Cc: Pavel Stehule , Peter Eisentraut , PostgreSQL Hackers From: David Steele Message-ID: <56F17977.8040503@pgmasters.net> Date: Tue, 22 Mar 2016 12:57:27 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:38.0) Gecko/20100101 Thunderbird/38.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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 Hi Kyotaro, On 3/18/16 3:22 AM, Pavel Stehule wrote: > I am looking this patch. It looks well, but this feature doesn't > respect upper or lower chars. It enforce upper chars. This is not > consistent with any other autocomplete. > > > I checked it against sql help and these statements doesn't work > > alter foreign table hhhh drop column > alter text search configuration jjj drop mapping > alter type hhh drop attribute > drop cast > drop extension > drop operator > drop text search > drop transform -- missing autocomplete completely > drop user mapping > alter table jjj add column > create temp sequence > create sequence Do you have an idea of when you will have a new patch ready? Thanks, -- -David david@pgmasters.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers