Re: Local visibility with logical decoding

Antonin Houska <ah@cybertec.at>

From: Antonin Houska <ah@cybertec.at>
To: Marko Tiikkaja <marko@joh.to>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-07-20T16:38:00Z
Lists: pgsql-hackers
Marko Tiikkaja <marko@joh.to> wrote:

> It appears that when logical decoding sends out the data from the output
> plugin, it is not guaranteed that the decoded transaction's effects are
> visible on the source server.  Is this the way it's supposed to work?

Can you please share the test that indicates this behavior? As far as I
understand, the transaction must have been committed before the output plugin
starts to receive the changes.

-- 
Antonin Houska
Web: https://www.cybertec-postgresql.com