Re: Local visibility with logical decoding

2020-07-20 Thread Andres Freund
Hi, On 2020-07-20 17:27:30 +0300, Marko Tiikkaja 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? At the moment the vi

Re: Local visibility with logical decoding

2020-07-20 Thread Marko Tiikkaja
On Mon, Jul 20, 2020 at 7:36 PM Antonin Houska wrote: > Marko Tiikkaja 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 suppose

Re: Local visibility with logical decoding

2020-07-20 Thread Antonin Houska
Marko Tiikkaja 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 beh

Local visibility with logical decoding

2020-07-20 Thread Marko Tiikkaja
Hi, 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? If so, would doing something like this in the output plugin be reasonable?