Re: BUG #15044: materialized views incompatibility with logical replication in postgres 10

Поиск
Список
Период
Сортировка
От Chad Trabant
Тема Re: BUG #15044: materialized views incompatibility with logical replication in postgres 10
Дата
Msg-id 161542b1c98.27af.478e5036e088b5aaf247fa13bcb9f071@iris.washington.edu
обсуждение исходный текст
Ответ на BUG #15044: materialized views incompatibility with logicalreplication in postgres 10  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: BUG #15044: materialized views incompatibility with logicalreplication in postgres 10
Список pgsql-bugs
Дерево обсуждения

On February 1, 2018 17:16:08 "David G. Johnston" <david.g.johnston@gmail.com> wrote:
>> Bug reference:      15044
>
> It seems the work-around is to not use "for all tables" in your publication
> definition.


Indeed.  My real world case 700+ tables with semi regular additions and two materialized views so ALL TABLES was the right fit.


> As described it does seem bugged.  The table matview itself is not being
> published, as documented, but knowledge of its existence as part of the
> publication is...


Exactly.  The matview does not show up in pg_publication_tables but it's registered at some level.


В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: BUG #15044: materialized views incompatibility with logicalreplication in postgres 10
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #14952: COPY fails to fill in IDENTITY column default value