pgsql: Altering default privileges on schemas

Altering default privileges on schemas

Extend ALTER DEFAULT PRIVILEGES command to schemas.

Author: Matheus Oliveira
Reviewed-by: Petr Jelínek, Ashutosh Sharma

https://commitfest.postgresql.org/13/887/

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/ab89e465cb2032017c4888399f47a76ac16eaf40

Modified Files
--------------
doc/src/sgml/ref/alter_default_privileges.sgml | 17 ++++++-
src/backend/catalog/aclchk.c                   | 21 +++++++++
src/backend/catalog/objectaddress.c            | 14 +++++-
src/backend/catalog/pg_namespace.c             | 21 ++++++---
src/backend/parser/gram.y                      |  4 +-
src/bin/pg_dump/dumputils.c                    |  4 +-
src/bin/pg_dump/pg_dump.c                      |  3 ++
src/bin/psql/describe.c                        |  4 +-
src/bin/psql/tab-complete.c                    |  2 +-
src/include/catalog/pg_default_acl.h           |  1 +
src/include/parser/kwlist.h                    |  1 +
src/test/regress/expected/privileges.out       | 62 ++++++++++++++++++++++++++
src/test/regress/sql/privileges.sql            | 34 ++++++++++++++
13 files changed, 176 insertions(+), 12 deletions(-)