Re: Skipping logical replication transactions on subscriber side

On Wed, Oct 27, 2021 at 8:32 AM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>
> On Tue, Oct 26, 2021 at 7:29 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> >
> >
> > You have a point. The other alternatives on this line could be:
> >
> > Alter Subscription <sub_name> SKIP ( subscription_parameter [=value] [, ... ] );
> >
> > where subscription_parameter can be one of:
> > xid = <xid_val>
> > lsn = <lsn_val>
> > ...
>
> Looks better.
>
> BTW how useful is specifying LSN instead of XID in practice? Given
> that this skipping behavior is used to skip the particular transaction
> (or its part of operations) in question, I’m not sure specifying LSN
> or time is useful.
>

I think if the user wants to skip multiple xacts, she might want to
use the highest LSN to skip instead of specifying individual xids.

--
With Regards,
Amit Kapila.