ALTER TABLE ... ALTER COLUMN ... DROP EXPRESSION

Enterprise / PostgreSQL - Peter Eisentraut [eisentraut.org] - 14 January 2020 12:36 EST

Add an ALTER TABLE subcommand for dropping the generated property from a column, per SQL standard.

f595117e24 ALTER TABLE ... ALTER COLUMN ... DROP EXPRESSION
doc/src/sgml/ref/alter_table.sgml | 18 ++++
src/backend/catalog/sql_features.txt | 2 +-
src/backend/commands/tablecmds.c | 161 +++++++++++++++++++++++++++++++-
src/backend/parser/gram.y | 20 +++-
src/bin/psql/tab-complete.c | 2 +-
src/include/nodes/parsenodes.h | 1 +
src/include/parser/kwlist.h | 1 +
src/test/regress/expected/generated.out | 87 +++++++++++++++++
src/test/regress/sql/generated.sql | 38 ++++++++
9 files changed, 326 insertions(+), 4 deletions(-)

Upstream: git.postgresql.org


  • Share