Re: Support logical replication of DDLs

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.rs0541@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 <itsajin@gmail.com> wrote:
> >
> > On Tue, Nov 29, 2022 at 3:39 PM rajesh singarapu
> > <rajesh.rs0541@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