Re: Conflict Detection and Resolution

From: shveta malik <shveta(dot)malik(at)gmail(dot)com>
To: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Jan Wieck <jan(at)wi3ck(dot)info>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>
Subject: Re: Conflict Detection and Resolution
Date: 2024-06-28 09:45:19
Message-ID: CAJpy0uBZX-6CN1bO_4RiTKfxDQnxOe6VnLXrxaVHP1B1VhHNGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jun 27, 2024 at 4:03 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
> On Thu, Jun 27, 2024 at 8:44 AM Nisha Moond <nisha(dot)moond412(at)gmail(dot)com> wrote:
> >
> > Please find the attached 'patch0003', which implements conflict
> > resolutions according to the global resolver settings.
>
> Thanks for providing the resolver patch.
>
> Please find new patches attached. Changes:
>
> patch002:
> --Fixed CFBot compilation failure where a header file was not included
> in meson.build
> --Also this is the correct version of patch. Previous email has
> attached an older version by mistake.
>
> patch004:
> This is a WIP progress which attempts to implement Configuration of
> table-level resolvers . It has below changes:
> --Alter table SET CONFLICT RESOLVER.
> --Alter table RESET CONFLICT RESOLVER. <Note that these 2 commands
> also take care of resolvers inheritance for partition tables as
> discussed in [1]>.
> --Resolver inheritance support during 'Alter table ATTACH PARTITION'.
> --Resolver inheritance removal during 'Alter table DETACH PARTITION'.
>
> Pending:
> --Resolver Inheritance support during 'CREATE TABLE .. PARTITION OF
> ..'.
> --Using tabel-level resolver while resolving conflicts. (Resolver
> patch003 still relies on global resolvers).
>
> Please refer [1] for the complete proposal for table-level resolvers.
>

Please find v2 attached. Changes are in patch004 only, which are:

--Resolver Inheritance support during 'CREATE TABLE .. PARTITION OF'.
--SPLIT and MERGE partition review and testing (it was missed earlier).
--Test Cases added for all above cases.

thanks
Shveta

Attachment Content-Type Size
v2-0002-DDL-command-to-configure-Global-Conflict-Resolver.patch application/octet-stream 26.1 KB
v2-0003-Implement-conflict-resolution-for-INSERT-UPDATE-a.patch application/octet-stream 34.4 KB
v2-0004-Configure-table-level-conflict-resolvers.patch application/octet-stream 49.0 KB
v2-0001-Detect-and-log-conflicts-in-logical-replication.patch application/octet-stream 89.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2024-06-28 09:45:22 Re: walsender.c comment with no context is hard to understand
Previous Message Jelte Fennema-Nio 2024-06-28 08:59:24 Re: Improve EXPLAIN output for multicolumn B-Tree Index