Re: Conflict Detection and Resolution

From: Ajin Cherian <itsajin(at)gmail(dot)com>
To: shveta malik <shveta(dot)malik(at)gmail(dot)com>
Cc: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(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>
Subject: Re: Conflict Detection and Resolution
Date: 2024-08-28 05:00:08
Message-ID: CAFPTHDZVtH39HvTLWqsH+UAZTizjC4OoZTmNzsoZ-bjdxc4qaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Aug 28, 2024 at 2:27 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:

>
> 2)
> Currently pg_dump is dumping even the default resolvers configuration.
> As an example if I have not changed default configuration for say
> sub1, it still dumps all:
>
> CREATE SUBSCRIPTION sub1 CONNECTION '..' PUBLICATION pub1 WITH (....)
> CONFLICT RESOLVER (insert_exists = 'error', update_differ =
> 'apply_remote', update_exists = 'error', update_missing = 'skip',
> delete_differ = 'apply_remote', delete_missing = 'skip');
>
> I am not sure if we need to dump default resolvers. Would like to know
> what others think on this.
>
> 3)
> Why in 002_pg_dump.pl we have default resolvers set explicitly?
>
> In 003_pg_dump.pl, default resolvers are not set explicitly, that is the
regexp to check the pg_dump generated command for creating subscriptions.
This is again connected to your 2nd question.

regards,
Ajin Cherian
Fujitsu Australia

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Japin Li 2024-08-28 05:22:42 Re: New function normal_rand_array function to contrib/tablefunc.
Previous Message Thomas Munro 2024-08-28 04:45:45 Re: Streaming read-ready sequential scan code