diff options
| -rw-r--r-- | src/test/regress/expected/create_index.out | 9 | ||||
| -rw-r--r-- | src/test/regress/sql/create_index.sql | 6 |
2 files changed, 7 insertions, 8 deletions
diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out index eba14e262f2..06c67162971 100644 --- a/src/test/regress/expected/create_index.out +++ b/src/test/regress/expected/create_index.out @@ -2846,14 +2846,13 @@ REINDEX SCHEMA schema_to_reindex; -- failure, cannot run in a transaction ERROR: REINDEX SCHEMA cannot run inside a transaction block END; -- Failure for unauthorized user -CREATE ROLE reindexuser login; -SET SESSION ROLE user_reindex; -ERROR: role "user_reindex" does not exist +CREATE ROLE regression_reindexuser NOLOGIN; +SET SESSION ROLE regression_reindexuser; REINDEX SCHEMA schema_to_reindex; +ERROR: must be owner of schema schema_to_reindex -- Clean up RESET ROLE; -DROP ROLE user_reindex; -ERROR: role "user_reindex" does not exist +DROP ROLE regression_reindexuser; DROP SCHEMA schema_to_reindex CASCADE; NOTICE: drop cascades to 2 other objects DETAIL: drop cascades to table schema_to_reindex.table1 diff --git a/src/test/regress/sql/create_index.sql b/src/test/regress/sql/create_index.sql index 1cd57dada78..fdda078c3a8 100644 --- a/src/test/regress/sql/create_index.sql +++ b/src/test/regress/sql/create_index.sql @@ -979,11 +979,11 @@ REINDEX SCHEMA schema_to_reindex; -- failure, cannot run in a transaction END; -- Failure for unauthorized user -CREATE ROLE reindexuser login; -SET SESSION ROLE user_reindex; +CREATE ROLE regression_reindexuser NOLOGIN; +SET SESSION ROLE regression_reindexuser; REINDEX SCHEMA schema_to_reindex; -- Clean up RESET ROLE; -DROP ROLE user_reindex; +DROP ROLE regression_reindexuser; DROP SCHEMA schema_to_reindex CASCADE; |