Small documentation enhancement for default_tablespace
Hello,
last week someone raised in a german webforum the question why
"default_tablespace" is not used for "CREATE DATABASE". After a brief
discussion on irc (thanks RhodiumToad) I added a note to the
documentation mentioning this point.
Patch attached.
Bye
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project
Attachments:
default_tablespace_not_for_databases.patchtext/x-diff; name=default_tablespace_not_for_databases.patchDownload
*** a/doc/src/sgml/config.sgml
--- b/doc/src/sgml/config.sgml
***************
*** 4357,4362 **** COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
--- 4357,4368 ----
</para>
<para>
+ This variable is also not used for creating databases. Tablespace
+ information are copied from the template database (usually
+ <literal>template1</literal>) instead.
+ </para>
+
+ <para>
For more information on tablespaces,
see <xref linkend="manage-ag-tablespaces">.
</para>
"Andreas 'ads' Scherbaum" <adsmail@wars-nicht.de> writes:
last week someone raised in a german webforum the question why
"default_tablespace" is not used for "CREATE DATABASE". After a brief
discussion on irc (thanks RhodiumToad) I added a note to the
documentation mentioning this point.
Patch attached.
Personally I'd have said the description of default_tablespace was
clear enough about this already, but I added the following somewhat
revised text.
<para>
This variable is also not used when creating databases.
By default, a new database inherits its tablespace setting from
the template database it is copied from.
</para>
regards, tom lane