aboutsummaryrefslogtreecommitdiff
path: root/src/test/modules/test_pg_dump/sql/test_pg_dump.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/modules/test_pg_dump/sql/test_pg_dump.sql')
-rw-r--r--src/test/modules/test_pg_dump/sql/test_pg_dump.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/src/test/modules/test_pg_dump/sql/test_pg_dump.sql b/src/test/modules/test_pg_dump/sql/test_pg_dump.sql
index 4598531ce7f..a56a945104d 100644
--- a/src/test/modules/test_pg_dump/sql/test_pg_dump.sql
+++ b/src/test/modules/test_pg_dump/sql/test_pg_dump.sql
@@ -77,9 +77,9 @@ GRANT USAGE ON TYPE test_pg_dump_e1 TO regress_dump_test_role;
-- Substitute for current user's name to keep test output consistent
SELECT s.obj,
- CASE WHEN a.grantor::regrole::name = current_user THEN 'postgres'
+ CASE WHEN a.grantor::regrole::name = quote_ident(current_user) THEN 'postgres'
ELSE a.grantor::regrole::name END,
- CASE WHEN a.grantee::regrole::name = current_user THEN 'postgres'
+ CASE WHEN a.grantee::regrole::name = quote_ident(current_user) THEN 'postgres'
ELSE a.grantee::regrole::name END,
a.privilege_type, a.is_grantable
FROM
@@ -129,9 +129,9 @@ DROP OWNED BY regress_dump_test_role RESTRICT;
-- Substitute for current user's name to keep test output consistent
SELECT s.obj,
- CASE WHEN a.grantor::regrole::name = current_user THEN 'postgres'
+ CASE WHEN a.grantor::regrole::name = quote_ident(current_user) THEN 'postgres'
ELSE a.grantor::regrole::name END,
- CASE WHEN a.grantee::regrole::name = current_user THEN 'postgres'
+ CASE WHEN a.grantee::regrole::name = quote_ident(current_user) THEN 'postgres'
ELSE a.grantee::regrole::name END,
a.privilege_type, a.is_grantable
FROM