diff options
| author | Tomas Vondra <tomas.vondra@postgresql.org> | 2021-08-31 19:21:29 +0200 |
|---|---|---|
| committer | Tomas Vondra <tomas.vondra@postgresql.org> | 2021-08-31 19:41:58 +0200 |
| commit | 5f8dd5dc1701348bce659b9689d085e011399d61 (patch) | |
| tree | e4e8c54e5c52ba43ed3f1238accc1fc6148661f5 /src | |
| parent | 6c8b98669d1479148f02375c68ff17772ce7f95b (diff) | |
| download | postgresql-5f8dd5dc1701348bce659b9689d085e011399d61.tar.gz postgresql-5f8dd5dc1701348bce659b9689d085e011399d61.zip | |
Rename the role in stats_ext to have regress_ prefix
Commit 5be8ce82e8 added a new role to the stats_ext regression suite,
but the role name did not start with regress_ causing failures when
running with ENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS. Fixed by
renaming the role to start with the expected regress_ prefix.
Backpatch-through: 10, same as the new regression test
Discussion: https://postgr.es/m/1F238937-7CC2-4703-A1B1-6DC225B8978A%40enterprisedb.com
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/stats_ext.out | 6 | ||||
| -rw-r--r-- | src/test/regress/sql/stats_ext.sql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/src/test/regress/expected/stats_ext.out b/src/test/regress/expected/stats_ext.out index 4edb56b99e9..06521a426a3 100644 --- a/src/test/regress/expected/stats_ext.out +++ b/src/test/regress/expected/stats_ext.out @@ -53,8 +53,8 @@ DROP TABLE ext_stats_test; CREATE TABLE ab1 (a INTEGER, b INTEGER, c INTEGER); CREATE STATISTICS IF NOT EXISTS ab1_a_b_stats ON a, b FROM ab1; COMMENT ON STATISTICS ab1_a_b_stats IS 'new comment'; -CREATE ROLE temp_role; -SET SESSION AUTHORIZATION temp_role; +CREATE ROLE regress_stats_ext; +SET SESSION AUTHORIZATION regress_stats_ext; COMMENT ON STATISTICS ab1_a_b_stats IS 'changed comment'; ERROR: must be owner of statistics object ab1_a_b_stats DROP STATISTICS ab1_a_b_stats; @@ -62,7 +62,7 @@ ERROR: must be owner of statistics object ab1_a_b_stats ALTER STATISTICS ab1_a_b_stats RENAME TO ab1_a_b_stats_new; ERROR: must be owner of statistics object ab1_a_b_stats RESET SESSION AUTHORIZATION; -DROP ROLE temp_role; +DROP ROLE regress_stats_ext; CREATE STATISTICS IF NOT EXISTS ab1_a_b_stats ON a, b FROM ab1; NOTICE: statistics object "ab1_a_b_stats" already exists, skipping DROP STATISTICS ab1_a_b_stats; diff --git a/src/test/regress/sql/stats_ext.sql b/src/test/regress/sql/stats_ext.sql index 24171d1e642..06a2caff7ba 100644 --- a/src/test/regress/sql/stats_ext.sql +++ b/src/test/regress/sql/stats_ext.sql @@ -42,13 +42,13 @@ DROP TABLE ext_stats_test; CREATE TABLE ab1 (a INTEGER, b INTEGER, c INTEGER); CREATE STATISTICS IF NOT EXISTS ab1_a_b_stats ON a, b FROM ab1; COMMENT ON STATISTICS ab1_a_b_stats IS 'new comment'; -CREATE ROLE temp_role; -SET SESSION AUTHORIZATION temp_role; +CREATE ROLE regress_stats_ext; +SET SESSION AUTHORIZATION regress_stats_ext; COMMENT ON STATISTICS ab1_a_b_stats IS 'changed comment'; DROP STATISTICS ab1_a_b_stats; ALTER STATISTICS ab1_a_b_stats RENAME TO ab1_a_b_stats_new; RESET SESSION AUTHORIZATION; -DROP ROLE temp_role; +DROP ROLE regress_stats_ext; CREATE STATISTICS IF NOT EXISTS ab1_a_b_stats ON a, b FROM ab1; DROP STATISTICS ab1_a_b_stats; |