| From: | Tim Kane <tim(dot)kane(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | CREATE DATABASE [ TEMPLATE [=] template ] [ TABLESPACE [=] tablespace_name ] |
| Date: | 2013-09-26 11:27:16 |
| Message-ID: | CE69D8A4.3E8A6%tim.kane@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a question regarding the behaviour of CREATE DATABASE when used with
TEMPLATE and TABLESPACE options together.
The documentation describes the tablespace parameter as:
The name of the tablespace that will be associated with the new database, or
DEFAULT to use the template database's tablespace. This tablespace will be
the default tablespace used for objects created in this database. See CREATE
TABLESPACE
<http://www.postgresql.org/docs/9.3/static/sql-createtablespace.html> for
more information.
I would take that to mean that all objects from the template will be created
in the new database within the specified tablespace.
However it seems this is not the case, and that the newly specified
tablespace will only apply to objects that do not already have a tablespace
defined in the templated database.
Is this a documentation issue, or a behavioural one? It isn't clear to me.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2013-09-26 13:14:50 | Re: CREATE DATABASE [ TEMPLATE [=] template ] [ TABLESPACE [=] tablespace_name ] |
| Previous Message | Shigeru Hanada | 2013-09-26 02:13:52 | Re: partitioned table + postgres_FDW not working in 9.3 |