Re: BUG #19849: queries fail after ANALYZE with expression stats on arrays

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: shihao zhong <zhong950419(at)gmail(dot)com>, Atisss hh <125atishprak(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19849: queries fail after ANALYZE with expression stats on arrays
Date: 2026-11-09 19:43:15
Message-ID: 2492770.1794253395@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Michael Paquier <michael(at)paquier(dot)xyz> writes:
> On Mon, Nov 09, 2026 at 12:10:33AM -0500, shihao zhong wrote:
>> 0001 is your fix plus the same change for stanumbers. Now
>> serialize_expr_stats() matches update_attstats() again.

Ugh.

> Tom, any thoughts?

I think it's unfortunate that we have two copies of largely the same
code that have to be kept in sync. At the very least we ought to
install comments warning of that in both places. But I wonder if
it's practical to refactor so that there's just one copy?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marcos Castedo 2026-11-09 20:04:55 Re: BUG #19816: PL/Python SD dictionary is split by input collation in 19rc1
Previous Message Tom Lane 2026-11-09 19:21:48 Re: BUG #19816: PL/Python SD dictionary is split by input collation in 19rc1