aboutsummaryrefslogtreecommitdiff
path: root/src/bin/pg_dump/dumputils.c
diff options
context:
space:
mode:
authorTeodor Sigaev <teodor@sigaev.ru>2017-03-28 18:58:55 +0300
committerTeodor Sigaev <teodor@sigaev.ru>2017-03-28 18:58:55 +0300
commitab89e465cb2032017c4888399f47a76ac16eaf40 (patch)
treeba20a87318e5c036744d0ecaaa388b4a05941b7f /src/bin/pg_dump/dumputils.c
parent85163641f8bdeb7734b37ae67faa224a029afe25 (diff)
downloadpostgresql-ab89e465cb2032017c4888399f47a76ac16eaf40.tar.gz
postgresql-ab89e465cb2032017c4888399f47a76ac16eaf40.zip
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/
Diffstat (limited to 'src/bin/pg_dump/dumputils.c')
-rw-r--r--src/bin/pg_dump/dumputils.c4
1 files changed, 3 insertions, 1 deletions
diff --git a/src/bin/pg_dump/dumputils.c b/src/bin/pg_dump/dumputils.c
index b41f2b91258..c74153acce2 100644
--- a/src/bin/pg_dump/dumputils.c
+++ b/src/bin/pg_dump/dumputils.c
@@ -520,7 +520,9 @@ do { \
CONVERT_PRIV('X', "EXECUTE");
else if (strcmp(type, "LANGUAGE") == 0)
CONVERT_PRIV('U', "USAGE");
- else if (strcmp(type, "SCHEMA") == 0)
+ else if (strcmp(type, "SCHEMA") == 0 ||
+ strcmp(type, "SCHEMAS") == 0
+ )
{
CONVERT_PRIV('C', "CREATE");
CONVERT_PRIV('U', "USAGE");