Horton

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

Matheus Alcantara <matheusssilv97@gmail.com>

View thread View on postgr.es
From: Matheus Alcantara <matheusssilv97@gmail.com>
To: jian he <jian.universality@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-01-21T19:26:14Z
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

Commits

  1. Allow ALTER COLUMN SET EXPRESSION on virtual columns with CHECK constraints