change_comments_1.patch.txt

text/plain

Filename: change_comments_1.patch.txt
Type: text/plain
Part: 0
Message: Re: Data is copied twice when specifying both child and parent table in publication
diff --git a/src/backend/commands/subscriptioncmds.c b/src/backend/commands/subscriptioncmds.c
index 82941a0ce7..44fc371d2c 100644
--- a/src/backend/commands/subscriptioncmds.c
+++ b/src/backend/commands/subscriptioncmds.c
@@ -1949,22 +1949,15 @@ fetch_table_list(WalReceiverConn *wrconn, List *publications)
 
 	initStringInfo(&cmd);
 
-	/*
-	 * Get namespace, relname and column list (if supported) of the tables
-	 * belonging to the specified publications.
-	 *
-	 * Get the list of tables from the publisher. The partition table whose
-	 * ancestor is also in this list will be ignored, otherwise the initial
-	 * data in the partition table would be replicated twice.
-	 *
-	 * From version 16, the parameter of the function
-	 * pg_get_publication_tables can be an array of publications. The
-	 * partition table whose ancestor is also published in this publication
-	 * array will be filtered out in this function.
-	 */
+	/* Get the list of tables from the publisher. */
 	if (server_version >= 160000)
 	{
 		/*
+		 * From version 16, we allowed passing multiple publications to the
+		 * function pg_get_publication_tables. This helped to filter out the
+		 * partition table whose ancestor is also published in this publication
+		 * array.
+		 *
 		 * Join pg_get_publication_tables with pg_publication to exclude
 		 * non-existing publications.
 		 */