Search Postgresql Archives

Re: CREATE DATABASE Š [ TEMPLATE [=] template ] [ TABLESPACE [=] tablespace_name ]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux