Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication. - Mailing list pgsql-hackers

From Euler Taveira
Subject Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.
Date
Msg-id CAHE3wggJkMEOUQ-=qGM0xaCTTqLd-mP7AuAUS0hLz5bHUfNn2Q@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses [HACKERS] Re: pg_dump ignoring information_schema tables which used in CreatePublication.
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Extra Vietnamese unaccent rules
Next
From: Euler Taveira
Date:
Subject: Re: [HACKERS] ALTER SUBSCRIPTION ..SET PUBLICATION refreshis not throwing error.