Hi, As part of a discussion in [1], I am starting this thread to address the issue reported for foreign tables.
Logical replication of foreign tables is not supported, and we throw an error in this case. But when we create a publication on a partitioned table that has a foreign table as a partition, the initial sync of such a table is successful. We should also throw an error in such cases. With this patch, we will throw an error when we try to create a publication on (or add to an existing publication) a partitioned table with a foreign table as its partition or attach such a table to existing published tables. [1] : https://www.postgresql.org/message-id/CAA4eK1Lhh4SgiYQLNiWSNKGdVSzbd53%3Dsr2tQCKooEphDkUtgw%40mail.gmail.com Thanks and Regards, Shlok Kyal
v1-0001-Restrict-publishing-of-partitioned-table-with-a-f.patch
Description: Binary data