Re: Adjust error message for CREATE STATISTICS to account for expressions - Mailing list pgsql-hackers

From Yugo Nagata
Subject Re: Adjust error message for CREATE STATISTICS to account for expressions
Date
Msg-id 20260403104453.ae4e81b0821533045b0520a4@sraoss.co.jp
Whole thread Raw
In response to Re: Adjust error message for CREATE STATISTICS to account for expressions  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
On Wed, 1 Apr 2026 17:19:16 +0100
Dean Rasheed <dean.a.rasheed@gmail.com> wrote:

> 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.

Thank you for handling this.
 
> I didn't look more widely at other error messages in that file might
> benefit from having separate errdetail text.

I’ve attached a patch that also updates other error messages to move
their reason parts into errdetail.

Regards,
Yugo Nagata

-- 
Yugo Nagata <nagata@sraoss.co.jp>

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_waldump: support decoding of WAL inside tarfile
Next
From: Henson Choi
Date:
Subject: Re: SQL/PGQ: All properties reference