> On Apr 18, 2023, at 03:45, Robert Sjöblom <robert.sjob...@fortnox.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.