public inbox for [email protected]
help / color / mirror / Atom feedcreate publication descendant tables
2+ messages / 2 participants
[nested] [flat]
* create publication descendant tables
@ 2018-03-19 13:23 Brian Faherty <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Brian Faherty @ 2018-03-19 13:23 UTC (permalink / raw)
To: pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: create publication descendant tables
@ 2018-03-29 01:44 Peter Eisentraut <[email protected]>
parent: Brian Faherty <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2018-03-29 01:44 UTC (permalink / raw)
To: Brian Faherty <[email protected]>; pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-03-29 01:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-03-19 13:23 create publication descendant tables Brian Faherty <[email protected]>
2018-03-29 01:44 ` Peter Eisentraut <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox