diff options
| -rw-r--r-- | src/test/regress/expected/psql.out | 3 | ||||
| -rw-r--r-- | src/test/regress/sql/psql.sql | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/src/test/regress/expected/psql.out b/src/test/regress/expected/psql.out index 0f349df3447..b75a74d2941 100644 --- a/src/test/regress/expected/psql.out +++ b/src/test/regress/expected/psql.out @@ -5248,9 +5248,9 @@ reset work_mem; (1 row) -- check \df+ -begin; -- we have to use functions with a predictable owner name, so make a role create role regress_psql_user superuser; +begin; set session authorization regress_psql_user; create function psql_df_internal (float8) returns float8 @@ -5275,6 +5275,7 @@ comment on function psql_df_plpgsql () is 'some comment'; (3 rows) rollback; +drop role regress_psql_user; -- check \sf \sf information_schema._pg_expandarray CREATE OR REPLACE FUNCTION information_schema._pg_expandarray(anyarray, OUT x anyelement, OUT n integer) diff --git a/src/test/regress/sql/psql.sql b/src/test/regress/sql/psql.sql index e4ed6cda1f7..961783d6eaa 100644 --- a/src/test/regress/sql/psql.sql +++ b/src/test/regress/sql/psql.sql @@ -1276,9 +1276,9 @@ reset work_mem; \do && anyarray * -- check \df+ -begin; -- we have to use functions with a predictable owner name, so make a role create role regress_psql_user superuser; +begin; set session authorization regress_psql_user; create function psql_df_internal (float8) @@ -1297,6 +1297,7 @@ comment on function psql_df_plpgsql () is 'some comment'; \df+ psql_df_* rollback; +drop role regress_psql_user; -- check \sf \sf information_schema._pg_expandarray |