From 49c5cd5c4e7ac408dc0ae64fa77b16a4e0c63c8b Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Sat, 19 Mar 2022 16:38:02 +0900 Subject: [PATCH] doc: Mention SET TABLESPACE clause for ALTER MATERIALIZED VIEW This command flavor is supported, but there was nothing in the documentation about it. Author: Yugo Nagata Discussion: https://postgr.es/m/20220316133337.5dc9740abfa24c25ec9f67f5@sraoss.co.jp Backpatch-through: 10 --- doc/src/sgml/ref/alter_materialized_view.sgml | 1 + 1 file changed, 1 insertion(+) diff --git a/doc/src/sgml/ref/alter_materialized_view.sgml b/doc/src/sgml/ref/alter_materialized_view.sgml index e27d38df19d..4b2e822d933 100644 --- a/doc/src/sgml/ref/alter_materialized_view.sgml +++ b/doc/src/sgml/ref/alter_materialized_view.sgml @@ -42,6 +42,7 @@ ALTER MATERIALIZED VIEW ALL IN TABLESPACE namecolumn_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } CLUSTER ON index_name SET WITHOUT CLUSTER + SET TABLESPACE new_tablespace SET ( storage_parameter [= value] [, ... ] ) RESET ( storage_parameter [, ... ] ) OWNER TO { new_owner | CURRENT_USER | SESSION_USER } -- 2.39.5