Re: Conflict detection for multiple_unique_conflicts in logical replication - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Conflict detection for multiple_unique_conflicts in logical replication
Date
Msg-id CAA4eK1LZcr1V06a3_gYTXmR7ez3AhBm6BtA8wH_z0ZwDh8Yk5Q@mail.gmail.com
Whole thread Raw
In response to Re: Conflict detection for multiple_unique_conflicts in logical replication  (vignesh C <vignesh21@gmail.com>)
List pgsql-hackers
On Tue, Mar 25, 2025 at 8:51 AM vignesh C <vignesh21@gmail.com> wrote:
>
> On Fri, 21 Mar 2025 at 16:44, Nisha Moond <nisha.moond412@gmail.com> wrote:
> >
> > On Fri, Mar 21, 2025 at 3:38 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> > >
> > > On Fri, Mar 21, 2025 at 1:48 PM Zhijie Hou (Fujitsu)
> > > <houzj.fnst@fujitsu.com> wrote:
> > > >
> > > > On Fri, Mar 21, 2025 at 12:50 PM Nisha Moond wrote:
> > > >
> > > > > Thanks, Hou-san, for the review and fix patches. I’ve incorporated
> > > > > your suggestions.
> > > > > Attached are the v7 patches, including patch 002, which implements
> > > > > stats collection for 'multiple_unique_conflicts' in pg_stat_subscription_stats.
> > > >
> > > > Thanks for updating the patches.
> > > >
> > > > Here are some more comments:
> > > >
> > > > 1.
> > > >
> > > > The comments atop of ReportApplyConflict() should be updated to reflect the
> > > > updates made to the input parameters.
> > > >
> > >
> > > Right, I also noticed this and updated it in the attached. Apart from
> > > this, I have made a number of cosmetic changes in the attached. Please
> > > review and include it in the next version unless you see any problem
> > > with it.
> > >
> >
> > Thanks for the review.
> >
> > I’ve incorporated the changes and also addressed Hou-san’s comments
> > from [1] with suggested changes.
> >
> > Attached are the v8 patches.
>
> Shouldn't these statements be the other way:
> pass('multiple_unique_conflicts detected during update');
> should have been:
> pass('multiple_unique_conflicts detected during insert');
>
> and
> pass('multiple_unique_conflicts detected during insert');
> should have been:
> pass('multiple_unique_conflicts detected during update');
>
> if you are ok with above change, the attached patch has the change for the same.
>

LGTM and thanks for the report. I'll push this change.

--
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: pgoutput: comment atop rel_sync_cache_publication_cb() has an inconsistency
Next
From: Bertrand Drouvot
Date:
Subject: Re: Fix 035_standby_logical_decoding.pl race conditions