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