diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2014-07-01 20:10:38 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2014-07-01 20:10:38 -0400 |
| commit | fbb1d7d73f8e23a3a61e702629c53cef48cb0918 (patch) | |
| tree | b0f1f20d6dc19568f0916cc33e3aeb7caa263f89 /src/bin/psql/tab-complete.c | |
| parent | 15c82efd6994affd1d5654d13bc8911a9faff659 (diff) | |
| download | postgresql-fbb1d7d73f8e23a3a61e702629c53cef48cb0918.tar.gz postgresql-fbb1d7d73f8e23a3a61e702629c53cef48cb0918.zip | |
Allow CREATE/ALTER DATABASE to manipulate datistemplate and datallowconn.
Historically these database properties could be manipulated only by
manually updating pg_database, which is error-prone and only possible for
superusers. But there seems no good reason not to allow database owners to
set them for their databases, so invent CREATE/ALTER DATABASE options to do
that. Adjust a couple of places that were doing it the hard way to use the
commands instead.
Vik Fearing, reviewed by Pavel Stehule
Diffstat (limited to 'src/bin/psql/tab-complete.c')
| -rw-r--r-- | src/bin/psql/tab-complete.c | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index be5c3c5f450..bab03572352 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -1021,7 +1021,8 @@ psql_completion(const char *text, int start, int end) pg_strcasecmp(prev2_wd, "DATABASE") == 0) { static const char *const list_ALTERDATABASE[] = - {"RESET", "SET", "OWNER TO", "RENAME TO", "CONNECTION LIMIT", NULL}; + {"RESET", "SET", "OWNER TO", "RENAME TO", "IS_TEMPLATE", + "ALLOW_CONNECTIONS", "CONNECTION LIMIT", NULL}; COMPLETE_WITH_LIST(list_ALTERDATABASE); } @@ -2111,8 +2112,8 @@ psql_completion(const char *text, int start, int end) pg_strcasecmp(prev2_wd, "DATABASE") == 0) { static const char *const list_DATABASE[] = - {"OWNER", "TEMPLATE", "ENCODING", "TABLESPACE", "CONNECTION LIMIT", - NULL}; + {"OWNER", "TEMPLATE", "ENCODING", "TABLESPACE", "IS_TEMPLATE", + "ALLOW_CONNECTIONS", "CONNECTION LIMIT", NULL}; COMPLETE_WITH_LIST(list_DATABASE); } |