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 1w005E-001W6q-0E for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Mar 2026 16:37:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w005C-004eHK-1S for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Mar 2026 16:37:22 +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 1w005C-004eHC-0U for pgsql-hackers@lists.postgresql.org; Tue, 10 Mar 2026 16:37:22 +0000 Received: from mail-pl1-x62d.google.com ([2607:f8b0:4864:20::62d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w005A-00000001zqT-0rq9 for pgsql-hackers@lists.postgresql.org; Tue, 10 Mar 2026 16:37:22 +0000 Received: by mail-pl1-x62d.google.com with SMTP id d9443c01a7336-2ae505619baso58112905ad.2 for ; Tue, 10 Mar 2026 09:37:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773160638; x=1773765438; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=c7LZbLGkIWh8GzLu5OoxQ2PNRL+1DfBqBVIYLbDuRW0=; b=RI3Si90UFr6vkjV3Fzww6go89+Do0+PyTio70ORn29GKa5VzYAi9fISpN+nCrtbire cBXvP28Wrh70GEgYsjtD7nAl33jT0Xsk8q46L4IS46keVEJQxuvYf4BAmumSM7p7TsC7 8vBxFRADvL4LNJ9c+aVf3F+D4yGVhEWDnK0+R/DgkxLn9mF1bu/VcNagRJgIzae0ei9l o0H+lLx+Mm01kH4ohqcjQ/8vMYhNrT1JuyZUulw9xZyZFuFG1oiNIWLBtd5nNnWGu6lk 5aGx64VeFDHzEUzzvza9OfAStAe1I/fLvFvfdZ6qXJ0z8pYO4f8jY78n3ANtRCfiLAHu euYQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773160638; x=1773765438; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=c7LZbLGkIWh8GzLu5OoxQ2PNRL+1DfBqBVIYLbDuRW0=; b=QStiwtO5Z3YIFhEcqkMTn1P1hcULpf4vjIa22j4StoqPjP+W0lVedkQ8bzrj4pzKiW Wi91hkdJ7gImi3Fvwn/RHc1OWJdzQ63OBj2Q9TXZh4gXDYVJr0LtG6ivggUAh2k7Gza/ IHOaIwg0WWzrGnxM3fSgnCfvqqfzjIVL2YUVloDH6V5POUg0zP25JDuYSsL/3GkNFzZA yW8SpbLwEvXjTqhVSddvrStt5g0vgszIT67GhsZC4aRFBAV6V1m/i99RlIBo2tqlvx8z cHeSHn2D2Y7z0GIYEQsf9GXJH1ygCSEfkyCXwYSH14wgdcbn/cpXHzgkkd1LqE62OrOy Mk6Q== X-Forwarded-Encrypted: i=1; AJvYcCWgBJ5fheh8Ev3A8wW6ZiRIQqqs9cSiY3OZmFA6HKqa04N3s1b2e2JW5U0UdU9QhG66tZR+4ZW5rWfRn9Lm@lists.postgresql.org X-Gm-Message-State: AOJu0YzhBmEH32586HyHJwAPILKkDzG/51u3fezBP/PdmNv3xhRIDlDV 7dXCoBJ4/kSzqwP9eoE3gj6G9GQtf+6+N1pAdjucHfmWszu8HsPvjov+ X-Gm-Gg: ATEYQzz1DTUgSoorUgO09M1j6iFFpKKLfi7vUgLjZFNc/DK9ceiF7z3R7YGjW3qLvcW HQn6fidvixH2x9TN6GxQ/3ZpwgM8JKQkIB/Ar+17s1Mo2tOTpMO9gT5RtGfCVISPjwQyjyKPd1L wf1+sz6Id8U/4OO+K8bLC1eDBMODXu9/DRiehB+bK+GR+faXUC+9XoIdwGhzCMFUhAiUdNE7eXu FluEuDAiZfp5KlJP+Ve3Tjj8myXL6IB9VRc+ukAAP2HBhhEnNvCvsj0Z6ARBqw+Te4YE9PAPICN v/AV1pOaUVBxyEVZowkEvxHmT3PcbX0eyEOcSXCNFtNHZFkY0BvLnA1vGLBXzs9waQ69d6XqDuu nNNYHo6ukpLAqCkHegqtdE9uldw62DHbD/GQ8LUsif8m6sxAFcGXlD5yiQC/6N1XBKdJHjZL4Sw Y5U0dwzLVOFDMNnYaePnRTMeAUgAriQJmpLG3No6pMf4KMGcyuxp0VpbK9onvyghZpQ4//Ha2MM ip9xQ4ws/x+hWmLjcbYDg== X-Received: by 2002:a17:902:d54f:b0:2ae:422d:6ed1 with SMTP id d9443c01a7336-2ae823feba6mr143398005ad.10.1773160638000; Tue, 10 Mar 2026 09:37:18 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-2ae83e78f77sm228203795ad.21.2026.03.10.09.37.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 10 Mar 2026 09:37:17 -0700 (PDT) Date: Tue, 10 Mar 2026 11:37:15 -0500 From: Nathan Bossart To: Corey Huinker Cc: Sami Imseih , pgsql-hackers@lists.postgresql.org Subject: Re: Add starelid, attnum to pg_stats and leverage this in pg_dump Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 this 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. * 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 OIDs or attribute IDs, that's fine, but those can be pretty minimal. * 0003: Associated pg_dump changes. -- nathan