Re: Replica Identity check of partition table on subscriber
От
Amit Kapila
Тема
Re: Replica Identity check of partition table on subscriber
Дата
Msg-id
CAA4eK1JK7RNNMO5M2Q+jrRbEUO2dBf9FzWwE3X-=NpmiMkRv2A@mail.gmail.com
Ответ на
Re: Replica Identity check of partition table on subscriber (Amit Langote)
Список
Дерево обсуждения
Replica Identity check of partition table on subscriber "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
RE: Replica Identity check of partition table on subscriber "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
RE: Replica Identity check of partition table on subscriber "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
RE: Replica Identity check of partition table on subscriber "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
RE: Replica Identity check of partition table on subscriber "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
RE: Replica Identity check of partition table on subscriber "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
RE: Replica Identity check of partition table on subscriber "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
RE: Replica Identity check of partition table on subscriber "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
RE: Replica Identity check of partition table on subscriber "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
RE: Replica Identity check of partition table on subscriber "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
RE: Replica Identity check of partition table on subscriber "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
RE: Replica Identity check of partition table on subscriber "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
RE: Replica Identity check of partition table on subscriber "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
RE: Replica Identity check of partition table on subscriber "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Kapila <amit.kapila16@gmail.com>
Re: Replica Identity check of partition table on subscriber Amit Langote <amitlangote09@gmail.com>
RE: Replica Identity check of partition table on subscriber "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>
On Thu, Jun 16, 2022 at 11:43 AM Amit Langote wrote: > > On Thu, Jun 16, 2022 at 2:07 PM shiy.fnst@fujitsu.com > wrote: > > On Wed, Jun 15, 2022 8:30 PM Amit Kapila wrote: > > > I have pushed the first bug-fix patch today. > > > > Attached the remaining patches which are rebased. > > Thanks. > > Comments on v9-0001: > > + * Don't throw any error here just mark the relation entry as not updatable, > + * as replica identity is only for updates and deletes but inserts can be > + * replicated even without it. > > I know you're simply copying the old comment, but I think we can > rewrite it to be slightly more useful: > > We just mark the relation entry as not updatable here if the local > replica identity is found to be insufficient and leave it to > check_relation_updatable() to throw the actual error if needed. > I am fine with improving this comment but it would be better if in some way we keep the following part of the comment: "as replica identity is only for updates and deletes but inserts can be replicated even without it." as that makes it more clear why it is okay to just mark the entry as not updatable. One idea could be: "We just mark the relation entry as not updatable here if the local replica identity is found to be insufficient and leave it to check_relation_updatable() to throw the actual error if needed. This is because replica identity is only for updates and deletes but inserts can be replicated even without it.". Feel free to suggest if you have any better ideas? -- With Regards, Amit Kapila.
В списке pgsql-hackers по дате отправления
От: Yugo NAGATA
Дата:
От: Amit Langote
Дата: