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 1gRQjH-0002F8-LK for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Nov 2018 23:55:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gRQjG-00066a-2p for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Nov 2018 23:55:50 +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 1gRQjF-00066R-JG for pgsql-hackers@lists.postgresql.org; Mon, 26 Nov 2018 23:55:49 +0000 Received: from mail-wr1-x443.google.com ([2a00:1450:4864:20::443]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gRQj7-0003eK-0B for pgsql-hackers@postgresql.org; Mon, 26 Nov 2018 23:55:47 +0000 Received: by mail-wr1-x443.google.com with SMTP id q18so20781426wrx.9 for ; Mon, 26 Nov 2018 15:55:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language:content-transfer-encoding; bh=VvcepJ75vscwrveftx2ryNsUV77hWLzn98QQAFsiiu4=; b=c8XI7xPOxMRF/ObevaV7fQLlLYGnH/aV7t61KyqdZyq+u7WwBkBnb09BdbbwJPj8iF 7nks4qqba1CtvgvTqXbZG4VGgIgfTUawxs0riomhk/+Rj62XPdNqsv0S5hfb9ub0qIfz ZLPZ7CE6btRHYiw4fNQ7gZssnKG69GDbzT9xwBaiChOhYWLNQxHdsPqMdgj7GKdvI1FO vGjoBUZxLC7o12U15qqpkOmnBA250rcFaQXsr7wtTM78ISX17Vw0zrqnU2qSz5Dn9Bgf 7BTdGnjU7Q901s5ujUFlyzXwQC9H527NobWqm9kPd3H3wA0eSfyfN+15QVrozcRjPXsB CK1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=VvcepJ75vscwrveftx2ryNsUV77hWLzn98QQAFsiiu4=; b=OwjXVcrvGhXF1V7DTVlp/X5t63SfTzkYaR0r4mcQF2P14f78bga5O2anB/yKJUmCZi IlzdiMP2upm0gDP2RtPxo1m4HFubgKWnlPkPE1c4gH9JgAaqAl4xdJYRaX0JUbBSbc7w 0EvsSgGGUdbfbo+RNhfr3q7YS+nRj36CNS+bMcPp8MhSp42W7LVB1GRQRePaL3ZUH7mN 9kEM/ZS4wQLheHhN2Ouk+78VMGIDLICsAoOqeILJNCbpYIj1APA5QTSKSWgmwCTzPCzl cFq5GPpe2c1pyAaxbnUTTEtVqQ8AIyjgGG/xVzRtuReG+b2XLIztfdDT/Ea9xPfzJXVx Q3uQ== X-Gm-Message-State: AA+aEWY1FHPZcazyx8ESw3J4NSdZ8f1y8MxIB2Mj6iLiT8H38TGw8erb sG3/oa/7nRPFy2XyHU4iTqoTcIYWPLlcH8GdslgsZj+SC/gLQ5WrAOX+5aA5uGbFZ46hzteFvAi UOo52InbAwSKrOWF94HKj2wcyOEIKrg/PP8fCoPDEJk3Yho4MDhIo6hQp5MVMK2LirNQUFNszfY SUhGiz9jKcoA6ELg== X-Google-Smtp-Source: AFSGD/UZPg03MyEAqdUl8wKP2Q0Wnsn8x7WpoAxoLGJOFzhujBfv7EgeRXfed3BGDosT/yYWlk1blQ== X-Received: by 2002:adf:bc02:: with SMTP id s2mr24635649wrg.255.1543276537949; Mon, 26 Nov 2018 15:55:37 -0800 (PST) Received: from [10.137.2.19] (ip-86-49-251-50.net.upcbroadband.cz. [86.49.251.50]) by smtp.gmail.com with ESMTPSA id s66sm2498323wmf.34.2018.11.26.15.55.36 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 26 Nov 2018 15:55:37 -0800 (PST) Subject: Re: [PATCH] Tiny CREATE STATISTICS tab-completion cleanup To: =?UTF-8?Q?Dagfinn_Ilmari_Manns=c3=a5ker?= , pgsql-hackers@postgresql.org References: From: Tomas Vondra Message-ID: <65551c69-46d4-305e-25fb-2e093454d660@2ndquadrant.com> Date: Tue, 27 Nov 2018 00:55:35 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On 11/26/18 5:49 PM, Dagfinn Ilmari Mannsåker wrote: > Hi Hackers, > > As I was hacking on the CREATE TABLE tab completions, I noticed that the > CREATE STATISTICS completion was checking manually for the start and end > of the parenthesised list instead of using the "(*)" wildcard (because > it predates that functionality). Attached is a patch that updates it to > use the modern syntax. > Makes sense. At first I was wondering why it was not modified by the patch introducing the "(*)" wildcard, but I see 121213d9 only cared about VACUUM, EXPLAIN and ANALYZE. The patch seems fine to me, I'll get it committed. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services