On Mon Jan 19, 2026 at 1:11 PM -03, jian he wrote:
> I ultimately settled on the following:
> + Replacing the expression of a virtual generated columns do not require a
> + table rewrite, however if the column is part of a
> <literal>CHECK</literal>
> + constraint expression, the constraint will be rebuilt, requiring a table
> + scan to ensure that existing rows meet the constraint.
>
Thanks for the new version. Just a minor comment
+ Replacing the expression of a virtual generated columns do not require a
+ table rewrite, however if the column is part of a <literal>CHECK</literal>
+ constraint expression, the constraint will be rebuilt, requiring a table
+ scan to ensure that existing rows meet the constraint.
I think that it sounds better with: "Replacing the expression of a
virtual generated column does not require a table rewrite..."
--
Matheus Alcantara
EDB: https://www.enterprisedb.com
