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.96) (envelope-from ) id 1w00A0-001WAR-0r for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Mar 2026 16:42:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w009y-004gHD-1V for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Mar 2026 16:42:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w009y-004gH4-0V for pgsql-hackers@lists.postgresql.org; Tue, 10 Mar 2026 16:42:18 +0000 Received: from mail-dl1-x122b.google.com ([2607:f8b0:4864:20::122b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w009w-00000001zsD-1fTT for pgsql-hackers@lists.postgresql.org; Tue, 10 Mar 2026 16:42:18 +0000 Received: by mail-dl1-x122b.google.com with SMTP id a92af1059eb24-126ea4e9694so157059c88.1 for ; Tue, 10 Mar 2026 09:42:16 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773160935; cv=none; d=google.com; s=arc-20240605; b=TvEYgs2BTfv5oEdrqFUU33P5nsXEBMFNXXVYfcHpCVHCHcIQlzp3NMrLJa3X57sC+y 03d0Z1Y/cyRMmuW82OeckX9ge9UnS8hBFUjUun6LZDLIUnrUfsctubx0+uyhGxFH1Yl9 Lt9EBUYtQiTGtPzqPx3ucf+rCePYwBRxrebQ98bpKg3N/Ez3rIj1ffssmxMlSGUl5C+B 2LltGMBXKfjjF1q7mEogaXYUIo9qjVEKXr9Z3thHOHY1mLVwv9NJl2Zs2+FzCF/Vwgdb pPfIU4dChVTPYm+pepUPC57XU187dnmcb4gy0DYYn5JdCrkWTT3+S2OTbjHYGcBjd8Li fH6Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=EZcCuOCwLNiHboI9CcY762kE+IJgbHpb5l4n3wQgodo=; fh=Hjvn/RiRbWHpS8I6RuMZ7LDe+IlLxz2EL7oC6+R9Bes=; b=BCE7NSJ/Iw1S0MjBVtSb0GOE7aWs/02BxMF73lkcn+MGwawngZOB7s6Y7AfD0NqKMl 2AP+yjpML4cLAAXLl9kzLGoJzPrvpWPvLq823iHaT74Vh3xxXrG52Z0cY8w/aznBnJnG chDE1Xp9uSKot77WyxiHz0GhswcxDchSw7D+rkKgN2h/vujx1NJ1PPq16y+zpwns1jwg 4e5b786IVwa/mSp9gLyhsvxCE5CIvUE9xMvrJIbNmnfDd2k3zpkv/3WF97Xsdtrmpn7U Nw47c0lEvIe4W4Grnt6z5PmXXStZxSfHM/nlZ7gSo6wlRmw3XINTQHPLBZQdZ2Xu+2A9 Nu+w==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773160935; x=1773765735; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=EZcCuOCwLNiHboI9CcY762kE+IJgbHpb5l4n3wQgodo=; b=Iy2D3sARjsjto1sqPwHcgzMjgZ1T+KOlQ/lF/Wsu6y49J/4UvY0DEnjq1eHSy0l4QM BZCEtqPgSP9QlGSHCM4GAZkW7fV4d3szEosGAEShYMx5AcWUmym1atSlTZXWmFUuVhOw zLyTvUX0xGJDVfHw/yoHnh4qVaZpDuY/rQh3/25UUaz7+wV3YmexKoxtWFZw+P9GEhq+ fdu1M4rcoJjaEZ440GM0Tp4Wz7osCjNZNgjNM7sSGz3oKHbJULoqdm+M7fZen8Qf71Uo KtugrnpH5JF/W06XjZy4HVSoO2Zrp/8LyRvmVYvIn+T2PT4IHgvhBwbubPuFpbnkUgph dXZg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773160935; x=1773765735; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=EZcCuOCwLNiHboI9CcY762kE+IJgbHpb5l4n3wQgodo=; b=EY9YzsZIYyD2Y6xQkbeBF1Fd0WUTEt3LEcWupDm3Cd7rnZUTb8ZcZLh+BdrjVScyMR FcfNjuiNnxYF9bH7QGSsLO5oXDDwnLXuX0kl6dy5yG5q3mQ+9wExuCwj7X25OqUfULMI ewh75NAaA9Rjakvcs+XWk1k5wueMr4I6T+vs7Jx3izjl7umHLWLoyR1QHVVKiXvsx3BE ZVQzwkwTPOZv1/BkdD/ocpQOdy2WCefS1Lj/yLtD58echbl5pnxaXqYd5hTQqasqboiD Zb+2zeMHxYFpCqpeUcfHVXKUKdcU9svqoMV6qNpKUnPSwHyJ7G1MDJTQ1Hib50/GAa8r 8I6w== X-Forwarded-Encrypted: i=1; AJvYcCVjLTX5ljo5MQSgknYdZriAS3qk4bg5Z3H78sZiYBMRPwmAmN8sQvvO2K5YnHGJjTHXaM4ySXJT1jirHTW1@lists.postgresql.org X-Gm-Message-State: AOJu0YzaCNifv9sp3jOC3mrbqDudEN33TVR2RZTwITioTH/2rCF2i5Kp m0HV7T5W/03OaLEeQ1hY0IZ2bVSmqwkY2uM91N/Dz5e/pneTRMh9EyuAnJvv5cq/7tY2c67hNGf P/hIumVi2Hsaizm+G4M4FlvsMak9z12PVow== X-Gm-Gg: ATEYQzzTn9Osa8kBzWv7q2qoR4yEQ4oWkbJ43PdCBlMadoJ8vtGI/5etGa5pkEhsCn6 KDDYfyMvcJUPo4cuchEmNsLmihEFmxtJtCCtLdSdxu6MQFyH5oUhBbIKbBBeRyjal91rySvptY4 BhMDATU8vXJBYzJYGZafCWXdoaDiwvOyghZYQ02w5vBVAZP+R2Rn/lVSFBQXjacd5LE6+GOIQnJ S+syLkyUKzIXbxBDYdmxdjCxVkrnHnK5uf14BQK9UyVqqs90/ZsdN4+a59wzR/5jIFTcVwmqCrV hQcX1vrNxVURzQOtZk8/uFors47fPpi0PC9gpAHOTq1naDUlSVhrojGG9quJl7q98iDfkvw2CJ0 7pqOCoNf+iH74ISVqIX/XqEMe X-Received: by 2002:a05:7022:ea27:b0:11b:ca88:c4f7 with SMTP id a92af1059eb24-128c2e87224mr7638161c88.40.1773160934502; Tue, 10 Mar 2026 09:42:14 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Corey Huinker Date: Tue, 10 Mar 2026 12:42:02 -0400 X-Gm-Features: AaiRm52BouXr70QV-MVWbEchOwjYZx-ywl_3XrLNHkbRj7wGrGLai6O6Vxy_a5g Message-ID: Subject: Re: Add starelid, attnum to pg_stats and leverage this in pg_dump To: Nathan Bossart Cc: Sami Imseih , pgsql-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000a17821064cae336c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a17821064cae336c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Mar 10, 2026 at 12:37=E2=80=AFPM Nathan Bossart wrote: > On Mon, Mar 09, 2026 at 06:42:46PM -0400, Corey Huinker wrote: > > If you want 0003 split into two (one for pg_stats_ext and one for > > pg_stats_ext_exprs) I can do that, but they felt like a package deal to > me. > > Sorry to throw a curveball here, but I think the best way to structure th= is > patch set is as follows: > > * 0001: Just the test changes (e.g., replacing * with column lists). By > doing that first, the actual functionality changes in 0002 will be easier > to see. > Makes sense. > > * 0002: Adding columns to the all the views (this one will do a catalog > bump). If we need to make a couple of test adjustments to verify the OID= s > or attribute IDs, that's fine, but those can be pretty minimal. > So all three views in one go. +1 > > * 0003: Associated pg_dump changes. > On it. --000000000000a17821064cae336c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Tue, Mar 10,= 2026 at 12:37=E2=80=AFPM Nathan Bossart <nathandbossart@gmail.com> wrote:
On Mon, Mar 09, 2026 at 06:42:46PM -0= 400, Corey Huinker wrote:
> If you want 0003 split into two (one for pg_stats_ext and one for
> pg_stats_ext_exprs) I can do that, but they felt like a package deal t= o me.

Sorry to throw a curveball here, but I think the best way to structure this=
patch set is as follows:

* 0001: Just the test changes (e.g., replacing * with column lists).=C2=A0 = By
doing that first, the actual functionality changes in 0002 will be easier to see.

Makes sense.
=C2=A0

* 0002: Adding columns to the all the views (this one will do a catalog
bump).=C2=A0 If we need to make a couple of test adjustments to verify the = OIDs
or attribute IDs, that's fine, but those can be pretty minimal.

So all three views in one go.=C2=A0+1
=C2=A0

* 0003: Associated pg_dump changes.

On it.
=C2=A0
--000000000000a17821064cae336c--