Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled?

Поиск
Список
Период
Сортировка
От Japin Li
Тема Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled?
Дата
Msg-id MEYP282MB1669D80E4B0689E71DD0EF1AB6119@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled?  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On Fri, 16 Jul 2021 at 14:06, Amit Kapila <amit.kapila16@gmail.com> wrote:
> On Fri, Jul 9, 2021 at 8:20 AM Japin Li <japinli@hotmail.com> wrote:
>>
>> On Thu, 08 Jul 2021 at 18:17, Amit Kapila <amit.kapila16@gmail.com> wrote:
>> > On Thu, Jul 8, 2021 at 3:43 PM Japin Li <japinli@hotmail.com> wrote:
>>
>> Please consider review v3 patch. v3-0001 adds slot_name verification in
>> parse_subscription_options() and comments for why we need disable subscription
>> where set slot_name to NONE.
>>
>
> I think we back-patch this bug-fix till v10 where it was introduced
> and update the comments only in HEAD. So, accordingly, I moved the
> changes into two patches and changed the comments a bit. Can you
> please test the first patch in back-branches? I'll also do it
> separately.
>

Thanks for your review, I'll test the in back-branches.

>> v3-0002 comes from Ranier Vilela, it reduce the
>> overhead strlen in ReplicationSlotValidateName().
>>
>
> I think this patch has nothing to do with this bug-fix, so I suggest
> you discuss this in a separate patch. Personally, I don't think it
> will help in reducing any overhead but there doesn't appear to be any
> harm in changing it as proposed.

Agreed.

-- 
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: vignesh C
Дата:
Сообщение: Re: [HACKERS] logical decoding of two-phase transactions
Следующее
От: Yugo NAGATA
Дата:
Сообщение: pgbench: using prepared BEGIN statement in a pipeline could cause an error