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 cd1443a4-f441-4ac5-8ecf-791fd3a5bab0@gmail.com
обсуждение исходный текст
Ответ на Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint  (jian he <jian.universality@gmail.com>)
Список pgsql-hackers
On 21/01/26 02:10, jian he wrote:
>> +      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..."
> 
> sure. please check the attached.
> 

Thanks. The patch is in a good shape for me, I don't have any other 
comments. Perhaps we could move the CF status for "Ready for Committer"?

--
Matheus Alcantara
EDB: https://www.enterprisedb.com



В списке pgsql-hackers по дате отправления: