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

From: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
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-11 01:54:33
Message-ID: CADkLM=ftnV12NmWVMD4NFVpHqFJCwdUr73QsLp=Byuz4f4bS+g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

This bug has the same root cause as bug #19857, but because that one deals
exclusively with attribute stats it needs to be backported to 18 as well,
so I kept that separate.

0001 - Same bugfix proposed for #19587
0002 - Decoupling range_bounds_histogram from checks against
range_length_histogram and range_empty_frac
0003 - The extended stats equivalent of 0001

Attachment Content-Type Size
v2-0001-Allow-empty-arrays-as-input-for-pg_restore_attrib.patch text/x-patch 7.0 KB
v2-0002-Decouple-range_bounds_histogram-requirement-from-.patch text/x-patch 9.0 KB
v2-0003-Allow-empty-arrays-as-input-for-pg_restore_extend.patch text/x-patch 6.9 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Previous Message Corey Huinker 2026-11-11 01:50:39 Re: BUG #19857: Stats restore rejects empty arrays, losing range and array stats