create publication descendant tables
I was looking at the `CREATE PUBLICATION FOR TABLE table *;` and I ended up
with a few questions.
1.) Can '*' ever be used since it includes the parent table along with the
child which then results in a error being thrown about parent tables not
being able to be replicated?
2.) Will it only work on current descendants or will it also work on future
descendants?
For quick reference:
https://www.postgresql.org/docs/10/static/sql-createpublication.html
--
Brian Faherty
On 3/19/18 09:23, Brian Faherty wrote:
1.) Can '*' ever be used since it includes the parent table along with
the child which then results in a error being thrown about parent tables
not being able to be replicated?
There is a difference between partition roots (which can't be added) and
inheritance roots (which can).
2.) Will it only work on current descendants or will it also work on
future descendants?
only current
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services