Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1f1Mci-0006hL-IP
	for pgsql-docs@arkaria.postgresql.org; Thu, 29 Mar 2018 01:45:04 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1f1Mcg-0004IG-Vj
	for pgsql-docs@arkaria.postgresql.org; Thu, 29 Mar 2018 01:45:02 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <peter.eisentraut@2ndquadrant.com>)
	id 1f1Mcg-0004I4-Pp
	for pgsql-docs@lists.postgresql.org; Thu, 29 Mar 2018 01:45:02 +0000
Received: from out5-smtp.messagingengine.com ([66.111.4.29])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <peter.eisentraut@2ndquadrant.com>)
	id 1f1Mcc-0005lU-V7
	for pgsql-docs@postgresql.org; Thu, 29 Mar 2018 01:45:01 +0000
Received: from compute7.internal (compute7.nyi.internal [10.202.2.47])
	by mailout.nyi.internal (Postfix) with ESMTP id 0C0AA20E50;
	Wed, 28 Mar 2018 21:44:57 -0400 (EDT)
Received: from mailfrontend2 ([10.202.2.163])
  by compute7.internal (MEProxy); Wed, 28 Mar 2018 21:44:57 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=content-transfer-encoding:content-type
	:date:from:in-reply-to:message-id:mime-version:references
	:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=QO6RhQ
	MOEO82G2IMUTy6pzriPhydYq6C29peOgNvu7E=; b=eDUSSj4x/KBU8UJrps3nWN
	zRoNYEQYCnpSBYf5LAThVEtvXxSD2jGhHZ03wjf6PONJnOrAqKDQ5Cp/uqfYltNj
	OYaQnG6wLxzUIEw3gyRUQgz8EbDxy8BjwAp/bVzkRKQqxJ0i4p25P13kcYuLIcbe
	+bYxKR+hPvG5cQJmlPHeihZeY2aNTbnfQgwrheWefu10jGAJ0yBNmUX0J5CBtoiQ
	F4A/lUs4+HaRv1O+u4Noa/Tkl1zS5QnvKR1SaF5HdFzrDVZ7z9s0Yl4FBcbhyHik
	yBTN85kooJMGVhchLcbo4ua0D0N5AN3tQHdWtM30VsO6wv9UK2FmqIUbscBYhU3w
	==
X-ME-Sender: <xms:GUW8WvCm8hkI86VdMLCcAmvI0YLdfsl9Wsi3qyRz6ZfwhKEF0Q2UCw>
Received: from april.local (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39])
	by mail.messagingengine.com (Postfix) with ESMTPA id CB7C710252;
	Wed, 28 Mar 2018 21:44:56 -0400 (EDT)
Subject: Re: create publication descendant tables
To: Brian Faherty <anothergenericuser@gmail.com>, pgsql-docs@postgresql.org
References: 
 <CAMLsqiQ=vROQm=w141JOVDJ=KqDXQASoqjXnx1JmjZHzhfmmGQ@mail.gmail.com>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <c2beeddd-5680-7dd2-a9f9-370c30c9764b@2ndquadrant.com>
Date: Wed, 28 Mar 2018 21:44:56 -0400
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0)
 Gecko/20100101 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: 
 <CAMLsqiQ=vROQm=w141JOVDJ=KqDXQASoqjXnx1JmjZHzhfmmGQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Precedence: bulk

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