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 ) id 1qyy9v-00CPZv-2U for pgsql-docs@arkaria.postgresql.org; Fri, 03 Nov 2023 17:40:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qyy9t-0021CM-AE for pgsql-docs@arkaria.postgresql.org; Fri, 03 Nov 2023 17:40:37 +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 ) id 1qyy9t-0021Bd-2Y for pgsql-docs@lists.postgresql.org; Fri, 03 Nov 2023 17:40:37 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qyy9n-003nVZ-MP for pgsql-docs@lists.postgresql.org; Fri, 03 Nov 2023 17:40:35 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2023062407; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description; bh=qoOiUXKSZnVpIPKZ3ddgdATiFP7PsIUCHLP6hIt2nTg=; b=quYcl bOL1BdWxIHYZXleKP+PgP2BLf61x0sO5oZY602W5+COOw1hR/9uqaGDjKq5xSH/M5dFLZWecu1BMm 6f6IzGZKfnhyW2W4MRyctjKaIsjJsDxytFBfYe8owPWzu29n2Hr1348sCfrKnlOZzUXKohs9g2Y1G nRHIoPleTfB8arbUceoG4+oqAnaQpbgKS/kqpVmUv86EkE6To2T7xYDPLoVQKZcsXKDfqYQX86Loc 2JQcmB3HN2ZuWLfv5kW70knO+y7jBGY4uNWRgKo0Y+Gwz8bl330oJTlr6LHiSKCYXWpTWwo+5kDeR CYQAPra/MdyysjXfePtm3PLLpaihA==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1qyy9m-000Ayn-1f; Fri, 03 Nov 2023 13:40:30 -0400 Date: Fri, 3 Nov 2023 13:40:30 -0400 From: Bruce Momjian To: Tom Lane Cc: david@kapitaltrading.com, pgsql-docs@lists.postgresql.org Subject: Re: "22.3. Template Databases" documentation is incomplete Message-ID: References: <166007719137.995877.13951579839074751714@wrigleys.postgresql.org> <1981220.1698518526@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Oct 28, 2023 at 03:14:32PM -0400, Bruce Momjian wrote: > On Sat, Oct 28, 2023 at 02:42:06PM -0400, Tom Lane wrote: > > Bruce Momjian 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. > > > > > > + > > + However, CREATE DATABASE does not copy > > + database-level GRANT permissions attached to the > > + source database. The new database has default permissions. > > + > > + > > > > There is a second standard system database named > > Sure. Separate paragraph version applied to all supported versions. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.