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 <[email protected]> Co-authored-by: Peter Eisentraut <[email protected]> Reported-by: Ayush Tiwari <[email protected]> Reviewed-by: Ayush Tiwari <[email protected]> Reviewed-by: solai v <[email protected]> Reviewed-by: Zsolt Parragi <[email protected]> Discussion: https://www.postgresql.org/message-id/flat/cajtyswxokyedvbzymwc9skrq7y_muv6xjxn4h9gfsbopd3n...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/a4639d64e2199885f8e995395b6fe874cb7228bf Modified Files -------------- src/backend/commands/tablecmds.c | 176 ++++++++++++++++++++++++ src/test/regress/expected/generated_stored.out | 9 ++ src/test/regress/expected/generated_virtual.out | 9 ++ src/test/regress/sql/generated_stored.sql | 10 ++ src/test/regress/sql/generated_virtual.sql | 10 ++ 5 files changed, 214 insertions(+)
