Feedback-ID: i0fe9450f:Fastmail
Date: Mon, 2 Mar 2026 11:15:36 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Corey Huinker <corey.huinker@gmail.com>
Cc: Postgres hackers <pgsql-hackers@lists.postgresql.org>,
	Tomas Vondra <tomas@vondra.me>
Subject: Re: Defects with invalid stats data for expressions in extended stats
Message-ID: <aaTyyG2P3ifly5wW@paquier.xyz>
References: <aaDrJsE1I5mrE-QF@paquier.xyz>
 <CADkLM=c_3mPHr0JGP_72csQkpAt-v2fRN830RO8or1_R1qX2Wg@mail.gmail.com>
 <aaEctAQb8yDhqwaE@paquier.xyz>
 <CADkLM=dqmnrX+MuS6bAfE3wA9NHte_z=KpcvJLJp0_g0pfMTmA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="kgkHW8jQtRoy6z/i"
Content-Disposition: inline
In-Reply-To: 
 <CADkLM=dqmnrX+MuS6bAfE3wA9NHte_z=KpcvJLJp0_g0pfMTmA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/aaTyyG2P3ifly5wW%40paquier.xyz>
Precedence: bulk


--kgkHW8jQtRoy6z/i
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Thu, Feb 26, 2026 at 11:50:19PM -0500, Corey Huinker wrote:
> Thanks for the explanation. Changes look good.

Thanks.  I have spent a few more hours head down on it, and applied
the whole as two commits down to v14: one for the fix, one for the
module.  I have adjusted a couple of things in the module, with a few
things to make it work in back-branches.  A scan of pg_stats_ext_exprs
felt in order after we fail to build the stats entirely, to make sure
that there is nothing detected in the catalogs, so I have added a
shorter version of the SELECT.
--
Michael

--kgkHW8jQtRoy6z/i
Content-Type: application/pgp-signature; name=signature.asc

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmmk8sgACgkQnvQgOdby
QH1wJRAAin3/u8SrdpUpl3aVypZNghAVd7B/lVs/fMXgLD6u3I9htCQQG97vhDY7
NqUB1mdpm0oYUV+Xw99+a+FiS3swG7XW8of/kZeyKDmZFReZip//p6zKX2PspJot
IX9r76hNIej0AKayw5MpfqNnAVqCoeAR2F+xGmUqNZ1/RHF3Y1U2H9uAVAxf/X71
VzH+xFtYq9rWverubqsb1V6uy4cOSK9qnXira1WcFdZKXG4mDuYlGW+/b07zhK/9
fv0m/yY1b7uVMbOntTMSPzFnvstzpByKAY9fHP+vSAmGIY4Ac00Quqrpi/4BgNvW
88hdftr9beqwXXKbdFb0a4E/nmPlePkQPyVstAwJBZjARf4pa6DMm1g702j/xNC8
lRtFKLVuzkSq+yo4P7OKCbsdnpVXts6nOZYhG3SYlJVCqvXudq7RMA2pGwFSMbiD
qGlGX4lzZXppJj2GjcXmKcKbZ+MP4GKOksFekC9I//R+NheW1/aiAUEhiw+G3SgL
s0ioxA7BsGvj859UBoJfDzIF+R1yoSwdFvM1Lw7QXqzTYDG4KhWDi+xu9mb1NRGd
vJMM19J5cjY1TmG3C+/qufgbSRtrFqKLyNl/sXBYeEBfOHqgZhE/xGnKP1SflXqK
9y5s05Hh7t8E8CCChnWE/GjiyxgNHJ0KHmBoIqdl8SVgcMZ3hEk=
=VJW+
-----END PGP SIGNATURE-----

--kgkHW8jQtRoy6z/i--