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 1xRKyQ-00000000ss6-2oFR for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Nov 2026 02:55:38 +0000 Received: from localhost ([127.0.0.1]:36160 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xRKyO-0000000ERNO-3Sm7 for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Nov 2026 02:55:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:45844) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRKyO-0000000ERNG-038z for pgsql-bugs@lists.postgresql.org; Thu, 12 Nov 2026 02:55:36 +0000 Received: from fhigh-b8-smtp.messagingengine.com ([202.12.124.159]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRKyM-00000000TVY-2Tco for pgsql-bugs@lists.postgresql.org; Thu, 12 Nov 2026 02:55:35 +0000 Received: from phl-compute-07.internal (phl-compute-07.internal [10.202.2.47]) by mailfhigh.stl.internal (Postfix) with ESMTP id 10B0A7A0203 for ; Wed, 11 Nov 2026 21:55:33 -0500 (EST) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-07.internal (MEProxy); Wed, 11 Nov 2026 21:55:33 -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=1794452132; x=1794538532; bh=PoSHyhTb09 Cy6yWddStifOhLME+May7r3BCz2ceWQq0=; b=KIWlTKTozlD3rJrGilzH1/C0b0 SoLQh0j1C36hn81tvq41zAdNUzZEIqQgu11WkzIg6s6VDLEMK12+OqBtOJXzAyuS st3xZ5DO7OsFaTFxHLjcHYwXXq7XKrQFKro1xT2s02L1gbF/kdVaiIqaJpnz1hn2 z0jfR9P/jDgljEcpfaq+IEW1rTQWHHVEs+Vb6FERg8phSuIAjC3a/UZD0MHXGDC/ q9B2FSIwBoAFcLee9UPxatfFZoY4CkAHue1Lcj8SJZK2EooH4+yvmFY8YWw7NU50 dcvL2YHr4sDEtksLqPunrG2UUqjk3YyD36wBLO+5guKN8YXdOIpinma2o/eQ== 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= 1794452132; x=1794538532; bh=PoSHyhTb09Cy6yWddStifOhLME+May7r3BC z2ceWQq0=; b=UL2Xpgl5KsPmxXufWcWUnFVkyZf4pFhM2Uk1WN1elzGw0UCe2JO mW5IzWXuL3WOIYegid8DLya5VZEI8XL0YQjCvYPJ8CjtDn04LIlgxXOwyi8Dcsed 6yTwXyZkebSv7IM9vP4LpfIXP9w/oEyQPTwEVaBsPf3SNVYdJ9I9ohh+guQUlqeS h2GLLCfwvH9rVEwMGWFfPrF3CBiehdlokQg1zgFlCTQtW75HOOZlrXuWXjijYPVc DJD18zzZz+yV08KIFi/YO//gqm0LMQPc8uvMY8nyf8CZWQQjrFqr2/VMIDV0v63B +GzoT5D3Bss9IViLuG109ULEjnPR7xLBvvQ== 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=1794452132; d=paquier.xyz; mf=PG1pY2hhZWxAcGFxdWllci54eXo+; rt=PHBnc3FsLWJ1Z3NAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm3:rsa-sha256:D9qUV47QZN4oOEXKWibakf+DnurIq5UPY+PZvh1gHsu3H+S TH4RmNQiAsFyIs9cdk1jFlCZf2QJJl/2LEOFmBWS/U/lttpziycYS76ZC9aeu/Ml OQ8oz6LXka7AehxdnD9RM1KkHvX04cekBmJd8j39eANi0kN025G7dX3IXqkpMUvw tpLd95Ze0CUSRD4aBwdY5A5f2z+dQRlZ+fsGTIi27jlZsi4ad70itUlNHxRg8Jx+ x9s2+sdCuQaJWR56FN3yZjz6l0p4VaP3NLPou0h6A+TM3wUAhWckLQ6Jux4VlLH0 3fs7cfPlCAZjBuDxucG4L7/5dr42leoTJ440cJw==; 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:xMmChfbeEBi9JOtrQl0YbFTPYpNObVfkJK9d9wt1p50=:4sH8q5H2FlwrVDyonmYb0xWnDqZQZ7VwImM/3/ZAxMs=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTENpahq35aqvtHcMxUUvgyJsQaQ9ae++6g2l5rXXHFxNTZuOXVI/qZfMkXCy6s4M6 D7JRMJ1C6uDzDzjK8CRVI+vX7GIAlH32tooItaKPZfICseyfyqLfLCVMHEpuQ6X+Xkz7KH +mpNAW9EBWY7RU5ozor5n5Z5Z4pTjZJ3nRLSmj5aVmAVMr/4pM/guqwhsgNCtw4Rl7LXN5 pRddDPnLQJRQQ70eLQxqK4P084k0KmWzUmFu3sUnk/JL+5Vro7sS1bOGDWh4c3hXfINAwC s3tw6vZGvKlRRiZltAC6jkjPlCZETheUbTQBa13psG8GDlizf/+HAEzlZgO73ApWJ1Swl5 Fsl7v+bVd1tIKiOnYBEtAX+JgEZ88gJvqTq4EGhQtPAex/zLX3VIlY9TF97ArM/LrHj/ed fKwb/27+Yqu4gZK77QsBO6rkzh9v6OZl3l62DNOhjKcOnXWYEXFQuTDbaT1bMLCfk8HSqT IYO7rZYDwGa1j8/W+UhQUBlpdONXIAy31RPKJ+FJjED1oV1Ng68OoqZZXXMNpu+k0B2hCk cbYBQhkemiLhxaCh1/AT622Zqq8/mpR76z7KOiu3MM6K8oksXLK+FbRof/lV1q/g5YRiIR ZcGFx+Wnh3uwP6ZgqGUVzv1watPBJMb/IH/4YDQ+oGT5PvPIigjmbg6MY6Og X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 11 Nov 2026 21:55:31 -0500 (EST) Date: Thu, 12 Nov 2026 11:55:28 +0900 From: Michael Paquier To: Rahila Syed Cc: 303677365@qq.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19833: ALTER TABLE that rebuilds an extended statistics object silently drops its SET STATISTICS target (st Message-ID: References: <19833-37de35b8f159e62a@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="qjrPtUNUyRVY6keS" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --qjrPtUNUyRVY6keS Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Nov 11, 2026 at 04:27:37PM +0800, Rahila Syed wrote: > ALTER TABLE st2 ALTER COLUMN c TYPE int; >=20 > SELECT i.indexrelid::regclass::text AS index_name, a.attstattarget > FROM pg_index i JOIN pg_attribute a ON a.attrelid =3D i.indexrelid AND > a.attnum =3D 1 WHERE i.indrelid =3D 'st2'::regclass; > index_name | attstattarget > ------------+--------------- > st2_cb | > (1 row) Hmm, yes, that feels counter-intuitive to not preserve that. > I will look into writing a fix for this. Cool, thanks. -- Michael --qjrPtUNUyRVY6keS Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmr1KqAACgkQnvQgOdby QH3FxQ//Qqt9qY9jJvY/PLprbLJcDMO62uIdNclShncqdsLeLr6pSDBudKPJqG0O /PRHXCnQvlSL3lqG3eMzBR979LYLMoruixKJTWnle6VeL01AkkKrP+IXPLTV8AXj QlwEb3MZkBoXhsQMiVM2rJ3QZ2K0jdoCByTdtajKB3jkIkF1isoEGxdPgo5+TT8w cXY1giUWXNCCuI7F1eqInVy2R6Mz72kcV3961MZFk51Q18sEVu9vmQ5xfky4NBnd DIl2O6gnlhmajstBOoNoPvVPIbg+e0weoCEryb1MVDVwgAkrB3sQDTYY6aGnObNi AI+JN+tmSDodtUrASJhjZ1wzrqfEqsStidk4DpHoINNV+ak27K0qe2QT4WQ2kBak CG46ZyM/vphS6rTeAbSB+d+1hqdKMJz3Gl0cdyzn2vzll6qfeBliOyHV8hlR2udc HgpvQ6FScx7cORnAmdNp/v2CecnPD+Vw0gwWSUkemoGSe8G4euiveWyDkzVIdmOz 0vCmEDR1H12XMHzEa4wNkKrNMfC47mjrZoiO6vGipYcrH2zPg1OqtI2+evHw12f6 t1da8tfRt619fS8DCqCDhl7dOuxVmMLnXe9sB7eA4kcPquyoIK5bKSsv/gSL/nWi IllhVU+8KNOjT2m6E5UqXm6iREri06EgRSqvoQRo6BghsQnXxLA= =o/q3 -----END PGP SIGNATURE----- --qjrPtUNUyRVY6keS--