Re: [DOC] Update ALTER SUBSCRIPTION documentation v3

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, Robert Sjöblom <robert(dot)sjoblom(at)fortnox(dot)se>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [DOC] Update ALTER SUBSCRIPTION documentation v3
Date: 2023-06-16 13:45:06
Message-ID: 99983036-30d9-d029-1d8d-5ed9cbbb6a42@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2023-06-16 14:01:26 Re: [17] collation provider "builtin"
Previous Message Amit Kapila 2023-06-16 13:25:59 Re: RFC: logical publication via inheritance root?