Re: CREATE DATABASE Š [ TEMPLATE [=] template ] [ TABLESPACE [=] tablespace_name ] - Mailing list pgsql-general

From David Johnston
Subject Re: CREATE DATABASE Š [ TEMPLATE [=] template ] [ TABLESPACE [=] tablespace_name ]
Date
Msg-id 1380201290433-5772464.post@n5.nabble.com
Whole thread Raw
In response to CREATE DATABASE Š [ TEMPLATE [=] template ] [TABLESPACE [=] tablespace_name ]  (Tim Kane <tim.kane@gmail.com>)
List pgsql-general
Tim Kane wrote
> 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.
>
> Is this a documentation issue, or a behavioural one?  It isn't clear to
> me.

The operative sentence is:

"This tablespace will be the default tablespace used for [new] objects
created in this database."

The implied "new" (inserted because of the word "default" preceding) means
that any existing objects in the template database will be assigned the same
tablespace onto which they are currently attached.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/CREATE-DATABASE-TEMPLATE-template-TABLESPACE-tablespace-name-tp5772451p5772464.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Tim Kane
Date:
Subject: CREATE DATABASE Š [ TEMPLATE [=] template ] [TABLESPACE [=] tablespace_name ]
Next
From: David Johnston
Date:
Subject: Re: CREATE DATABASE Š [ TEMPLATE [=] template ] [ TABLESPACE [=] tablespace_name ]