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 1h9YAr-0000Zq-KS for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Mar 2019 16:46:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9YAq-0002Rs-Bm for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Mar 2019 16:46:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9YAp-0002Qg-UW for pgsql-hackers@lists.postgresql.org; Thu, 28 Mar 2019 16:46:40 +0000 Received: from mail-qk1-x744.google.com ([2607:f8b0:4864:20::744]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9YAn-0005OG-Hz for pgsql-hackers@lists.postgresql.org; Thu, 28 Mar 2019 16:46:38 +0000 Received: by mail-qk1-x744.google.com with SMTP id c20so12557193qkc.10 for ; Thu, 28 Mar 2019 09:46:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=NZA2I9w9c2Mnz79UiNIvhKgQ8PUmDa7SCuNYOf26DgQ=; b=YnX5IZY1uLIAdFPIU+F4P9+0af6SGloHG++b+eKzZS/Fd8h6rbEuAoka3UG80msN7d Q187g1pdzE6gS5aqVMT0IhN40Xzo4jcg/Z3jgAMh4vY/xa89LxGYIcAnih6OPQ64Mkzi eTLtFUJvyEvRVa8d7e/8o1kLcYHiMROSDWJ44pPOS4U7WYqwBQ7qNko2hBUv+TnNkPtV r7dJk/aoL1VKTWPj4TPENqmGB2gfVoIQ5GkyGrOqbPP3uOxm2NJWbBXvsMV4G/HSOdyi 4UGZHgbBfQNZoLuBlJbhhB/P9enp6gbb0/2bsnDwvgs5DpEPDTG/PGynAH/gg/0Dxku/ CaBQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=NZA2I9w9c2Mnz79UiNIvhKgQ8PUmDa7SCuNYOf26DgQ=; b=surEQ4vS3r4CXStC+BWTv1db4DzoWIJnYpAMHSpK9H6+lYQ1Z1gxhgKOFIGbb6P/WQ 0Kp3ubtYkJPTiX8eUKWSJg7dsnYKw+I7DsufEQjSJ/pT1+KzSK6dt/j+kgJyUJiyB/T9 k89ZsSNL/bmflLd+IcE61fRnreiIVlTEQ+H0qgca3itQVU2ugaXJIV/8UEL6X145lqFx oHZXOSysCi/8gH+WGDX7YNHq2dZwRHi+ffjsrB5R67+coFJ6AGziti7SlnCgLwbfh8Tc Th5I6ybbl4+zGtAp9aiMxBLzN2Png0dmcjmSqbymsD//Pkfs95f4kfRnJXbE0FHg2MFl Emxg== X-Gm-Message-State: APjAAAX0Bl/LHWpdlBUtah3gtn1Ebchq4EcNoxA9hRvL5Dlb92BLL4le a0CdtTJ25ugfbIKr3ASeuhJEMg== X-Google-Smtp-Source: APXvYqxR663TsKMKChY0A3iKpE3/i1VO+Rx5NtiXgb82aeRk3Ek29e0tIDr5OxUDmMIwu4fA4rGEXA== X-Received: by 2002:a37:a34f:: with SMTP id m76mr36629225qke.245.1553791596689; Thu, 28 Mar 2019 09:46:36 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id x2sm13831239qkc.13.2019.03.28.09.46.35 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Thu, 28 Mar 2019 09:46:35 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 65CA4120C4B; Thu, 28 Mar 2019 13:46:33 -0300 (-03) Date: Thu, 28 Mar 2019 13:46:33 -0300 From: Alvaro Herrera To: Peter Eisentraut , Michael Paquier Cc: Robert Haas , Pg Hackers Subject: Re: propagating replica identity to partitions Message-ID: <20190328164633.GA22571@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20190323013354.GI20584@paquier.xyz> <806fd173-9084-5fb8-ed78-25398ab9e92f@2ndquadrant.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Thanks, Michael and Peter, for responding; however there is a second part to the question, which is "should I change the recursivity of REPLICA IDENTITY, while not simultaneously changing the recusivity of the TABLESPACE and OWNER TO forms of ALTER TABLE?" I think everyone agrees that REPLICA IDENTITY should be changed. The question is whether it's bad behavior from my part to change it separately from changing every other non-currently-recursive form. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services