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/test/regress/output/tablespace.source | |
| parent | b5e0a2a38401273d3d11b81f4424681db9845882 (diff) | |
| download | postgresql-b921a26fb89cf52ec32b6c19a8528524883beeb5.tar.gz | |
Regression tests for ALTER TABLESPACE RENAME,OWNER
Hari Babu Kommi reviewed by David Rowley
Diffstat (limited to 'src/test/regress/output/tablespace.source')
| -rw-r--r-- | src/test/regress/output/tablespace.source | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/src/test/regress/output/tablespace.source b/src/test/regress/output/tablespace.source index 1260c96888..2868169c6c 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; |