From c9d6a45724d642a00bd2b4c0f082cf4e1eb76e29 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 27 Jun 2018 07:40:18 +0200 Subject: [PATCH] doc: Document some nuances of logical replication of TRUNCATE --- doc/src/sgml/logical-replication.sgml | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index 1e7a54c8e3..59de6bcc0a 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -371,6 +371,22 @@ + + + Replication of TRUNCATE commands is supported, but + some care must be taken when truncating groups of tables connected by + foreign keys. When replicating a truncate action, the subscriber will + truncate the same group of tables that was truncated on the publisher, + either explictly specified or implicitly collected via + CASCADE, minus tables that are not part of the + subscription. This will work correctly if all affected tables are part + of the same subscription. But if some tables to be truncated on the + subscriber have foreign-key links to tables that are not part of the same + (or any) subscription, then the application of the truncate action on the + subscriber will fail. + + + Large objects (see ) are not replicated. -- 2.40.0