PQExpBuffer initacl_subquery = createPQExpBuffer();

PQExpBuffer initracl_subquery = createPQExpBuffer();

/*

* Global entries (with defaclnamespace=0) replace the hard-wired

* default ACL for their object type. We should dump them as deltas

* from the default ACL, since that will be used as a starting point

* for interpreting the ALTER DEFAULT PRIVILEGES commands. On the

* other hand, non-global entries can only add privileges not revoke

* them. We must dump those as-is (i.e., as deltas from an empty

* ACL). We implement that by passing NULL as the object type for

* acldefault(), which works because acldefault() is STRICT.

*

* We can use defaclobjtype as the object type for acldefault(),

* except for the case of 'S' (DEFACLOBJ_SEQUENCE) which must be

* converted to 's'.

*/

buildACLQueries(acl_subquery, racl_subquery, initacl_subquery,

initracl_subquery, "defaclacl", "defaclrole",

"CASE WHEN defaclobjtype = 'S' THEN 's' ELSE defaclobjtype END::\"char\"",

"CASE WHEN defaclnamespace = 0 THEN"

" CASE WHEN defaclobjtype = 'S' THEN 's'::\"char\""

" ELSE defaclobjtype END "

"ELSE NULL END",

dopt->binary_upgrade);

appendPQExpBuffer(query, "SELECT d.oid, d.tableoid, "

},

},

=> {

create_order=> 15,

GRANT EXECUTE ON FUNCTIONS TO regress_dump_test_role;',

/xm,

{%full_runs,%dump_test_schema_runs,section_post_data=> 1, },

unlike=> {

exclude_dump_test_schema=> 1,

no_privs=> 1,

},

},

'ALTER DEFAULT PRIVILEGES FOR ROLE regress_dump_test_role REVOKE'=> {

create_order=> 55,