Horton

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

Dean Rasheed <dean.a.rasheed@gmail.com>

View thread View on postgr.es
From: Dean Rasheed <dean.a.rasheed@gmail.com>
To: Yugo Nagata <nagata@sraoss.co.jp>
Cc: John Naylor <johncnaylorls@gmail.com>, Michael Paquier <michael@paquier.xyz>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2026-04-01T16:19:16Z
Lists: pgsql-hackers 
On Tue, 31 Mar 2026 at 15:47, Yugo Nagata <nagata@sraoss.co.jp> wrote:
>
> Yes, that sounds good to me.
>
> In particular, the following suggestion from Dean Rasheed seems like a
> good approach:
>
> > Error: cannot create extended statistics on a single column
> > Detail: Univariate statistics are already built for each individual
> > table column

I've pushed that change as part of the patch to support extended
statistics on virtual generated columns [1], since I felt that patch
already needed to change that error message.

I didn't look more widely at other error messages in that file might
benefit from having separate errdetail text.

Regards,
Dean

[1] https://www.postgresql.org/message-id/flat/20250422181006.dd6f9d1d81299f5b2ad55e1a@sraoss.co.jp

Commits

  1. Split CREATE STATISTICS error reasons out into errdetails