Re: Add expressions to pg_restore_extended_stats()

Corey Huinker <corey.huinker@gmail.com>

From: Corey Huinker <corey.huinker@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Chao Li <li.evan.chao@gmail.com>, Tender Wang <tndrwang@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Tomas Vondra <tomas@vondra.me>
Date: 2026-02-09T20:09:49Z
Lists: pgsql-hackers

Attachments

On Mon, Feb 9, 2026 at 2:59 AM Michael Paquier <michael@paquier.xyz> wrote:

> On Mon, Feb 09, 2026 at 02:25:49AM -0500, Corey Huinker wrote:
> > I was thinking of doing exactly that, with a lot of language around how
> > these extra patches don't need to make it into v19. But having said that,
> > they'll probably be pretty small.
>
> Getting the catalog change in would be nice at least, even if the
> expression bits of the restore do not make it in time.  Thanks for
> that.
> --
> Michael
>

0001 - the v8 patch, as-is
0002 - minor tweaks to get v8 to build, kept separate to make applying on
top of v8 easier
0003 - Bring back the pg_stats_ext_exprs set difference tests
0004 - Add the 3 range-stats to pg_stats_ext_exprs
0005 - Support importing the 3 range-stats.

Commits

  1. Refactor tests for catalog diff comparisons in stats_import.sql

  2. Fix typo in stats_import.sql

  3. Add support for "exprs" in pg_restore_extended_stats()

  4. Add information about range type stats to pg_stats_ext_exprs

  5. Fix comment in extended_stats_funcs.c