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

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: yxq(at)o2(dot)pl, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14785: Logical replication does not work after adding a column. Bug?
Date: 2017-09-13 13:46:43
Message-ID: def3109a-81b6-e6ab-e632-31c34434a90f@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 8/23/17 17:39, Andres Freund wrote:
> I think we could actually kind of solve this by just ignoring pg_temp*
> tables in the output plugin. Given we don't do DDL replication at this
> point, that seems good enough. "all" we need is a way to make sure we're
> not confusing the pg_temp* tables with a table the user has declared as
> pg_temp - but we could check subscription state for that?

How about this patch? There is some heuristic element in there, but it
seems better than failing as we currently do.

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

Attachment Content-Type Size
0001-Handle-heap-rewrites-better-in-logical-replication.patch text/plain 5.0 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-09-13 13:54:48 Re: BUG #14814: Documentation errors for OpenBSD
Previous Message Alvaro Herrera 2017-09-13 13:25:03 Re: BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns