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

On 8/23/17 12:31, Andres Freund wrote:
> This is "known" behaviour - this is the actual data WAL logged :(. Table
> rewrites generate these pg_temp* tables and log the data there...

Hmm, I see.

Possibly, one way a user could recover from this is to add the column on
the subscriber, rename to table on the subscriber to the temp name, then
wait until all the changes from the rewrite are applied, at which point
it should start complaining in the logs that the original table name
does not exist, then rename the table back.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs