@@ -17,7 +17,7 @@ CREATE OR REPLACE FUNCTION chksetconfig()
1717 RETURNS TABLE (db name, "role" name, rolkeyword text, setconfig text[])
1818 AS $$
1919SELECT COALESCE(d.datname, 'ALL'), COALESCE(r.rolname, 'ALL'),
20- COALESCE(v.keyword, '-'), s.setconfig
20+ COALESCE(v.keyword, '-'), s.setconfig
2121 FROM pg_db_role_setting s
2222 LEFT JOIN pg_roles r ON (r.oid = s.setrole)
2323 LEFT JOIN pg_database d ON (d.oid = s.setdatabase)
@@ -641,12 +641,12 @@ CREATE USER MAPPING FOR PUBLIC SERVER sv6 OPTIONS (user 'PUBLIC');
641641CREATE USER MAPPING FOR "Public" SERVER sv7 OPTIONS (user '"Public"');
642642CREATE USER MAPPING FOR regress_testrolx SERVER sv8 OPTIONS (user 'regress_testrolx');
643643CREATE USER MAPPING FOR CURRENT_ROLE SERVER sv9
644- OPTIONS (user 'CURRENT_ROLE'); -- error
644+ OPTIONS (user 'CURRENT_ROLE'); -- error
645645ERROR: syntax error at or near "CURRENT_ROLE"
646646LINE 1: CREATE USER MAPPING FOR CURRENT_ROLE SERVER sv9
647647 ^
648648CREATE USER MAPPING FOR nonexistent SERVER sv9
649- OPTIONS (user 'nonexistent'); -- error;
649+ OPTIONS (user 'nonexistent'); -- error;
650650ERROR: role "nonexistent" does not exist
651651SELECT * FROM chkumapping();
652652 umname | umserver | umoptions
@@ -860,7 +860,7 @@ GRANT ALL PRIVILEGES ON FUNCTION testagg5(int2) TO "Public";
860860GRANT ALL PRIVILEGES ON FUNCTION testagg6(int2) TO regress_testrolx;
861861GRANT ALL PRIVILEGES ON FUNCTION testagg7(int2) TO "public";
862862GRANT ALL PRIVILEGES ON FUNCTION testagg8(int2)
863- TO current_user, public, regress_testrolx;
863+ TO current_user, public, regress_testrolx;
864864SELECT proname, proacl FROM pg_proc WHERE proname LIKE 'testagg_';
865865 proname | proacl
866866----------+-----------------------------------------------------------------------------------------------------------------------------------
@@ -913,7 +913,7 @@ REVOKE ALL PRIVILEGES ON FUNCTION testagg5(int2) FROM "Public";
913913REVOKE ALL PRIVILEGES ON FUNCTION testagg6(int2) FROM regress_testrolx;
914914REVOKE ALL PRIVILEGES ON FUNCTION testagg7(int2) FROM "public";
915915REVOKE ALL PRIVILEGES ON FUNCTION testagg8(int2)
916- FROM current_user, public, regress_testrolx;
916+ FROM current_user, public, regress_testrolx;
917917SELECT proname, proacl FROM pg_proc WHERE proname LIKE 'testagg_';
918918 proname | proacl
919919----------+---------------------------------------
0 commit comments