pgsql: Add regression tests for ALTER MATERIALIZED VIEW with tablespace

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add regression tests for ALTER MATERIALIZED VIEW with tablespace
Date: 2022-03-19 08:31:08
Message-ID: E1nVUUN-000OHB-Hg@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add regression tests for ALTER MATERIALIZED VIEW with tablespaces

The clauses SET TABLESPACE and ALL IN TABLESPACE are supported in ALTER
MATERIALIZED VIEW for a long time, and they behave mostly like ALTER
TABLE by reusing the same code paths, but there were zero tests for
them. This commit closes the gap with new tests in tablespace.sql.

Author: Yugo Nagata
Discussion: https://postgr.es/m/20220316133337.5dc9740abfa24c25ec9f67f5@sraoss.co.jp

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ade2159bcdc18939d4e9b1773d12fe06cfcd201d

Modified Files
--------------
src/test/regress/expected/tablespace.out | 16 +++++++++++++++-
src/test/regress/sql/tablespace.sql | 8 ++++++++
2 files changed, 23 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2022-03-19 10:15:23 pgsql: Improve handling of SET ACCESS METHOD for ALTER MATERIALIZED VIE
Previous Message Michael Paquier 2022-03-19 07:39:11 pgsql: doc: Mention SET TABLESPACE clause for ALTER MATERIALIZED VIEW