Re: Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only
Date
Msg-id CADkLM=ceJpMmq-wO5=FkPLMUo01aWW=FJvP37YDdWjMHXJnbFQ@mail.gmail.com
Whole thread Raw
In response to Re: Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only
List pgsql-hackers
On Thu, Aug 21, 2025 at 9:56 AM Nathan Bossart <nathandbossart@gmail.com> wrote:
On Thu, Aug 21, 2025 at 11:13:44AM +0900, Fujii Masao wrote:
> On Thu, Aug 21, 2025 at 4:19 AM Nathan Bossart <nathandbossart@gmail.com> wrote:
>> Nice find.  I would suggest adding the virtual generated column to
>> regression_vacuumdb_test when it is first created so that we can just rely
>> on the existing test cases.  In fact, by doing so, you'll see that we need
>> a similar change to the "inheritance and regular stats" part of the query.
>
> +1

Since we're running out of time for v18, I went ahead and updated the
patch.  I've also added an open item for this.

+1 on the fix, works for me.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt
Next
From: Nathan Bossart
Date:
Subject: Re: Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only