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:03:05 -0800 |
| commit | 3f920e876bdc045959ebb82e44245cb839da0df4 (patch) | |
| tree | bb2c6c24630872f4041860f49b9722a3a4c6a5e6 | |
| parent | b81d3791ed8f52bf2507c306bda922dc272f20ce (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
| -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 1b9f3d117db..14ce823ffc7 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 regress_user1 NOINHERIT; +SET SESSION AUTHORIZATION regress_user1; DELETE FROM atest3; -ERROR: permission denied for table atest3 +ERROR: permission denied for relation atest3 ROLLBACK; -- views SET SESSION AUTHORIZATION regress_user3; diff --git a/src/test/regress/sql/privileges.sql b/src/test/regress/sql/privileges.sql index e66909e36c3..f1d879c0873 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 regress_user1 NOINHERIT; +SET SESSION AUTHORIZATION regress_user1; DELETE FROM atest3; ROLLBACK; |