On Tue, Nov 29, 2022 at 1:29 PM rajesh singarapu <rajesh.rs0...@gmail.com> wrote: > > One question, > > I understand that we create/enable triggers on create publication command > flow. > I am wondering how this works in case of logical replication using slots. > > > thanks > Rajesh > Rajesh,
The triggers functions when invoked write these ddl commands to WAL and the logical decoding WAL sender which is registered for that replication slot decodes the WAL logged DDL commands and sends them as logical replication messages to the subscriber side. The apply worker on the subscriber side, then converts these messages to actual DDL commands and executes them. regards, Ajin Cherian Fujitsu Australia
