diff options
| author | Noah Misch <noah@leadboat.com> | 2020-12-25 11:02:56 -0800 |
|---|---|---|
| committer | Noah Misch <noah@leadboat.com> | 2020-12-25 11:06:23 -0800 |
| commit | 14649bf502eb36d85fb9e78981651942a683162b (patch) | |
| tree | 5c6e30c6d5d04e33a72c132a41f73a1b618eadeb /src | |
| parent | 90383a613b48925f9dbc4ca325a1234956baddab (diff) | |
Fix back-patch of "Invalidate acl.c caches when pg_authid changes."
Test script role names and error messages differed in v10, 9.6 and 9.5.
Discussion: https://postgr.es/m/20201221095028.GB3777719@rfd.leadboat.com
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/privileges.out | 6 | ||||
| -rw-r--r-- | src/test/regress/sql/privileges.sql | 4 |
2 files changed, 5 insertions, 5 deletions
diff --git a/src/test/regress/expected/privileges.out b/src/test/regress/expected/privileges.out index f68210bcd21..c1936bda092 100644 --- a/src/test/regress/expected/privileges.out +++ b/src/test/regress/expected/privileges.out @@ -348,10 +348,10 @@ ERROR: permission denied for relation atest3 DELETE FROM atest3; -- ok BEGIN; RESET SESSION AUTHORIZATION; -ALTER ROLE regress_priv_user1 NOINHERIT; -SET SESSION AUTHORIZATION regress_priv_user1; +ALTER ROLE regressuser1 NOINHERIT; +SET SESSION AUTHORIZATION regressuser1; DELETE FROM atest3; -ERROR: permission denied for table atest3 +ERROR: permission denied for relation atest3 ROLLBACK; -- views SET SESSION AUTHORIZATION regressuser3; diff --git a/src/test/regress/sql/privileges.sql b/src/test/regress/sql/privileges.sql index b31eb28cce3..6e9db844ad4 100644 --- a/src/test/regress/sql/privileges.sql +++ b/src/test/regress/sql/privileges.sql @@ -218,8 +218,8 @@ DELETE FROM atest3; -- ok BEGIN; RESET SESSION AUTHORIZATION; -ALTER ROLE regress_priv_user1 NOINHERIT; -SET SESSION AUTHORIZATION regress_priv_user1; +ALTER ROLE regressuser1 NOINHERIT; +SET SESSION AUTHORIZATION regressuser1; DELETE FROM atest3; ROLLBACK; |