ALTER TABLE ... ALTER COLUMN ... DROP EXPRESSION
Peter Eisentraut <peter@eisentraut.org>
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: https://www.postgresql.org/message-id/flat/2f7f1d9c-946e-0453-d841-4f38eb9d69b6%402ndquadrant.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/alter_table.sgml | modified | +18 −0 |
| src/backend/catalog/sql_features.txt | modified | +1 −1 |
| src/backend/commands/tablecmds.c | modified | +160 −1 |
| src/backend/parser/gram.y | modified | +19 −1 |
| src/bin/psql/tab-complete.c | modified | +1 −1 |
| src/include/nodes/parsenodes.h | modified | +1 −0 |
| src/include/parser/kwlist.h | modified | +1 −0 |
| src/test/regress/expected/generated.out | modified | +87 −0 |
| src/test/regress/sql/generated.sql | modified | +38 −0 |
Documentation touched
Discussion
- ALTER TABLE support for dropping generation expression 7 messages · 2019-12-09 → 2020-01-14