Re: Adjust error message for CREATE STATISTICS to account for expressions

On Wed, Mar 25, 2026 at 11:15 AM Yugo Nagata <nagata@sraoss.co.jp> wrote:
>
> On Wed, 25 Mar 2026 08:24:40 +0700
> John Naylor <johncnaylorls@gmail.com> wrote:

> > I'm ambivalent about this. Instead of trying to document all the
> > possible valid possibilities (which may get out of date again), maybe
> > we can say that it's not allowed on a single column?
>
> Thank you for the suggestion. I agree that this is a simpler approach,
> so I've attached a revised patch.

- errmsg("extended statistics require at least 2 columns")));
+ errmsg("extended statistics are not supported on a single column")));

I'd probably write this as "extended statistics on a single column are
not supported" (no need to send a new patch).

Any objections?

Also, I'm leaning towards not backpatching -- I figure a user that got
here by fat-fingering an expression is not likely to be too confused.

I looked in the feature thread and saw that this was actually raised
during development of the feature:

https://www.postgresql.org/message-id/CAEZATCU9uPo7JYdx4k0-ufXXZH8t7itodibUwCva%2Bs%2BAvAKcnw%40mail.gmail.com

-- 
John Naylor
Amazon Web Services