diff options
| author | Simon Riggs <simon@2ndQuadrant.com> | 2013-12-11 20:42:58 +0000 |
|---|---|---|
| committer | Simon Riggs <simon@2ndQuadrant.com> | 2013-12-11 20:42:58 +0000 |
| commit | b921a26fb89cf52ec32b6c19a8528524883beeb5 (patch) | |
| tree | 1e16b5b7dfbb1250173a04774d118aa4610cf8d1 /src | |
| parent | b5e0a2a38401273d3d11b81f4424681db9845882 (diff) | |
| download | postgresql-b921a26fb89cf52ec32b6c19a8528524883beeb5.tar.gz postgresql-b921a26fb89cf52ec32b6c19a8528524883beeb5.zip | |
Regression tests for ALTER TABLESPACE RENAME,OWNER
Hari Babu Kommi reviewed by David Rowley
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/input/tablespace.source | 17 | ||||
| -rw-r--r-- | src/test/regress/output/tablespace.source | 12 |
2 files changed, 27 insertions, 2 deletions
diff --git a/src/test/regress/input/tablespace.source b/src/test/regress/input/tablespace.source index dba96f4547f..4f17b09fa94 100644 --- a/src/test/regress/input/tablespace.source +++ b/src/test/regress/input/tablespace.source @@ -54,7 +54,22 @@ CREATE TABLE bar (i int) TABLESPACE nosuchspace; -- Fail, not empty DROP TABLESPACE testspace; +CREATE ROLE tablespace_testuser1 login; +CREATE ROLE tablespace_testuser2 login; + +ALTER TABLESPACE testspace OWNER TO tablespace_testuser1; + +SET SESSION ROLE tablespace_testuser2; +CREATE TABLE tablespace_table (i int) TABLESPACE testspace; -- fail + +\c - + +ALTER TABLESPACE testspace RENAME TO testspace_renamed; + DROP SCHEMA testschema CASCADE; -- Should succeed -DROP TABLESPACE testspace; +DROP TABLESPACE testspace_renamed; + +DROP ROLE tablespace_testuser1; +DROP ROLE tablespace_testuser2; diff --git a/src/test/regress/output/tablespace.source b/src/test/regress/output/tablespace.source index 1260c968880..2868169c6ce 100644 --- a/src/test/regress/output/tablespace.source +++ b/src/test/regress/output/tablespace.source @@ -72,6 +72,14 @@ ERROR: tablespace "nosuchspace" does not exist -- Fail, not empty DROP TABLESPACE testspace; ERROR: tablespace "testspace" is not empty +CREATE ROLE tablespace_testuser1 login; +CREATE ROLE tablespace_testuser2 login; +ALTER TABLESPACE testspace OWNER TO tablespace_testuser1; +SET SESSION ROLE tablespace_testuser2; +CREATE TABLE tablespace_table (i int) TABLESPACE testspace; -- fail +ERROR: permission denied for tablespace testspace +\c - +ALTER TABLESPACE testspace RENAME TO testspace_renamed; DROP SCHEMA testschema CASCADE; NOTICE: drop cascades to 4 other objects DETAIL: drop cascades to table testschema.foo @@ -79,4 +87,6 @@ drop cascades to table testschema.asselect drop cascades to table testschema.asexecute drop cascades to table testschema.atable -- Should succeed -DROP TABLESPACE testspace; +DROP TABLESPACE testspace_renamed; +DROP ROLE tablespace_testuser1; +DROP ROLE tablespace_testuser2; |