Re: [DOC] Update ALTER SUBSCRIPTION documentation v3 - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [DOC] Update ALTER SUBSCRIPTION documentation v3
Date
Msg-id 99983036-30d9-d029-1d8d-5ed9cbbb6a42@eisentraut.org
Whole thread Raw
In response to Re: [DOC] Update ALTER SUBSCRIPTION documentation v3  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [DOC] Update ALTER SUBSCRIPTION documentation v3
List pgsql-hackers
On 15.06.23 04:49, Amit Kapila wrote:
> I wanted to backpatch the following change which provides somewhat
> accurate information about what a user needs to do when it faces an
> error.
> To proceed in
> -   this situation, disassociate the subscription from the replication slot by
> -   executing <literal>ALTER SUBSCRIPTION ... SET (slot_name = NONE)</literal>.
> +   this situation, first <literal>DISABLE</literal> the subscription, and then
> +   disassociate it from the replication slot by executing
> +   <literal>ALTER SUBSCRIPTION ... SET (slot_name = NONE)</literal>.
> 
> Now, along with this change, there is a change in errhint as well
> which I am not sure about whether to backpatch or not. I think we have
> the following options (a) commit both doc and code change in HEAD (b)
> commit both doc and code change in v17 when the next version branch
> opens (c) backpatch the doc change and commit the code change in HEAD
> only (d) backpatch the doc change and commit the code change in v17
> (e) backpatch both the doc and code change.

Reading the thread again now, I think this is essentially a bug fix, so 
I don't mind backpatching it.

I wish the errhint would show the actual command to disable the 
subscription.  It already shows the command to detach the replication 
slot, so it would only be consistent to also show the other command.



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: RFC: logical publication via inheritance root?
Next
From: Peter Eisentraut
Date:
Subject: Re: [17] collation provider "builtin"