From f73293aba4d43e48707e361b2b1ef1465fef46e0 Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Wed, 29 May 2019 11:19:06 -0400 Subject: [PATCH] Fix some documentation about FKs and partitioned tables This got forgotten in f56f8f which has added foreign key support for partitioned tables. In passing, add a mention about caveats applying to tables partitioned using inheritance regarding indexes and foreign keys. Author: Paul A Jungwirth Reviewed-by: Amit Langote, Michael Paquier Discussion: https://postgr.es/m/CA+renyUuSmYgmZjKc_DfUNVZ0uttF91-FwhDVW3F7WEPj0jL5w@mail.gmail.com --- doc/src/sgml/ddl.sgml | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index a0a7435a03..5fe5f86402 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -3964,14 +3964,6 @@ ALTER TABLE measurement ATTACH PARTITION measurement_y2008m02 - - - While primary keys are supported on partitioned tables, foreign - keys referencing partitioned tables are not supported. (Foreign key - references from a partitioned table to some other table are supported.) - - - BEFORE ROW triggers, if necessary, must be defined @@ -4354,6 +4346,14 @@ ALTER TABLE measurement_y2008m02 INHERIT measurement; + + + Indexes and foreign key constraints apply to single tables and not + to their inheritance children, hence they have some + caveats to be aware of. + + + The schemes shown here assume that the values of a row's key column(s) -- 2.40.0