Re: Logical Replication Sync Validation

> On Apr 18, 2023, at 03:45, Robert Sjöblom <robert(dot)sjoblom(at)fortnox(dot)se> wrote:
> I'm aware of that. But you can, however, do something like:
>
> SELECT * FROM FOO WHERE CTID = (SELECT MAX(CTID) FROM FOO);
>
> on both sides. The idea being that if I change FOO, the CTID of the changed row will not be the same on both sides, but the CTID will point to the changed row on both sides. Or am I not understanding it correctly?

CTIDs are not monotonically increasing; they're locator in the file that holds the table data. There's no reason to believe that a record on the subscriber will happen to land in any particular position.