diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-03-12 13:28:52 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-03-12 13:32:28 -0300 |
| commit | 63cbee6a786028790abc6ae9b9606366bae5e01d (patch) | |
| tree | 736c90cb503fcdb795c658e73f8fe6fdd9d2daf7 /doc/src | |
| parent | 3beb46ae8118f64d94518ba105b5e5c79e2ce194 (diff) | |
doc: Reword restriction on partition keys in unique indexes
New wording from David G. Johnston, who noticed the unreadable original
also. Include his suggested test case as well.
Fix a typo I noticed elsewhere while doing this.
Discussion: https://postgr.es/m/CAKFQuwY4Ld7ecxL_KAmaxwt0FUu5VcPPN2L4dh+3BeYbrdBa5g@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 9e8e9d8f1cd..14a43b45e9a 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -791,11 +791,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM </para> <para> - When used on partitioned tables, unique constraints must include all the - columns of the partition key. - If any partitions are in turn partitioned, all columns of each partition - key are considered at each level below the <literal>UNIQUE</literal> - constraint. + When establishing a unique constraint for a multi-level partition + hierarchy, all the columns in the partition key of the target + partitioned table, as well as those of all its descendant partitioned + tables, must be included in the constraint definition. </para> </listitem> </varlistentry> |