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

Started by Tom Laneabout 12 years ago1 messagescomitters

tgl@sss.pgh.pa.us

about 12 years ago

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(-)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers