Re: [BUGS] BUG #14719: Logical replication unexpected behaviour whentarget table has missing columns

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [BUGS] BUG #14719: Logical replication unexpected behaviour whentarget table has missing columns
Дата
Msg-id CAKFQuwY4zqTR2ABCLGg8V6fDDonDQE0cEbitjPqLi4=chf-gvA@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14719: Logical replication unexpected behaviour when targettable has missing columns  (garton@gmail.com)
Список pgsql-bugs
Дерево обсуждения
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 по дате отправления: