| From: | jian he <jian(dot)universality(at)gmail(dot)com> |
|---|---|
| To: | Matheus Alcantara <matheusssilv97(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 05:10:20 |
| Message-ID: | CACJufxGDEVdu9DCfePAsJ2JMxnQJuceCbhjUWLmt5ePUO8fZxg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jan 21, 2026 at 2:48 AM Matheus Alcantara
<matheusssilv97(at)gmail(dot)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.
| Attachment | Content-Type | Size |
|---|---|---|
| v5-0001-Allow-ALTER-COLUMN-SET-EXPRESSION-on-virtual-columns-with-CHECK-c.patch | text/x-patch | 9.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hayato Kuroda (Fujitsu) | 2026-01-21 05:22:41 | Assert the timestamp is available for ORIGN_DIFFERS conflicts |
| Previous Message | jian he | 2026-01-21 05:02:27 | Re: CREATE TABLE LIKE INCLUDING POLICIES |