Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jM6yx-0005Zr-HI for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2020 09:26:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jM6yw-0007RS-Ee for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2020 09:26:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jM6yv-0007RL-Fg for pgsql-hackers@lists.postgresql.org; Wed, 08 Apr 2020 09:26:50 +0000 Received: from [64.147.123.25] (helo=wout2-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jM6ys-00063B-3j for pgsql-hackers@postgresql.org; Wed, 08 Apr 2020 09:26:48 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 7F71B7F2; Wed, 8 Apr 2020 05:26:34 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 08 Apr 2020 05:26:34 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; bh=wdSNdZpMBoMcYphScIhxa4b/t0sqz4Oz01yMo/r+2 2U=; b=SHvoMmxrNi7FXiOASgBYi3JoYJFDtWv7qf4zG7rxFhCFOHv83fKM/Iz7I xK2/daUYzf3ey4sLo88dw4I4iea3BOjY+IVY7j05ZGYOn9uBDO+L0+/Axy72381i 87R25bUHDo6y6m/nl05EnbOi1lmTBC5zBWYUFhnvB0/DE+y9DbAcLrTg8MQ9jwJd 0icnW/wq18gl/dTb0LbcXaDEjEw3/Bw/eJgyUC+hYvW8zg3RnvqggAeOCgwr8SrP B5PbBHnk+6Jd7jdODJNySc0+FN+tFrMARrZizoQ+70LMjJ1uvW2Cd3d7CSeE/Vnl FBy46+hpSkmaxbS7wEyT1wfTTUCTw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedrudejgdduhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefuvfhfhfhokffffgggjggtgfesthejredttdefjeenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsedvnhguqh hurggurhgrnhhtrdgtohhmqeenucffohhmrghinhepvdhnughquhgrughrrghnthdrtgho mhenucfkphepleefrddvgedvrddvudefrddvgedunecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghishgvnhhtrhgruhhtsedv nhguqhhurggurhgrnhhtrdgtohhm X-ME-Proxy: Received: from april.pezone.net (p5df2d5f1.dip0.t-ipconnect.de [93.242.213.241]) by mail.messagingengine.com (Postfix) with ESMTPA id E57F8306005E; Wed, 8 Apr 2020 05:26:32 -0400 (EDT) Subject: Re: adding partitioned tables to publications To: Amit Langote References: <4f999141-97c8-c968-a726-0a1ec3e36e47@2ndquadrant.com> <64a2c1c7-3887-787b-e43b-ac15112bda82@2ndquadrant.com> Cc: Petr Jelinek , Rafia Sabih , PostgreSQL-development From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: Date: Wed, 8 Apr 2020 11:26:30 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.147.123.25 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-04-08 07:45, Amit Langote wrote: > On Wed, Apr 8, 2020 at 1:22 AM Amit Langote wrote: >> On Tue, Apr 7, 2020 at 6:01 PM Peter Eisentraut >> wrote: >>> The descriptions of the new fields in RelationSyncEntry don't seem to >>> match the code accurately, or at least it's confusing. >>> replicate_as_relid is always filled in with an ancestor, even if >>> pubviaroot is not set. >> >> Given this confusion, I have changed how replicate_as_relid works so >> that it's now always set -- if different from the relation's own OID, >> the code for "publishing via root" kicks in in various places. >> >>> I think the pubviaroot field is actually not necessary. We only need >>> replicate_as_relid. >> >> Looking through the code, I agree. I guess I only kept it around to >> go with pubupdate, etc. > > Think I broke truncate replication with this. Fixed in the attached > updated patch. All committed. Thank you and everyone very much for working on this. I'm very happy that these two features from PG10 have finally met. :) -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services