| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Improve handling of SET ACCESS METHOD for ALTER MATERIALIZED VIE |
| Date: | 2022-03-19 10:15:23 |
| Message-ID: | E1nVW7G-000OyR-F7@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Improve handling of SET ACCESS METHOD for ALTER MATERIALIZED VIEW
b048326 has added support for SET ACCESS METHOD in ALTER TABLE, but it
has missed a few things for materialized views:
- No documentation for this clause on the ALTER MATERIALIZED VIEW page.
- psql tab completion missing.
- No regression tests.
This commit closes the gap on all the points listed above.
Author: Yugo Nagata
Discussion: https://postgr.es/m/20220316133337.5dc9740abfa24c25ec9f67f5@sraoss.co.jp
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/eb8399cf1f3dd8ad02633e3bb84e2289d2debb44
Modified Files
--------------
doc/src/sgml/ref/alter_materialized_view.sgml | 1 +
src/bin/psql/tab-complete.c | 6 +++++-
src/test/regress/expected/create_am.out | 26 ++++++++++++++++++++++++++
src/test/regress/sql/create_am.sql | 10 ++++++++++
4 files changed, 42 insertions(+), 1 deletion(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Berg | 2022-03-19 17:53:30 | Re: pgsql: Add option to use ICU as global locale provider |
| Previous Message | Michael Paquier | 2022-03-19 08:31:08 | pgsql: Add regression tests for ALTER MATERIALIZED VIEW with tablespace |