| 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: | Whole Thread | Raw Message | 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 |
| 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 |