Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gzYLP-0002fZ-9C for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Mar 2019 02:56:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gzYLM-0005wy-6J for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Mar 2019 02:56:12 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gzYLL-0005wm-Uu for pgsql-hackers@lists.postgresql.org; Fri, 01 Mar 2019 02:56:11 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gzYL6-0006fM-4q for pgsql-hackers@lists.postgresql.org; Fri, 01 Mar 2019 02:56:11 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id CD446351F; Thu, 28 Feb 2019 21:55:53 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 28 Feb 2019 21:55:54 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=SWw7r2TB2Q95l4Q3L0j+upgKo0g jPZYScA7ifuG6uW4=; b=etWgJPLRnElmM1Yl4HdEZqf3NXfMsCojH27WfMj5sT4 ebwdiVedAejfhV5oxJCtZTjw5DMb1WkEyYESUXOoJigd08+6DKuud7otJFV1cpQ3 iA8ww8bo9lgfYB31Wb4/ey6wnSGcHt6g8SEQvEhtU3g44nDtttxVVyb/KB2CDGqF IDThTasp8SuSuYcWhThtAoRTHxUWt5Ewq9r+yqSCBhnnMUnrKzkT+p8AUxYAtUL3 hMEZShmEm4XbToXrpIGCiNYl1IxKfgJYr8DHuxO5td2abx1hA3+M0ESj3OjQKeMH 8a5h+aqMWF2ff3brhOGP7+3E0JwnutK29xV6rnnXSvA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc: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=SWw7r2 TB2Q95l4Q3L0j+upgKo0gjPZYScA7ifuG6uW4=; b=uE1Fz7iX1yAEza4TfI1Yrn z5sGpcSsq2wZRpKPDg1F3OIKuSSeCaZAAuQ1hML3jHNTLWYE6u0wNkiMGmZNe/3J DjSXh04azx12e5HhNI2hG6HHUzLMWc0fLvGIeTApZHA/OeezvhVdGD7xL6c99pIK X3p1bdth3KLK2p90/3z5vWvr/lgCikBv2ab0ZAcHQn2Kf/OhNc9SH+k4uFWCZ3E7 38V50tZ49ioLh08nhxOu4BbWoK2cU0hK0HMD8bJiEmOEGMIk6nr0V1PfVxglAtBA QGt2n4WIOGHH6XFoGfnvMK/XwQeeF8YfmhMyZPGJ9lLjRZK8Pyw+25jTAjYYFAXg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedutddrvdeggdehhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeeiuddrvdduhedrudefjedrudeivdenucfrrghrrghm pehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlhhush htvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 0A88C1030F; Thu, 28 Feb 2019 21:55:50 -0500 (EST) Date: Fri, 1 Mar 2019 11:55:47 +0900 From: Michael Paquier To: Alvaro Herrera Cc: Robert Haas , Pg Hackers , Peter Eisentraut Subject: Re: propagating replica identity to partitions Message-ID: <20190301025547.GI1348@paquier.xyz> References: <20190228224111.GA24086@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="W13SgbpmD6bhZUTM" Content-Disposition: inline In-Reply-To: <20190228224111.GA24086@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --W13SgbpmD6bhZUTM Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Feb 28, 2019 at 07:41:11PM -0300, Alvaro Herrera wrote: > We all seem to agree that REPLICA IDENTITY should recurse. (entering the ring) FWIW, I agree that having REPLICA IDENTITY recurse on partitions feels more natural, as much as being able to use ALTER TABLE ONLY to only update the definition on a given partition member. -- Michael --W13SgbpmD6bhZUTM Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlx4nzMACgkQnvQgOdby QH2nVQ/9FJwgr5RzW1TVn/rS34glKKWxJHu12beUA7LxQgsrQH7Q+LdPFnbVOeB2 zLcMtC+UIyUu2N39dM+2lN/UrJeylmH2Yr3Y/n/zEouJmoD35PNFguWf4qFb9vRU nKvwI/CcWqn2Sn72AHt+mc2wTuaY1W/qUI6ptS0yhq8cUl5Jlv9IMIfo+bg1Riau 2Onv7QGfT1V7Yhxsi7wytyxzCZ3B/8z+s4hXAGNGw+hP35BVRkBOZHLkGJuxpZT1 XvkzMEMRRQKr/9xg94efZgM474t4fGa6laddljXud4tKLnL85ZQM7SDmdYRXQFZA XEz5DiwK8JyCKXdogO+arHurE3J3aG7g6Yl9IJMTOj8rBP7lCi3hbbivG0Z6kH7u 9Doy5k9gR6c5Lf1ZlKlwxPX2PdegUciLwuYhM+XTLL/crHVVOvvWMAy5V6nSuWjL TiOYL1i6dngtCzknivW1rPKb0ms5UzS3KfeZiUq+qD9J7xTKcVUjIWlISN6bbPeP La0WzLeGYyBXKu6g3SEona7idpfKwwqt+gErtQ8ee2EeoN9OdFN8g3S5dymOl3Kr 2lqCZS9mi77kX3cFIjbsOQpsrGsv2zuUWHqJ8Ybr1bkCb1Cji2zc0COAmUJ0Q4t4 CdoXYFSUhfahbZIyhv8WjdlWCys9d5ZbDsKYBI/aUGO2Zv/Vzb8= =B/8+ -----END PGP SIGNATURE----- --W13SgbpmD6bhZUTM--