Re: Local visibility with logical decoding

From: Antonin Houska <ah(at)cybertec(dot)at>
To: Marko Tiikkaja <marko(at)joh(dot)to>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Local visibility with logical decoding
Date: 2020-07-20 16:38:00
Message-ID: 16133.1595263080@antos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Marko Tiikkaja <marko(at)joh(dot)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

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2020-07-20 16:44:39 Re: Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING
Previous Message Dmitry Dolgov 2020-07-20 16:02:16 Re: [HACKERS] [PATCH] Generic type subscripting