Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1qwoGD-00EP4N-P6
	for pgsql-docs@arkaria.postgresql.org; Sat, 28 Oct 2023 18:42:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1qwoGB-005JMj-Fb
	for pgsql-docs@arkaria.postgresql.org; Sat, 28 Oct 2023 18:42:11 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1qwoGB-005JMa-86
	for pgsql-docs@lists.postgresql.org; Sat, 28 Oct 2023 18:42:11 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1qwoG8-002lk7-Ia
	for pgsql-docs@lists.postgresql.org; Sat, 28 Oct 2023 18:42:10 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 39SIg68J1981221;
	Sat, 28 Oct 2023 14:42:06 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
cc: david@kapitaltrading.com, pgsql-docs@lists.postgresql.org
Subject: Re: "22.3. Template Databases" documentation is incomplete
In-reply-to: <ZT06EOE2dDdEklEY@momjian.us>
References: <166007719137.995877.13951579839074751714@wrigleys.postgresql.org>
 <ZT00aqNUUQxhXHBo@momjian.us> <ZT06EOE2dDdEklEY@momjian.us>
Comments: In-reply-to Bruce Momjian <bruce@momjian.us>
	message dated "Sat, 28 Oct 2023 12:42:56 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1981219.1698518526.1@sss.pgh.pa.us>
Date: Sat, 28 Oct 2023 14:42:06 -0400
Message-ID: <1981220.1698518526@sss.pgh.pa.us>
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/1981220.1698518526%40sss.pgh.pa.us>
Precedence: bulk

Bruce Momjian <bruce@momjian.us> writes:
> Sorry, I attached a _colorized_ diff;  here is a normal one.

The new sentence is fine in isolation, but this doesn't feel like
a great spot to put it.  The preceding several lines are all about
copying of objects within the database, and this isn't.  In
particular, the antecedent of "it" is unclear and is different
from what "it" means in the immediately preceding sentence.

It might be best to split the thing out into its own para?
Something like

    action being taken when those databases are created.
   </para>

+  <para>
+   However, <command>CREATE DATABASE</command> does not copy
+   database-level <command>GRANT</command> permissions attached to the
+   source database.  The new database has default permissions.
+  </para>
+
   <para>
    There is a second standard system database named

			regards, tom lane