On 06.12.21 15:50, Avi Weinberg wrote:
Does it mean that populating each table is done in a single transaction? If so, when I have tables with foreign keys between them, is it guaranteed that logical replication will populates the tables in the proper order so the foreign key will be enforced? Or maybe the foreign keys are disabled during initial sync and only after all tables are populated the FKs are enabled again.
Foreign keys are disabled on logical replication subscribers.