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-27 10:33:30
Message-ID: CAJpy0uCo+7xZ-0Mm_ePquB3g1F9V99-knGtXGcmZaSopdoUaAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

[1]: https://www.postgresql.org/message-id/CAJpy0uAqegGDbuJk3Z-ku8wYFZyPv7C1KmHCkJ3885O%2Bj5enFg%40mail.gmail.com

thanks
Shveta

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jelte Fennema-Nio 2024-06-27 10:43:20 Re: Support a wildcard in backtrace_functions
Previous Message ikedarintarof 2024-06-27 10:27:33 Re: doc: modify the comment in function libpqrcv_check_conninfo()