Re: [BUGS] BUG #14785: Logical replication does not work after addinga column. Bug? - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: [BUGS] BUG #14785: Logical replication does not work after addinga column. Bug?
Date
Msg-id 03e54401-2ea1-fa0c-3eec-54b6b930e225@2ndquadrant.com
Whole thread Raw
In response to Re: [BUGS] BUG #14785: Logical replication does not work after addinga column. Bug?  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-bugs
On 9/13/17 09:46, Peter Eisentraut wrote:
> 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.

Thoughts on this patch?  Might be good to include in PG10.

-- 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14818: PLPGSQL: write access to a field of an array of records (well defined)
Next
From: fte@nct.ru
Date:
Subject: [BUGS] BUG #14819: postgres_fwd could not load library