Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint
| От | Matheus Alcantara |
|---|---|
| Тема | Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint |
| Дата | |
| Msg-id | DFTN32P3FIIG.DMEXA0C6V6QG@gmail.com обсуждение исходный текст |
| Ответ на | Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint (jian he <jian.universality@gmail.com>) |
| Ответы |
Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint
|
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: