91
91
SET SESSION ROLE tablespace_testuser2;
92
92
CREATE TABLE tablespace_table (i int) TABLESPACE testspace; -- fail
93
93
ERROR: permission denied for tablespace testspace
95
95
ALTER TABLESPACE testspace RENAME TO testspace_renamed;
96
96
ALTER TABLE ALL IN TABLESPACE testspace_renamed SET TABLESPACE pg_default;
97
97
ALTER INDEX ALL IN TABLESPACE testspace_renamed SET TABLESPACE pg_default;