Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint

From: Matheus Alcantara <matheusssilv97(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint
Date: 2026-01-21 19:26:14
Message-ID: cd1443a4-f441-4ac5-8ecf-791fd3a5bab0@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2026-01-21 19:30:14 Re: Remaining dependency on setlocale()
Previous Message Robert Haas 2026-01-21 19:26:02 Re: pg_plan_advice