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/initdb/initdb.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/initdb/initdb.c')
| -rw-r--r-- | src/bin/initdb/initdb.c | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/src/bin/initdb/initdb.c b/src/bin/initdb/initdb.c index 5228f134222..a25965ce4c9 100644 --- a/src/bin/initdb/initdb.c +++ b/src/bin/initdb/initdb.c @@ -2288,11 +2288,7 @@ make_template0(void) PG_CMD_DECL; const char **line; static const char *template0_setup[] = { - "CREATE DATABASE template0;\n", - "UPDATE pg_database SET " - " datistemplate = 't', " - " datallowconn = 'f' " - " WHERE datname = 'template0';\n", + "CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false;\n", /* * We use the OID of template0 to determine lastsysoid |