Request a Demo
Home   >   mailing lists

Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint - Mailing list pgsql-hackers

From jian he
Subject Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint
Date
Msg-id CACJufxGDEVdu9DCfePAsJ2JMxnQJuceCbhjUWLmt5ePUO8fZxg@mail.gmail.com
Whole thread Raw
In response to Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint  ("Matheus Alcantara" <matheusssilv97@gmail.com>)
Responses Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint
List pgsql-hackers
Tree view 
On Wed, Jan 21, 2026 at 2:48 AM Matheus Alcantara
<matheusssilv97@gmail.com> wrote:
>

> 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
>

sure. please check the attached.


--
jian
https://www.enterprisedb.com
Attachment

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: CREATE TABLE LIKE INCLUDING POLICIES
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: Assert the timestamp is available for ORIGN_DIFFERS conflicts