aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorMagnus Hagander <magnus@hagander.net>2024-01-11 14:27:10 +0100
committerMagnus Hagander <magnus@hagander.net>2024-01-11 14:27:10 +0100
commitba2d2784f3f83277de6f9c17505229fa3f2f6d5c (patch)
treeb604cf90ef95499c2b614f427fa2ea39dc207df2 /doc/src
parent6f97ef05d62a9c4ed5c53e98ac8a44cf3e0a2780 (diff)
downloadpostgresql-ba2d2784f3f83277de6f9c17505229fa3f2f6d5c.tar.gz
postgresql-ba2d2784f3f83277de6f9c17505229fa3f2f6d5c.zip
Fix omission in partitioning limitation documentation
UNIQUE and PRIMARY KEY constraints can be created on ONLY the partitioned table. We already had an example demonstrating that, but forgot to mention it in the documentation of the limits of partitioning. Author: Laurenz Albe Reviewed-By: shihao zhong, Shubham Khanna, Ashutosh Bapat Backpatch-through: 12 Discussion: https://postgr.es/m/167299368731.659.16130012959616771853@wrigleys.postgresql.org
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ddl.sgml4
1 files changed, 3 insertions, 1 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index 22d04006ade..01b1d82b0de 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -4348,7 +4348,9 @@ ALTER INDEX measurement_city_id_logdate_key
Using <literal>ONLY</literal> to add or drop a constraint on only
the partitioned table is supported as long as there are no
partitions. Once partitions exist, using <literal>ONLY</literal>
- will result in an error. Instead, constraints on the partitions
+ will result in an error for any constraints other than
+ <literal>UNIQUE</literal> and <literal>PRIMARY KEY</literal>.
+ Instead, constraints on the partitions
themselves can be added and (if they are not present in the parent
table) dropped.
</para>