Re: Add starelid, attnum to pg_stats and leverage this in pg_dump

From: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
To: Sami Imseih <samimseih(at)gmail(dot)com>
Cc: Nathan Bossart <nathandbossart(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add starelid, attnum to pg_stats and leverage this in pg_dump
Date: 2026-03-12 23:54:17
Message-ID: CADkLM=fn=RmBD0-h+yjTxhpLtbK9s_QdvT-HsGtUj+-1N=6s0g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> It will be good to add more commentary here to the next person adding
> a test, and mention
> that only stable values should be included in this view. what do you think?
>

I added a comment, but I don't think a test writer would be confused for
long if they did break that rule.

>
>
> + (references <link
>
> linkend="catalog-pg-class"><structname>pg_statistic_ext</structname></link>.<structfield>stxrelid</structfield>)
>

Fixed catalog-pg-attribute and catalog-pg-statistic-ext

Attachment Content-Type Size
v6-0001-Add-test-view-pg_stats_check.patch text/x-patch 13.9 KB
v6-0002-Add-tableid-statid-attnum-expr_attnum-columns-to-.patch text/x-patch 78.0 KB
v6-0003-pg_dump-Use-tableid-in-getAttributeStats.patch text/x-patch 8.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Henson Choi 2026-03-13 00:53:39 Re: Row pattern recognition
Previous Message Alexandra Wang 2026-03-12 23:45:49 Re: pg_plan_advice