Re: pg_stats and range statistics - Mailing list pgsql-hackers

From Gregory Stark (as CFM)
Subject Re: pg_stats and range statistics
Date
Msg-id CAM-w4HN_re3=z=iKJHz7WOHuriE2OiZZoPo4GS-fyL6gMKUBVQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_stats and range statistics  (Egor Rogov <e.rogov@postgrespro.ru>)
Responses Re: pg_stats and range statistics  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
On Fri, 24 Mar 2023 at 14:48, Egor Rogov <e.rogov@postgrespro.ru> wrote:
>
> Done.

> There is one thing I'm not sure what to do about. This check:
>
>       if (typentry->typtype != TYPTYPE_RANGE)
>           ereport(ERROR,
>                   (errcode(ERRCODE_DATATYPE_MISMATCH),
>                    errmsg("expected array of ranges")));
>
> doesn't work, because the range_get_typcache() call errors out first
> ("type %u is not a range type"). The message doesn't look friendly
> enough for user-faced SQL function. Should we duplicate
> range_get_typcache's logic and replace the error message?

> Okay. I've corrected the examples a bit.

It sounds like you've addressed Tomas's feedback and still have one
open question.

Fwiw I rebased it, it seemed to merge fine automatically.

I've updated the CF entry to Needs Review. But at this late date it
may have to wait until the next release.




-- 
Gregory Stark
As Commitfest Manager

Attachment

pgsql-hackers by date:

Previous
From: Jacob Champion
Date:
Subject: Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert
Next
From: "Gregory Stark (as CFM)"
Date:
Subject: Re: [PATCH] Introduce array_shuffle() and array_sample()