Date: Sat, 28 Oct 2023 12:18:50 -0400
From: Bruce Momjian <bruce@momjian.us>
To: david@kapitaltrading.com, pgsql-docs@lists.postgresql.org
Subject: Re: "22.3. Template Databases" documentation is incomplete
Message-ID: <ZT00aqNUUQxhXHBo@momjian.us>
References: <166007719137.995877.13951579839074751714@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="NnWsjr/2iyeHv1KY"
Content-Disposition: inline
In-Reply-To: 
 <166007719137.995877.13951579839074751714@wrigleys.postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/ZT00aqNUUQxhXHBo%40momjian.us>
Precedence: bulk


--NnWsjr/2iyeHv1KY
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Tue, Aug  9, 2022 at 08:33:11PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/14/manage-ag-templatedbs.html
> Description:
> 
> The documentation for creating databases from templates is incomplete, and
> should mention that access privileges are not copied.  So, for example,
> issuing:
> 
> create database newdb with template existingdb owner someuser;
> 
> results in the newly-created database lacking the access privileges that
> exist in the template.
> 
> cf: https://www.postgresql.org/docs/13/manage-ag-templatedbs.html

I have created the attached patch to document this.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.

--NnWsjr/2iyeHv1KY
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment; filename="template.diff"
Content-Transfer-Encoding: quoted-printable

=1B[1mdiff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgm=
l=1B[m
=1B[1mindex 192c500994..b852783a6c 100644=1B[m
=1B[1m--- a/doc/src/sgml/manage-ag.sgml=1B[m
=1B[1m+++ b/doc/src/sgml/manage-ag.sgml=1B[m
=1B[36m@@ -210,7 +210,8 @@=1B[m =1B[mcreatedb -O <replaceable>rolename</rep=
laceable> <replaceable>dbname</replaceable=1B[m
   objects in databases.  For example, if you install the procedural=1B[m
   language <application>PL/Perl</application> in <literal>template1</liter=
al>, it will=1B[m
   automatically be available in user databases without any extra=1B[m
   action being taken when those databases are created.  =1B[32mIt does not=
 copy=1B[m
=1B[32m   database-level <command>GRANT</command> permissions.=1B[m
  </para>=1B[m

  <para>=1B[m

--NnWsjr/2iyeHv1KY--