pgsql: Allow CREATE/ALTER DATABASE to manipulate datistemplate and data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow CREATE/ALTER DATABASE to manipulate datistemplate and data
Date: 2014-07-02 00:10:56
Message-ID: E1X288W-0000hI-Jd@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

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

Modified Files
--------------
contrib/pg_upgrade/pg_upgrade.c | 10 ++--
doc/src/sgml/ref/alter_database.sgml | 22 +++++++++
doc/src/sgml/ref/create_database.sgml | 24 +++++++++
src/backend/commands/dbcommands.c | 86 +++++++++++++++++++++++++++++----
src/bin/initdb/initdb.c | 6 +--
src/bin/pg_dump/pg_dumpall.c | 10 ++--
src/bin/psql/tab-complete.c | 7 +--
7 files changed, 135 insertions(+), 30 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2014-07-02 04:00:23 pgsql: Prevent psql from issuing BEGIN before ALTER SYSTEM when AUTOCOM
Previous Message Tom Lane 2014-07-01 23:02:27 pgsql: Refactor CREATE/ALTER DATABASE syntax so options need not be key