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

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
Cc: John Naylor <johncnaylorls(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adjust error message for CREATE STATISTICS to account for expressions
Date: 2026-04-01 16:19:16
Message-ID: CAEZATCX+grmuX5g2zohY4z1vviSnYru7u8AgzF=KpfWnOhc-bw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 31 Mar 2026 at 15:47, Yugo Nagata <nagata(at)sraoss(dot)co(dot)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(dot)dd6f9d1d81299f5b2ad55e1a(at)sraoss(dot)co(dot)jp

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2026-04-01 16:57:24 Re: WIP - xmlvalidate implementation from TODO list
Previous Message Dean Rasheed 2026-04-01 16:12:38 Re: Allow to collect statistics on virtual generated columns