pgsql: Improve handling of SET ACCESS METHOD for ALTER MATERIALIZED VIE - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Improve handling of SET ACCESS METHOD for ALTER MATERIALIZED VIE
Date
Msg-id E1nVW7G-000OyR-F7@gemulon.postgresql.org
Whole thread Raw
List 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(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Add regression tests for ALTER MATERIALIZED VIEW with tablespace
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Fix an outdated and grammatically wrong comment