diff options
Diffstat (limited to 'src/test/regress/input/tablespace.source')
| -rw-r--r-- | src/test/regress/input/tablespace.source | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/test/regress/input/tablespace.source b/src/test/regress/input/tablespace.source index 601522866d1..e259254b02c 100644 --- a/src/test/regress/input/tablespace.source +++ b/src/test/regress/input/tablespace.source @@ -76,10 +76,11 @@ CREATE TABLE tablespace_table (i int) TABLESPACE testspace; -- fail ALTER TABLESPACE testspace RENAME TO testspace_renamed; -ALTER TABLESPACE testspace_renamed MOVE ALL TO pg_default; +ALTER TABLE ALL IN TABLESPACE testspace_renamed SET TABLESPACE pg_default; +ALTER INDEX ALL IN TABLESPACE testspace_renamed SET TABLESPACE pg_default; -- Should show notice that nothing was done -ALTER TABLESPACE testspace_renamed MOVE ALL TO pg_default; +ALTER TABLE ALL IN TABLESPACE testspace_renamed SET TABLESPACE pg_default; -- Should succeed DROP TABLESPACE testspace_renamed; |