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 1hcI0D-0001ST-II for pgsql-hackers@arkaria.postgresql.org; Sat, 15 Jun 2019 23:22:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hcI0C-0003Pu-Ez for pgsql-hackers@arkaria.postgresql.org; Sat, 15 Jun 2019 23:22:28 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1hcI0C-0003Mj-50 for pgsql-hackers@lists.postgresql.org; Sat, 15 Jun 2019 23:22:28 +0000 Received: from mail-wr1-x434.google.com ([2a00:1450:4864:20::434]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hcI09-0008Vh-9G for pgsql-hackers@lists.postgresql.org; Sat, 15 Jun 2019 23:22:27 +0000 Received: by mail-wr1-x434.google.com with SMTP id v14so6105309wrr.4 for ; Sat, 15 Jun 2019 16:22:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=H8UjAPs1iOd4+zdmThLN8WlGnkqJfRfNvp8djf2YxTA=; b=iiHihGNIpsBTzYROJGN9ZvLhwOcCOgCWnlty5GjnjskVBOEV1RXyJP5kQxLLGNxQ9p ZnIQ/lt3k9DHZyb3eiYbFSPXWYpgjXLHf24DZ6CEHW2nuW0n2Uur0qJAVlQoQ6lw3atb RuYFao0/a9HGmz0yBOXQM4lfPiN7gBUX3CUAdwrsp/Gs2dHKMh0DxcgJmWZK/lkVtJ9w Wav7n1UD5rGfOMU+89kdwTJdHQWID3pXMRobp9hAhwvQyorMdUvTn8USZUH+7ZAFfO4o tVKoAaRI7NSVID6RQKatiCAuh/bR4435IMzpnlIsIZtO3sZD+RO9CAvHiOxF4Q7N22kE jhtw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=H8UjAPs1iOd4+zdmThLN8WlGnkqJfRfNvp8djf2YxTA=; b=L8EJy8wZSP1+Cy8Ll7U/WC1B2FXhSP6xpXSnOOEg5rP00ZWysVZTLnWuaHaybcT71a 4SoUtJpZH6L9dWweapYmwLrx9sKERbvOyrOMcQslMxSqpWK9tpcthoVhtV9vKYEAxerg NXvw1NaS6qKDVNG7jZsh+HxrJhUncv4yC7u6/QP3HEt9N/Sc2BkEN58nZ7g+zN2EzMVR VPNIrle/z5F/Q6G+nkBzV9TMP6ofQfNc5p4rmjW2WqyZpH1mNoLv4rnljbpv320W+Fqt 3lTd454MQZPtuuBZnrTvwNq5FXTeEY5k91qH3DA8S7Wl4tDaLTNDGuo8om+yy5t2c4eu nmAA== X-Gm-Message-State: APjAAAV3ZIxm4sW/P6y9E5r/sR/IlgMXtOXNsB2MLAXtENuj+pa+0ChG PM3f5EJDf5MC69+baFg6nHKLYQ== X-Google-Smtp-Source: APXvYqzFOmUklDUMHQw9C5A0r9rxDV43f4TjYNAiWw1F6phdbxTIkTqi2b6HdTIt1rZ1a4vYaHRcmg== X-Received: by 2002:adf:c614:: with SMTP id n20mr11432985wrg.17.1560640941222; Sat, 15 Jun 2019 16:22:21 -0700 (PDT) Received: from localhost (ip-86-49-243-43.net.upcbroadband.cz. [86.49.243.43]) by smtp.gmail.com with ESMTPSA id z6sm8202250wrw.2.2019.06.15.16.22.20 (version=TLS1_3 cipher=AEAD-AES256-GCM-SHA384 bits=256/256); Sat, 15 Jun 2019 16:22:20 -0700 (PDT) Date: Sun, 16 Jun 2019 01:22:19 +0200 From: Tomas Vondra To: Robert Haas Cc: PostgreSQL Hackers Subject: Re: CREATE STATISTICS documentation bug Message-ID: <20190615232219.qpr52d6kunqavgyx@development> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline In-Reply-To: User-Agent: NeoMutt/20180716-1444-295967 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Jun 14, 2019 at 03:23:29PM -0400, Robert Haas wrote: >https://www.postgresql.org/docs/12/sql-createstatistics.html contains >this example command: > >CREATE STATISTICS s2 (mcv) ON (a, b) FROM t2; > >But that produces: > >psql: ERROR: only simple column references are allowed in CREATE STATISTICS > >I think the parentheses around (a, b) just need to be removed. > >P.S. I think the fact that we print "psql: " before the ERROR here is >useless clutter. We didn't do that in v11 and prior and I think we >should kill it with fire. > I've pushed a fix for the docs issue. -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services