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

jian he <jian.universality@gmail.com>

From: jian he <jian.universality@gmail.com>

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-04-24T02:42:31Z

Lists: pgsql-hackers

Attachments

v1-0001-generated-column-set-expression-with-check-constraint.patch (text/x-patch) patch v1-0001

On Tue, Mar 11, 2025 at 12:17 PM jian he <jian.universality@gmail.com> wrote:
> hi.
> in summary: ATExecSetExpression, RememberAllDependentForRebuilding
> will do all the work to change the generation expression,
> whether it's virtual or stored.
>

while working on another patch, I found out this can be further simplified.
Thus a new patch is attached.

Commits

Allow ALTER COLUMN SET EXPRESSION on virtual columns with CHECK constraints
- f80bedd52b15 19 (unreleased) landed