Re: pgsql: Add ALTER SUBSCRIPTION ... SKIP. - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pgsql: Add ALTER SUBSCRIPTION ... SKIP.
Date
Msg-id 20220904081821.bck6q2j6gfp3p2im@alvherre.pgsql
Whole thread Raw
Responses Re: pgsql: Add ALTER SUBSCRIPTION ... SKIP.
List pgsql-hackers
On 2022-Mar-22, Amit Kapila wrote:

> Add ALTER SUBSCRIPTION ... SKIP.

There are two messages here that seem oddly worded.

msgid "start skipping logical replication transaction finished at %X/%X"
msgid "done skipping logical replication transaction finished at %X/%X"

Two complaints here.  First, the phrases "start / finished" and "done /
finished" look very strange.  It took me a while to realize that
"finished" refers to the LSN, not to the skipping operation.  Do we ever
talk about a transaction "finished at XYZ" as opposed to a transaction
whose LSN is XYZ?  (This became particularly strange when I realized
that the LSN might come from a PREPARE.)

Second, "logical replication transaction".  Is it not a regular
transaction that we happen to be processing via logical replication?

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"

Other ideas?

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
Officer Krupke, what are we to do?
Gee, officer Krupke, Krup you! (West Side Story, "Gee, Officer Krupke")



pgsql-hackers by date:

Previous
From: Ibrar Ahmed
Date:
Subject: Re: pgbench: using prepared BEGIN statement in a pipeline could cause an error
Next
From: Dilip Kumar
Date:
Subject: Re: Add 64-bit XIDs into PostgreSQL 15