Isn't it a good idea to move triggers to CreateReplicationSlot() ? as create publication also create replication slot, AFAIK.
thanks Rajesh On Tue, Nov 29, 2022 at 10:35 AM rajesh singarapu <rajesh.rs0...@gmail.com> wrote: > > Thanks Ajin for the clarification. > > This is really a helpful feature. > > On Tue, Nov 29, 2022 at 10:14 AM Ajin Cherian <itsa...@gmail.com> wrote: > > > > On Tue, Nov 29, 2022 at 3:39 PM rajesh singarapu > > <rajesh.rs0...@gmail.com> wrote: > > > > > > Thanks Ajin for the reply. > > > > > > We "Create/Install" these trigger function at the time of "Create > > > publication", (CreatePublication()) > > > but If I create a replication slot using something like "select * from > > > pg_create_logical_replication_slot('test1', 'test_decoding')" > > > we would not install these triggers in the system, so we dont get DDLs > > > decoded, right ? > > > > > > I am a bit new to this postgres, is there anything missing in my > > > understanding ? > > > > > > thanks > > > Raejsh > > > > > > > Currently this feature is only supported using "Create publication". > > We have not added > > a slot level parameter to trigger this. > > > > regards, > > Ajin Cherian > > Fujitsu Australia