Peter Eisentraut <peter_e@gmx.net> writes:
> Let me put this differently. Should we either continue to hardcode the
> default privileges in the acldefault() function, or should we instead
> initialize the system catalogs with an entry in pg_default_acl as though
> ALTER DEFAULT PRIVILEGES GRANT USAGE ON TYPES TO PUBLIC; had been
> executed?
If you're proposing to replace acldefault() with a catalog lookup,
I vote no. I think that's a performance hit with little redeeming
social value.
regards, tom lane