Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oVm1w-0001mc-Js for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Sep 2022 03:47:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oVm1v-0003U6-Fu for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Sep 2022 03:47:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oVm1v-0003Tx-5E for pgsql-hackers@lists.postgresql.org; Wed, 07 Sep 2022 03:47:11 +0000 Received: from mail-yb1-xb29.google.com ([2607:f8b0:4864:20::b29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oVm1r-00046O-ML for pgsql-hackers@lists.postgresql.org; Wed, 07 Sep 2022 03:47:10 +0000 Received: by mail-yb1-xb29.google.com with SMTP id c9so19733955ybf.5 for ; Tue, 06 Sep 2022 20:47:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date; bh=OMb8GXV+v0SWzPvb60yQDzFs4aTjpW9hK5gTRDy/4DM=; b=SIVdLNm89WCPfkhqcbJoz8Qe33uBKKAN38XNjLCzY22sleY/OS5OA9lOq6aOBaIjel iU0fCKyDgFS/t0Njyz/5NY4t9pYi+1mSuX3iVYSJ7V6CrJpETaD7KqrSm2MHbsXXmdqz +2jqXcYeDO23blLAnAwLNuITYH7CJosl11dCtjyiUFTGliMTBGfMXHEo08cbAk91wlpk 43xzz89FWLpJx8fBFrJjH38IGznpyzMCg5lHwA19uUzjbfU6yZNHWkSwqg6CPJNxI47t 32sPQf8sVV4rnJ676aQqVt8dkdubCEMBrpp2GzIDL9RezVolE9vnH1xqxV4UrXyCUciv pCrQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date; bh=OMb8GXV+v0SWzPvb60yQDzFs4aTjpW9hK5gTRDy/4DM=; b=CIajBUJkd9LJszFLYb6wlW7Q0qevQwGXBjoMa9Et5gGFL8y9oqYfsvCuZzcWeDBnvy jtSaynMEblB6yffIJM+SzO0ODUbai0c5N2KS2ObGLlicHkt8TWhD80PCNl6p+hfzHNfu t90Yvj2eMLZ8V98O9QDyeb1Wnm2WtS0dvnmXwPT4CmC40HqJ43bVo167qnTQ5yzBO6uH Ky7d3OBFKgNzx35WbTdeXXpLUHWl7iVrWezrTQbV7M2l1cZQFeaZm6xgjJjYUSni2ozE V8jp6/eRchTSHtkneeQguq53wrXKZJTzvZ/fTORw7dWgIxm3OPjl+xO46fWIbEO2lwFe y4OQ== X-Gm-Message-State: ACgBeo2OiHDA1/kJig7bdDtljdK9r6421e52/WB9s4z8flNfeDa/91+2 55c+lURd5bpTQwO0gfvZ4WQvJbKtPdAKlTVQemI= X-Google-Smtp-Source: AA6agR5YkGMns304SBomWClj5Q+fbYJCGwZr/fU4NfmBSNqAjN/OZ3CqFMkmY0fACdgSThv/yhRN0+fLN5OF2WUt+84= X-Received: by 2002:a25:cec8:0:b0:6a8:fd3a:6051 with SMTP id x191-20020a25cec8000000b006a8fd3a6051mr1371415ybe.448.1662522425260; Tue, 06 Sep 2022 20:47:05 -0700 (PDT) MIME-Version: 1.0 References: <20220904081821.bck6q2j6gfp3p2im@alvherre.pgsql> In-Reply-To: From: Amit Kapila Date: Wed, 7 Sep 2022 09:16:54 +0530 Message-ID: Subject: Re: pgsql: Add ALTER SUBSCRIPTION ... SKIP. To: Masahiko Sawada Cc: Alvaro Herrera , Amit Kapila , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Sep 6, 2022 at 7:40 PM Masahiko Sawada wrote: > > > > I think they should say something like > > > > > > "logical replication starts skipping transaction with LSN %X/%X" > > > "logical replication completed skipping transaction with LSN %X/%X" > > > > > > > This looks better to me. > > +1 > > > If you find the above argument to > > differentiate between the start and end LSN convincing then we can > > think of replacing "with" in the above messages with "finished at". I > > see your point related to using "finished at" for PREPARE may not be a > > good idea but I don't have better ideas for the same. > > Given that the user normally doesn't need to be aware of the > difference between start LSN and end LSN in the context of using this > feature, I think we can use "with LSN %X/%X". > Fair enough. Alvaro, would you like to push your proposed change? Otherwise, I am happy to take care of this. -- With Regards, Amit Kapila.