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 def3109a-81b6-e6ab-e632-31c34434a90f@2ndquadrant.com
Whole thread Raw
In response to Re: [BUGS] BUG #14785: Logical replication does not work afteradding a column. Bug?  (Andres Freund <andres@anarazel.de>)
Responses Re: [BUGS] BUG #14785: Logical replication does not work after addinga column. Bug?
Re: [BUGS] BUG #14785: Logical replication does not work afteradding a column. Bug?
List 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

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

Attachment

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [BUGS] BUG #14813: pg_get_serial_sequence does not returnseqence name for IDENTITY columns
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14814: Documentation errors for OpenBSD