Re: Why is subscription/t/031_column_list.pl failing so much?

On Tue, Feb 6, 2024 at 8:21 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> writes:
> > Yeah, I was worried about that. The other idea I have previously
> > thought was to change Alter Subscription to Drop+Create Subscription.
> > That should also help in bringing stability without losing any
> > functionality.
>
> Hm, why would that fix it?
>

Because for new subscriptions, we will start reading WAL from the
latest WAL insert pointer on the publisher which will be after the
point where publication is created.

> More to the point, aren't these proposals just band-aids that
> would stabilize the test without fixing the actual problem?

Yes, but OTOH, this behavior has been since the beginning of logical
replication. This particular test has just exposed it, so keeping BF
failing for this particular test doesn't sound like the best way to
remember it.

--
With Regards,
Amit Kapila.