diff options
Diffstat (limited to 'doc/src/sgml/ref')
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 8 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 12 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_table_as.sgml | 7 | ||||
| -rw-r--r-- | doc/src/sgml/ref/drop_tablespace.sgml | 7 | ||||
| -rw-r--r-- | doc/src/sgml/ref/grant.sgml | 10 |
5 files changed, 22 insertions, 22 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index feebc4c164..ed2b8e22e7 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_index.sgml,v 1.62 2007/04/06 22:33:41 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_index.sgml,v 1.63 2007/06/03 17:05:53 tgl Exp $ PostgreSQL documentation --> @@ -240,9 +240,9 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] <replaceable class="parameter">name</re <listitem> <para> The tablespace in which to create the index. If not specified, - <xref linkend="guc-default-tablespace"> is used, or the database's - default tablespace if <varname>default_tablespace</> is an empty - string. + <xref linkend="guc-default-tablespace"> is consulted, or + <xref linkend="guc-temp-tablespaces"> for indexes on temporary + tables. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 718ed1cf53..064769cee0 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.107 2007/02/01 00:28:18 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.108 2007/06/03 17:06:03 tgl Exp $ PostgreSQL documentation --> @@ -645,9 +645,8 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: The <replaceable class="PARAMETER">tablespace</replaceable> is the name of the tablespace in which the new table is to be created. If not specified, - <xref linkend="guc-default-tablespace"> is used, or the database's - default tablespace if <varname>default_tablespace</> is an empty - string. + <xref linkend="guc-default-tablespace"> is consulted, or + <xref linkend="guc-temp-tablespaces"> if the table is temporary. </para> </listitem> </varlistentry> @@ -660,9 +659,8 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: associated with a <literal>UNIQUE</literal> or <literal>PRIMARY KEY</literal> constraint will be created. If not specified, - <xref linkend="guc-default-tablespace"> is used, or the database's - default tablespace if <varname>default_tablespace</> is an empty - string. + <xref linkend="guc-default-tablespace"> is consulted, or + <xref linkend="guc-temp-tablespaces"> if the table is temporary. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index 36348c8ad4..edc9ce5e6c 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.36 2006/09/18 19:54:01 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.37 2007/06/03 17:06:12 tgl Exp $ PostgreSQL documentation --> @@ -184,9 +184,8 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable>table_name The <replaceable class="PARAMETER">tablespace</replaceable> is the name of the tablespace in which the new table is to be created. If not specified, - <xref linkend="guc-default-tablespace"> is used, or the database's - default tablespace if <varname>default_tablespace</> is an empty - string. + <xref linkend="guc-default-tablespace"> is consulted, or + <xref linkend="guc-temp-tablespaces"> if the table is temporary. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/drop_tablespace.sgml b/doc/src/sgml/ref/drop_tablespace.sgml index bf570d851a..31a4888141 100644 --- a/doc/src/sgml/ref/drop_tablespace.sgml +++ b/doc/src/sgml/ref/drop_tablespace.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/drop_tablespace.sgml,v 1.6 2007/01/31 23:26:03 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/drop_tablespace.sgml,v 1.7 2007/06/03 17:06:13 tgl Exp $ PostgreSQL documentation --> @@ -36,7 +36,10 @@ DROP TABLESPACE [ IF EXISTS ] <replaceable class="PARAMETER">tablespacename</rep The tablespace must be empty of all database objects before it can be dropped. It is possible that objects in other databases might still reside in the tablespace even if no objects in the current database are using - the tablespace. + the tablespace. Also, if the tablespace is listed in the <xref + linkend="guc-temp-tablespaces"> setting of any active session, the + <command>DROP</> might fail due to temporary files residing in the + tablespace. </para> </refsect1> diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index a4c3b0d440..e8e93bf9ab 100644 --- a/doc/src/sgml/ref/grant.sgml +++ b/doc/src/sgml/ref/grant.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.65 2007/04/07 03:48:25 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.66 2007/06/03 17:06:13 tgl Exp $ PostgreSQL documentation --> @@ -211,10 +211,10 @@ GRANT <replaceable class="PARAMETER">role</replaceable> [, ...] TO <replaceable have this privilege for the containing schema. </para> <para> - For tablespaces, allows tables and indexes to be created within the - tablespace, and allows databases to be created that have the tablespace - as their default tablespace. (Note that revoking this privilege - will not alter the placement of existing objects.) + For tablespaces, allows tables, indexes, and temporary files to be + created within the tablespace, and allows databases to be created that + have the tablespace as their default tablespace. (Note that revoking + this privilege will not alter the placement of existing objects.) </para> </listitem> </varlistentry> |