Re: BUG #19842: pg_restore_extended_stats() rejects a faithful pg_dump of ANALYZE-produced range expression statisti

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Cc: 303677365(at)qq(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19842: pg_restore_extended_stats() rejects a faithful pg_dump of ANALYZE-produced range expression statisti
Date: 2026-11-10 03:52:52
Message-ID: avKVFEGuLRlhdTyp@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Nov 09, 2026 at 10:49:38PM -0500, Corey Huinker wrote:
> Just seeing your reply now, but I also got drawn to 261f89a976bf not making
> the same (stats->numvalues[k] > 0) to (stats->stavalues[k] != NULL) change
> for extstats as was made for attrstats.

Yeah, we need to fix that first, I think..

> In addition, we need to complete decouple found/notfound checks for
> range_bounds_histogram from the other two, as all of those "must be paired"
> checks are for things that share a stakind.
>
> I'll toy around with some workarounds for the '{}' case and get back to you.

Okay, thanks. I'll probably tackle some more issues that are assigned
to my head first, which should take a couple of days.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message shihao zhong 2026-11-10 04:35:17 Re: BUG #19841: SQL/JSON RETURNING coercion to GUC-dependent types (timestamptz etc.) is wrongly judged IMMUTABLE -
Previous Message Corey Huinker 2026-11-10 03:49:38 Re: BUG #19842: pg_restore_extended_stats() rejects a faithful pg_dump of ANALYZE-produced range expression statisti