pgsql: ALTER TABLE ... ALTER COLUMN ... DROP EXPRESSION

Started by Peter Eisentrautover 6 years ago1 messagescomitters

peter_e@gmx.net

over 6 years ago

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

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

Reviewed-by: Sergei Kornilov <sk@zsrv.org>
Discussion: /messages/by-id/2f7f1d9c-946e-0453-d841-4f38eb9d69b6@2ndquadrant.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f595117e24a79db6072979ab5a757431fd17232f

Modified Files
--------------
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(-)