Horton

Improve handling of SET ACCESS METHOD for ALTER MATERIALIZED VIEW

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: eb8399cf1f3dd8ad02633e3bb84e2289d2debb44
Author: Michael Paquier <michael@paquier.xyz>
Date: 2022-03-19T10:13:52Z
Releases: 15.0 
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

Files

PathChange+/−
doc/src/sgml/ref/alter_materialized_view.sgml modified +1 −0
src/bin/psql/tab-complete.c modified +5 −1
src/test/regress/expected/create_am.out modified +26 −0
src/test/regress/sql/create_am.sql modified +10 −0

Documentation touched

Discussion