Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14719: Logical replication unexpected behaviour whentarget table has missing columns - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: [BUGS] BUG #14719: Logical replication unexpected behaviour whentarget table has missing columns
Date
Msg-id CAKFQuwY4zqTR2ABCLGg8V6fDDonDQE0cEbitjPqLi4=chf-gvA@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14719: Logical replication unexpected behaviour when targettable has missing columns  (garton@gmail.com)
List pgsql-bugs
Tree view
On Tue, Jun 27, 2017 at 1:28 AM, <garton@gmail.com> wrote:
The following bug has been logged on the website:

Bug reference:      14719
Logged by:          Martin Garton
Email address:      garton@gmail.com
PostgreSQL version: 10beta1
Operating system:   Linux xxxxxx 4.9.0-3-amd64 #1 SMP Debian 4.9.30-
Description:

The documentation states:

"The target table can have additional columns not provided by the published
table. Those will be filled with their default values."

However, when I added a column on the source database, the target began to
error:

ERROR:  logical replication target relation "public.foo" is missing some
replicated columns

This seems to contradict the documentation.

​The target table can have extra columns - what you describe is a scenario where it has fewer (i.e., you added a column to the source table).

David J.​

pgsql-bugs by date:

Previous
From: "Tom Turelinckx"
Date:
Subject: Re: [BUGS] Bus error in formatting.c NUM_numpart_to_char (9.4.12, 9.6.3, sparc)
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14719: Logical replication unexpected behaviour when target table has missing columns