Odp: Re: [BUGS] BUG #14785: Logical replication does not work after adding a column. Bug?

From: yxq <yxq(at)o2(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org <pgsql-bugs(at)postgresql(dot)org>
Subject: Odp: Re: [BUGS] BUG #14785: Logical replication does not work after adding a column. Bug?
Date: 2017-08-22 20:54:17
Message-ID: 8950ca33bcb04873991340938e88ab67@grupawp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dnia 22 sierpnia 2017 21:34 Andres Freund &lt;andres(at)anarazel(dot)de&gt; napisał(a): Hi, On 2017-08-22 15:22:41 -0400, Peter Eisentraut wrote: When you add a column on the publication side, you also need to add it on the subscription side, otherwise there is nowhere to put the data. Op&#39;s sql shows that that&#39;s done. The problem is the table rewrite not being handled nicely by logical decoding / replication. - Andres Yes, I added the column first to the Slave, then added to the Master. I also checked the reverse case: I added the column first to the Master, then added to the Slave. The problem is the same. yxq

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2017-08-23 00:55:07 Re: Fwd: PostgreSQL 9.4.13 is facing issue in shutting down
Previous Message Andres Freund 2017-08-22 19:34:18 Re: BUG #14785: Logical replication does not work after adding a column. Bug?