create publication descendant tables
create publication descendant tables
От:
Brian Faherty <anothergenericuser@gmail.com>
Дата:
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
Re: create publication descendant tables
От:
Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Дата:
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