CREATEOR REPLACEFUNCTION chkrolattr()

CREATE FUNCTION chkrolattr()

RETURNS TABLE ("role" name, rolekeyword text, canlogin bool, replication bool)

AS $$

SELECT r.rolname, v.keyword, r.rolcanlogin, r.rolreplication

('None', '-'))

AS v(uname, keyword)

ON (r.rolname = v.uname)

ORDER BY 1;

ORDER BY 1, 2;

$$ LANGUAGE SQL;

CREATEOR REPLACEFUNCTION chksetconfig()

CREATE FUNCTION chksetconfig()

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

AS $$

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

WHERE (r.rolname) IN ('Public', 'current_user', 'regress_testrol1', 'regress_testrol2')

ORDER BY 1, 2;

$$ LANGUAGE SQL;

CREATEOR REPLACEFUNCTION chkumapping()

CREATE FUNCTION chkumapping()

RETURNS TABLE (umname name, umserver name, umoptions text[])

AS $$

SELECT r.rolname, s.srvname, m.umoptions

FROM pg_user_mapping m

LEFT JOIN pg_roles r ON (r.oid = m.umuser)

JOIN pg_foreign_server s ON (s.oid = m.umserver)

ORDER BY 2;

ORDER BY 2, 1;

$$ LANGUAGE SQL;

--

-- We test creation and use of these role names to ensure that the server

CREATEOR REPLACEFUNCTIONchkrolattr()

CREATEFUNCTIONchkrolattr()

RETURNS TABLE ("role" name, rolekeywordtext, canlogin bool, replication bool)

AS $$

SELECTr.rolname,v.keyword,r.rolcanlogin,r.rolreplication

('None','-'))

AS v(uname, keyword)

ON (r.rolname=v.uname)

ORDER BY1;

ORDER BY1,2;

$$ LANGUAGE SQL;

CREATEOR REPLACEFUNCTIONchksetconfig()

CREATEFUNCTIONchksetconfig()

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

AS $$

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

ORDER BY1,2;

$$ LANGUAGE SQL;

CREATEOR REPLACEFUNCTIONchkumapping()

CREATEFUNCTIONchkumapping()

RETURNS TABLE (umname name, umserver name, umoptionstext[])

AS $$

SELECTr.rolname,s.srvname,m.umoptions

FROM pg_user_mapping m

LEFT JOIN pg_roles rON (r.oid=m.umuser)

JOIN pg_foreign_server sON (s.oid=m.umserver)

ORDER BY2;

ORDER BY2,1;

$$ LANGUAGE SQL;