diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-12-17 15:37:40 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-12-17 15:37:40 -0300 |
| commit | ca4103025dfe26eaaf6a500dec9170fbb176eebc (patch) | |
| tree | 8ef17f3b2b9ed1c3f5fbcf8215a302b01156c42d /doc/src | |
| parent | 1e6240a3fe919e19676875927681a861e13f93c2 (diff) | |
| download | postgresql-ca4103025dfe26eaaf6a500dec9170fbb176eebc.tar.gz postgresql-ca4103025dfe26eaaf6a500dec9170fbb176eebc.zip | |
Fix tablespace handling for partitioned tables
When partitioned tables were introduced, we failed to realize that by
copying the tablespace handling for other relation kinds with no
physical storage we were causing the secondary effect that their
partitions would not automatically inherit the tablespace setting. This
is surprising and unhelpful, so change it to adopt the behavior
introduced in pg11 (commit 33e6c34c3267) for partitioned indexes: the
parent relation remembers the tablespace specification, which is then
used for any new partitions that don't declare one.
Because this commit changes behavior of the TABLESPACE clause for
partitioned tables (it's no longer a no-op), it is not backpatched.
Author: David Rowley, Álvaro Herrera
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/CAKJS1f9SxVzqDrGD1teosFd6jBMM0UEaa14_8mRvcWE19Tu0hA@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index d3e33132f37..94f7651c34d 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1216,7 +1216,11 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM of the tablespace in which the new table is to be created. If not specified, <xref linkend="guc-default-tablespace"/> is consulted, or - <xref linkend="guc-temp-tablespaces"/> if the table is temporary. + <xref linkend="guc-temp-tablespaces"/> if the table is temporary. For + partitioned tables, since no storage is required for the table itself, + the tablespace specified here only serves to mark the default tablespace + for any newly created partitions when no other tablespace is explicitly + specified. </para> </listitem> </varlistentry> |