| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: ALTER TABLE ... ALTER COLUMN ... DROP EXPRESSION |
| Date: | 2020-01-14 12:45:23 |
| Message-ID: | E1irLZT-0000yx-R3@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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(at)zsrv(dot)org>
Discussion: https://www.postgresql.org/message-id/flat/2f7f1d9c-946e-0453-d841-4f38eb9d69b6%402ndquadrant.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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2020-01-14 13:57:34 | pgsql: walreceiver uses a temporary replication slot by default |
| Previous Message | Dean Rasheed | 2020-01-14 09:58:06 | pgsql: Make rewriter prevent auto-updates on views with conditional INS |