Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled? - Mailing list pgsql-hackers

From Japin Li
Subject Re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled?
Date
Msg-id SYYP282MB1678B7024191E2FAC29F90B1B6199@SYYP282MB1678.AUSP282.PROD.OUTLOOK.COM
Whole thread Raw
In response to re: Why ALTER SUBSCRIPTION ... SET (slot_name='none') requires subscription disabled?  (Ranier Vilela <ranier.vf@gmail.com>)
List pgsql-hackers
On Thu, 08 Jul 2021 at 01:32, Ranier Vilela <ranier.vf@gmail.com> wrote:
>>OTOH, when I execute ALTER SUBSCRIPTION ... SET (slot_name=''), it doesn't
> complain. However,
>>SELECT select pg_create_logical_replication_slot('', 'pgoutput') complains
> slot name is too
>>short. Although, the slot will be created at publisher, and validate the
> slot name, IMO, we
>>can also validate the slot_name in parse_subscription_options() to get the
> error early.
>>Attached fixes it. Any thoughts?
> I think that this fix is better after the check if the name is equal to
> "none".
> Most of the time it will be "none" .
> While this, reduce the overhead with strlen into
> ReplicationSlotValidateName can it might be worth it.
>
> For convenience, I have attached a new version.
>

Thanks for your review! LGTM.

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



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: [PATCH] expand the units that pg_size_pretty supports on output
Next
From: Bharath Rupireddy
Date:
Subject: Re: Refactor "mutually exclusive options" error reporting code in parse_subscription_options