RETURNS TABLE (db name, "role" name, rolkeyword text, setconfig text[])

AS $$

SELECT COALESCE(d.datname, 'ALL'), COALESCE(r.rolname, 'ALL'),

COALESCE(v.keyword, '-'), s.setconfig

COALESCE(v.keyword, '-'), s.setconfig

FROM pg_db_role_setting s

LEFT JOIN pg_roles r ON (r.oid = s.setrole)

LEFT JOIN pg_database d ON (d.oid = s.setdatabase)

CREATE USER MAPPING FOR "Public" SERVER sv7 OPTIONS (user '"Public"');

CREATE USER MAPPING FOR regress_testrolx SERVER sv8 OPTIONS (user 'regress_testrolx');

CREATE USER MAPPING FOR CURRENT_ROLE SERVER sv9

OPTIONS (user 'CURRENT_ROLE'); -- error

OPTIONS (user 'CURRENT_ROLE'); -- error

ERROR: syntax error at or near "CURRENT_ROLE"

LINE 1: CREATE USER MAPPING FOR CURRENT_ROLE SERVER sv9

^

CREATE USER MAPPING FOR nonexistent SERVER sv9

OPTIONS (user 'nonexistent'); -- error;

OPTIONS (user 'nonexistent'); -- error;

ERROR: role "nonexistent" does not exist

SELECT * FROM chkumapping();

umname | umserver | umoptions

GRANT ALL PRIVILEGES ON FUNCTION testagg6(int2) TO regress_testrolx;

GRANT ALL PRIVILEGES ON FUNCTION testagg7(int2) TO "public";

GRANT ALL PRIVILEGES ON FUNCTION testagg8(int2)

TO current_user, public, regress_testrolx;

TO current_user, public, regress_testrolx;

SELECT proname, proacl FROM pg_proc WHERE proname LIKE 'testagg_';

proname | proacl

----------+-----------------------------------------------------------------------------------------------------------------------------------

REVOKE ALL PRIVILEGES ON FUNCTION testagg6(int2) FROM regress_testrolx;

REVOKE ALL PRIVILEGES ON FUNCTION testagg7(int2) FROM "public";

REVOKE ALL PRIVILEGES ON FUNCTION testagg8(int2)

FROM current_user, public, regress_testrolx;

FROM current_user, public, regress_testrolx;

SELECT proname, proacl FROM pg_proc WHERE proname LIKE 'testagg_';

proname | proacl

----------+---------------------------------------

RETURNS TABLE (db name,"role" name, rolkeywordtext, setconfigtext[])

AS $$

SELECT COALESCE(d.datname,'ALL'), COALESCE(r.rolname,'ALL'),

COALESCE(v.keyword,'-'),s.setconfig

COALESCE(v.keyword,'-'),s.setconfig

FROM pg_db_role_setting s

LEFT JOIN pg_roles rON (r.oid=s.setrole)

LEFT JOIN pg_database dON (d.oid=s.setdatabase)

CREATEUSERMAPPING FOR regress_testrolx SERVER sv8 OPTIONS (user'regress_testrolx');

CREATEUSERMAPPING FOR CURRENT_ROLE SERVER sv9

OPTIONS (user'CURRENT_ROLE');-- error

OPTIONS (user'CURRENT_ROLE');-- error

CREATEUSERMAPPING FOR nonexistent SERVER sv9

OPTIONS (user'nonexistent');-- error;

OPTIONS (user'nonexistent');-- error;

SELECT*FROM chkumapping();

GRANT ALL PRIVILEGESON FUNCTION testagg6(int2) TO regress_testrolx;

GRANT ALL PRIVILEGESON FUNCTION testagg7(int2) TO"public";

GRANT ALL PRIVILEGESON FUNCTION testagg8(int2)

TOcurrent_user, public, regress_testrolx;

TOcurrent_user, public, regress_testrolx;

SELECT proname, proaclFROM pg_procWHERE pronameLIKE'testagg_';

REVOKE ALL PRIVILEGESON FUNCTION testagg6(int2)FROM regress_testrolx;

REVOKE ALL PRIVILEGESON FUNCTION testagg7(int2)FROM"public";

REVOKE ALL PRIVILEGESON FUNCTION testagg8(int2)

FROMcurrent_user, public, regress_testrolx;

FROMcurrent_user, public, regress_testrolx;

SELECT proname, proaclFROM pg_procWHERE pronameLIKE'testagg_';