Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xQcuu-00000000Gdp-0hdt for pgsql-bugs@arkaria.postgresql.org; Tue, 10 Nov 2026 03:53:04 +0000 Received: from localhost ([127.0.0.1]:55194 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xQcur-00000003amE-4Byi for pgsql-bugs@arkaria.postgresql.org; Tue, 10 Nov 2026 03:53:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:44570) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xQcur-00000003am6-0qq5 for pgsql-bugs@lists.postgresql.org; Tue, 10 Nov 2026 03:53:02 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xQcuq-000000008P7-0dw8 for pgsql-bugs@lists.postgresql.org; Tue, 10 Nov 2026 03:53:00 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfout.phl.internal (Postfix) with ESMTP id 71A0DEC05A8 for ; Mon, 9 Nov 2026 22:52:58 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-03.internal (MEProxy); Mon, 09 Nov 2026 22:52:58 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1794282778; x=1794369178; bh=Z0julapMYN /lwyHSyUPFZz3nOjtbuqZ3p8Skr/yTAzo=; b=jr8B7T0FD4nZNxSPBSrfk5uWnW /JgcRQLDzNo0h/4eAA9jvAt3sVcDob499BCgH+x0D9oLp7+e8vqhqsXksJN17elP N1fNG9aCcFKJ+601rmYdwlTj+1iU7nCm4rPLU9yy6I9prPFBNaV3pHXa/aHt5RjI hsy+jZ49iDuktyOcphF5TVKIDeWhM1dWERD2s83Qm9JJQZfBCvbsu1V7GWuESEjP NJDFZDLxPIKsNEir6ncvEQABhLnZFkaILHtNoM1MiC2Z7yYblzWRD+UoAcfE3Nin DFcOMt6Xn7VhtiHcigLYOJc4YXqkHoPzEnLRzvKhSIjImlqZJytPRtBGtixQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1794282778; x=1794369178; bh=Z0julapMYN/lwyHSyUPFZz3nOjtbuqZ3p8S kr/yTAzo=; b=U8h3FHYqGh4JHxCO0QBMo1cJ0ab+eBdWusHoj8uy3t3G9N6+UH+ ttR+KPnUutky8uAf5pZBUuXzj3YDORITZn+EcHmErCWr/L3GwmdSDt0Uq32Ehp83 vNCWKgrX+2xP36vQt2vTQ37Aart2QplGv8xyNz97u7AsPR2BOoy96Tgj72+dfBE5 PuIaRA0L5iYQrAvQrRG+lyGGkb7vTGpdElJ6d+7Nh1QnKt00EtI5x8c5ljs+OYAT abB3QZnJJ6aXCBKzOt7jzv5B2k/6vd0f+EcbqanRAswWfuDV6dZLZgIPTUa4HGGd q5G7oKcCJw4BwakmJTxvX9BKXxN9mt7Q2kQ== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-09; repo=github.com/dkim2wg/interop; date=2026-11-03; sw=lmtpprox; action=sign d=paquier.xyz a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1794282778; d=paquier.xyz; mf=PG1pY2hhZWxAcGFxdWllci54eXo+; rt=PHBnc3FsLWJ1Z3NAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm3:rsa-sha256:M78YCDGC9iKtO8x5yYELKPwcXTfBQKYg9FFs0oOFVDzy7gE /3aP+tPirHU21DmenavaNz8fZPnTheU3tmewNSnn6yYCiq6ga0OoTIqP1EUCAAZg 3zh7Wz6QQosmpQfrGBslswIkYGZC6DKQccOmJfnIhX6cYI2fHnVrhfAsWXazdyIA 8Ev7sBOc2MX4fNvWrJeHnrKAYblW7moTBa/9CCqYBtGVCyhG8HfLgtEhgE94bQfU F+icbWrIp1G7lIe4AaXB76+CAoLQ+b0XMz0KV3jCorG5055DvIlwm5Z3mCRsM89x VxZiFPNjzMk1VLqI+xBA/tWnWYHTBDzuRBHO9rw==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-09; repo=github.com/dkim2wg/interop; date=2026-11-03; sw=lmtpprox; action=mi-m=1; hc=12; hn=cc,content-disposition,content-type,date,feedback-id,from, in-reply-to,message-id,mime-version,references,subject,to; Message-Instance: m=1; h=sha256:R8j+rqWYcermVOvoSqpthUdzFI8nSstEvZFEutd+fco=:vG+HGnI/nMVpMW2dkdMZ9ECzArdUdeefa27ibXSoFHo=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTGgTs70OE4eGOc4rcLPIm+L9d6zQK8kGMepEJYY2ab9Y/Tqkmh2PJ2Bo9gWK+2vcK hXYpkgMJZlLI1S8GsBxmAKtBxGfgQhSLyp1JT4tUgG9r+crGWjstTeTuwMa0Zxx3iWCaIa f/hiI0og6ESGErUgoPt/VaXI2Ex5LZpwHDVPaUwE34YtM5dc/d9U8cQ4ZssnuzRHFziOyU uA9Rrbh7dcfiQcj4GxXYHrlMNzphsuS8nGxbSVZJq4KUWtWLKP0yg4CkaBAvFGUcs71dvd pGpzwi1mpN4Vs8adE4x8oyg0N9g3fTA0GLk2AdeE4j7ivUCEHHQzCxnmkWV/wa2j6SoLhN hKxhIzciGfS0unxaR5lqnbWqtIbeo0l7efWbfcD4C7GjKmaHk4Y0s5ZW3PnJUZk9NPFsx3 +SE/gqJ9SenlQCLaG6ymwy+OgUENINqY09Yys5/BKz7+GWWbUc/zVy4+0q3eoWbkYTKz7G a3D2JAXXk8G/n3iQ6UHX1/EhAC9ZJB0ezeG5seLCTVb5xYOGjdv3MKoac3Te9LSXklSfZ4 GlnbhzCdalftCa70Q13RACcMmZmFf6v1mAxjlAXZ4tRzSa1PudpkoEAkZ3nh4tM52+Z4u9 va0lH5YtaA8W4Q8iAvg396ecWsxI50xhh0pL1z3dOp9lEgk4eNXNsKkmH7dA X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 9 Nov 2026 22:52:56 -0500 (EST) Date: Tue, 10 Nov 2026 12:52:52 +0900 From: Michael Paquier To: Corey Huinker Cc: 303677365@qq.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19842: pg_restore_extended_stats() rejects a faithful pg_dump of ANALYZE-produced range expression statisti Message-ID: References: <19842-ca042326dd2430a4@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="QRktcUQiZsSuqUul" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --QRktcUQiZsSuqUul Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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 maki= ng > the same (stats->numvalues[k] > 0) to (stats->stavalues[k] !=3D NULL) cha= nge > for extstats as was made for attrstats. Yeah, we need to fix that first, I think.. =20 > In addition, we need to complete decouple found/notfound checks for > range_bounds_histogram from the other two, as all of those "must be paire= d" > checks are for things that share a stakind. >=20 > I'll toy around with some workarounds for the '{}' case and get back to y= ou. Okay, thanks. I'll probably tackle some more issues that are assigned to my head first, which should take a couple of days. -- Michael --QRktcUQiZsSuqUul Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmrylRQACgkQnvQgOdby QH1qxA//YUDa4WZ3H2jjGkygPgX1qi3mTNAEj9bbRz9qUDZoVMnJ11b0yekqE3S4 45JXPFS+uTvVn+vvEegdJ33ZHn3szegLf1c0+5osi9zXT59i+wQcWQhzIS/t8817 M0SgZaJ3ZWBBjUhnEARmOvK8ygklhXMQSe4cK3dXtodczdmpH/By9BS0R+/rbbac DbfT4pDdtms+cZclTRBBUbGF7owXL9ecznLSufrLIl5QQr0QR1aFfdIScd8asv88 yjUsI2P47J1RCE7mQ23zaiMqA6dcGcNgb9thihsNU0/qQtHJUetSPqLFzn7akXG8 5MR1GjEjD/lsAwVQFKl7I8U4uICpJcZnvXWNSDy5yg9uzmGDwerDD9MYoHOwYJFL lK2MTt1iNuNXfIClVkRMWRMi4z1jd9BtYc/TbJ0a7tAVxSdLsZT9Vh+2EwrjKU3L q8Xkz65fYaF6gnULMGII5qCpYKvxT1ZuFSMPlabDHf1ZNeU+8z51cfTW9h6DaD6h lY2iyIUTNaJprAz3Rqc18DtV7ZKqvVAqgB0dJOkVzLnuD36kvoa3DBOUs73FL849 croxzgqle5ITR/NhDu0jG8L0XqYIA6lJDvIsWcCtJ+2Q/GQMhtZzefKRXvdiktyR hdEttaLESVNhThXbbE3rBIp2yd0jIhubOZl2pTCTq3h42/6GNzQ= =6ZX/ -----END PGP SIGNATURE----- --QRktcUQiZsSuqUul--