Postgres Pro
Downloads
Home   >   mailing lists

Re: create publication descendant tables - Mailing list pgsql-docs

From Peter Eisentraut
Subject Re: create publication descendant tables
Date
Msg-id c2beeddd-5680-7dd2-a9f9-370c30c9764b@2ndquadrant.com
Whole thread Raw
In response to create publication descendant tables  (Brian Faherty <anothergenericuser@gmail.com>)
List pgsql-docs
Tree view 
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

pgsql-docs by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: Blanks in the first line before the first word in the code boxes
Next
From: Peter Eisentraut
Date:
Subject: Re: Blanks in the first line before the first word in the code boxes