On 4/13/17 06:48, Amit Langote wrote:
> That is an important consideration because of pg_dump. See below:
>
> create table foo (a int);
> create table bar () inherits (foo);
> create publication mypub for table foo; -- bar is added too.
>
> $ pg_dump -s | psql -e test
> <snip>
> ALTER PUBLICATION mypub ADD TABLE foo;
> ERROR: relation "bar" is already member of publication "mypub"
To fix this, pg_dump should emit ADD TABLE ONLY foo.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services