Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.
Дата
Msg-id CAHE3wggJkMEOUQ-=qGM0xaCTTqLd-mP7AuAUS0hLz5bHUfNn2Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы [HACKERS] Re: pg_dump ignoring information_schema tables which used in CreatePublication.
Список pgsql-hackers
Дерево обсуждения
2017-05-26 17:52 GMT-03:00 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>:

You cannot publish a system catalog.  But a user-created table in
information_schema is not a system catalog.

Replication of information_schema tables works. However, pg_dump doesn't include information_schema tables into CREATE PUBLICATION command (user-defined information_schema tables aren't included in pg_dump even *before* logical replication). IMO allow publish/subscribe of tables into information_schema is harmless (they aren't special tables like catalogs). Also, how many people would create real tables into information_schema? Almost zero. Let's leave it alone. Since pg_dump doesn't document that information_schema isn't dumped, I think we shouldn't document this for logical replication.


--
   Euler Taveira                                   Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Extra Vietnamese unaccent rules
Следующее
От: Euler Taveira
Дата:
Сообщение: Re: [HACKERS] ALTER SUBSCRIPTION ..SET PUBLICATION refreshis not throwing error.