]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Whole-row fixes for ALTER COLUMN SET EXPRESSION
authorPeter Eisentraut <peter@eisentraut.org>
Wed, 8 Jul 2026 16:44:54 +0000 (18:44 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Wed, 8 Jul 2026 17:40:27 +0000 (19:40 +0200)
commit9530898940302d6f501fb54a3fbc61cbfb7768bf
tree3396181330ca97a6324b1f138f8e159b786ef757
parent165dc09b28619510d9ab0034fdfccfb7af5422ae
Whole-row fixes for ALTER COLUMN SET EXPRESSION

When changing the expression of a generated column via ALTER TABLE
ALTER COLUMN SET EXPRESSION, objects that depend on the column via
indirect whole-row references (such as CHECK constraints, indexes)
must be handled specially, because technically pg_depend does not
contain such dependencies, see
recordDependencyOnSingleRelExpr->find_expr_references_walker.

This is a fix for commit f80bedd52, "Allow ALTER COLUMN SET EXPRESSION
on virtual columns with CHECK constraints".

Author: jian he <jian.universality@gmail.com>
Co-authored-by: Peter Eisentraut <peter@eisentraut.org>
Reported-by: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Reviewed-by: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Reviewed-by: solai v <solai.cdac@gmail.com>
Reviewed-by: Zsolt Parragi <zsolt.parragi@percona.com>
Discussion: https://www.postgresql.org/message-id/flat/CAJTYsWXOkyeDVbzymWc9sKrq7Y_MUv6XJXN4H9GfsBOPd3NJ+w@mail.gmail.com
src/backend/commands/tablecmds.c
src/test/regress/expected/generated_stored.out
src/test/regress/expected/generated_virtual.out
src/test/regress/sql/generated_stored.sql
src/test/regress/sql/generated_virtual.sql