Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitade2159

Browse files
committed
Add regression tests for ALTER MATERIALIZED VIEW with tablespaces
The clauses SET TABLESPACE and ALL IN TABLESPACE are supported in ALTERMATERIALIZED VIEW for a long time, and they behave mostly like ALTERTABLE by reusing the same code paths, but there were zero tests forthem. This commit closes the gap with new tests in tablespace.sql.Author: Yugo NagataDiscussion:https://postgr.es/m/20220316133337.5dc9740abfa24c25ec9f67f5@sraoss.co.jp
1 parent9616da3 commitade2159

File tree

2 files changed

+23
-1
lines changed

2 files changed

+23
-1
lines changed

‎src/test/regress/expected/tablespace.out

Lines changed: 15 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -905,6 +905,16 @@ SELECT COUNT(*) FROM testschema.atable;-- checks heap
905905
3
906906
(1 row)
907907

908+
-- let's try moving a materialized view from one place to another
909+
CREATE MATERIALIZED VIEW testschema.amv AS SELECT * FROM testschema.atable;
910+
ALTER MATERIALIZED VIEW testschema.amv SET TABLESPACE regress_tblspace;
911+
REFRESH MATERIALIZED VIEW testschema.amv;
912+
SELECT COUNT(*) FROM testschema.amv;
913+
count
914+
-------
915+
3
916+
(1 row)
917+
908918
-- Will fail with bad path
909919
CREATE TABLESPACE regress_badspace LOCATION '/no/such/location';
910920
ERROR: directory "/no/such/location" does not exist
@@ -939,18 +949,22 @@ RESET ROLE;
939949
ALTER TABLESPACE regress_tblspace RENAME TO regress_tblspace_renamed;
940950
ALTER TABLE ALL IN TABLESPACE regress_tblspace_renamed SET TABLESPACE pg_default;
941951
ALTER INDEX ALL IN TABLESPACE regress_tblspace_renamed SET TABLESPACE pg_default;
952+
ALTER MATERIALIZED VIEW ALL IN TABLESPACE regress_tblspace_renamed SET TABLESPACE pg_default;
942953
-- Should show notice that nothing was done
943954
ALTER TABLE ALL IN TABLESPACE regress_tblspace_renamed SET TABLESPACE pg_default;
944955
NOTICE: no matching relations in tablespace "regress_tblspace_renamed" found
956+
ALTER MATERIALIZED VIEW ALL IN TABLESPACE regress_tblspace_renamed SET TABLESPACE pg_default;
957+
NOTICE: no matching relations in tablespace "regress_tblspace_renamed" found
945958
-- Should succeed
946959
DROP TABLESPACE regress_tblspace_renamed;
947960
DROP SCHEMA testschema CASCADE;
948-
NOTICE: drop cascades to6 other objects
961+
NOTICE: drop cascades to7 other objects
949962
DETAIL: drop cascades to table testschema.foo
950963
drop cascades to table testschema.asselect
951964
drop cascades to table testschema.asexecute
952965
drop cascades to table testschema.part
953966
drop cascades to table testschema.atable
967+
drop cascades to materialized view testschema.amv
954968
drop cascades to table testschema.tablespace_acl
955969
DROP ROLE regress_tablespace_user1;
956970
DROP ROLE regress_tablespace_user2;

‎src/test/regress/sql/tablespace.sql

Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -380,6 +380,12 @@ INSERT INTO testschema.atable VALUES(3);-- ok
380380
INSERT INTOtestschema.atableVALUES(1);-- fail (checks index)
381381
SELECTCOUNT(*)FROMtestschema.atable;-- checks heap
382382

383+
-- let's try moving a materialized view from one place to another
384+
CREATE MATERIALIZED VIEWtestschema.amvASSELECT*FROMtestschema.atable;
385+
ALTER MATERIALIZED VIEWtestschema.amvSET TABLESPACE regress_tblspace;
386+
REFRESH MATERIALIZED VIEWtestschema.amv;
387+
SELECTCOUNT(*)FROMtestschema.amv;
388+
383389
-- Will fail with bad path
384390
CREATETABLESPACEregress_badspace LOCATION'/no/such/location';
385391

@@ -414,9 +420,11 @@ ALTER TABLESPACE regress_tblspace RENAME TO regress_tblspace_renamed;
414420

415421
ALTERTABLE ALLIN TABLESPACE regress_tblspace_renamedSET TABLESPACE pg_default;
416422
ALTERINDEX ALLIN TABLESPACE regress_tblspace_renamedSET TABLESPACE pg_default;
423+
ALTER MATERIALIZED VIEW ALLIN TABLESPACE regress_tblspace_renamedSET TABLESPACE pg_default;
417424

418425
-- Should show notice that nothing was done
419426
ALTERTABLE ALLIN TABLESPACE regress_tblspace_renamedSET TABLESPACE pg_default;
427+
ALTER MATERIALIZED VIEW ALLIN TABLESPACE regress_tblspace_renamedSET TABLESPACE pg_default;
420428

421429
-- Should succeed
422430
DROPTABLESPACE regress_tblspace_renamed;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp