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 1h74ob-0005gY-TD for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Mar 2019 21:01:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h74oZ-0004zG-I1 for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Mar 2019 21:01:27 +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 1h74oZ-0004sC-4w for pgsql-hackers@lists.postgresql.org; Thu, 21 Mar 2019 21:01:27 +0000 Received: from mail-qk1-x742.google.com ([2607:f8b0:4864:20::742]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h74oR-00019J-1t for pgsql-hackers@lists.postgresql.org; Thu, 21 Mar 2019 21:01:25 +0000 Received: by mail-qk1-x742.google.com with SMTP id k130so17240862qke.3 for ; Thu, 21 Mar 2019 14:01:18 -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=jM3TLCVXT+XPx9z+paEO8dqvNFj/bgMy9KbKAltWGio=; b=OD82gvmdJmYq5H0PQUz8aFunbzHewJwN2wu/4/aHaro+iGTm+Id6HTMYIwgdKQDx7D MwzlzB79IE2W205PKLtG81/VcQ3hZJeXnQGhZZnUAKjhIW+o5GCuTTJjbNcAOFPxf6u1 35BmdEknOhiDF09V8+bnk2VIUsDi/weS1RZYdhWw5JdJlLcMTFgKJgBRj6Sv/1n/dbHB mtK4hVoMQLrrkkvC6GTNsAdytc/HmYZ0Wor7FMh4KjaBHRM86ifoQ+fM/XpYGWM1X+kZ TZmEbSw4HBBgWO8Ma4Qy40tZgsH58yZ08VWNaTQoAJi6ZDq9WZjv2zYXcmRHNgDiJQJ0 Op4w== 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=jM3TLCVXT+XPx9z+paEO8dqvNFj/bgMy9KbKAltWGio=; b=he/CBb3w0hbPFPWp2FNoRZHI32jYuLGN8nJnGFYFZKir9QwHE+stz/5ndvq8ooKEFV jpvMw1jHd+kgDctXzYrSCxFawM99yQVc+Z/EvuihbZF5vkRtCmVwjlehzQPn6JZxwcz7 4MIEY6Gu6gVDMuylw9lhzOa3X7eOFHeCP7Ysy3ZMneBRFzCD1zqHCyu3YjeyfR1XaGq0 Be6P3imaE3s9c93GFZu8DA2LXolCrxk1wirfnYjtiW32xTaqOAG6GWI/0NgWToVctoyb CL1NJPuV4BbwSFXN4fjC+UbMxO6Rcjh3PFFVLpl94ew3htsrw3/kN7k64m1JJyRFsX70 ncDA== X-Gm-Message-State: APjAAAXHZQ14hAjLqfEpz8F4Y1L3Ic33AiM13qhVL+ZZlwl9DU0LlWmf 2OQn1BQGmlH5ps/ah9toO52s3Q== X-Google-Smtp-Source: APXvYqytTkaMQyHDidrcuAWDLN9dbCCznzb9pgj2dQ4OH4AG+ouAFTsyQRns/HsTIuYuTQfou9IItg== X-Received: by 2002:a37:e503:: with SMTP id e3mr4445591qkg.316.1553202076895; Thu, 21 Mar 2019 14:01:16 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id w127sm3626865qka.46.2019.03.21.14.01.16 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Thu, 21 Mar 2019 14:01:16 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 4923B120694; Thu, 21 Mar 2019 18:01:14 -0300 (-03) Date: Thu, 21 Mar 2019 18:01:14 -0300 From: Alvaro Herrera To: Robert Haas Cc: Peter Eisentraut , Pg Hackers Subject: Re: propagating replica identity to partitions Message-ID: <20190321210114.GA18387@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-Mar-21, Robert Haas wrote: > On Wed, Mar 20, 2019 at 4:42 PM Alvaro Herrera wrote: > > Unless there are any objections to fixing the REPLICA IDENTITY bug, I > > intend to push that tomorrow. > > I still think that this is an ill-considered, piecemeal approach to a > problem that deserves a better solution. I already argued that TABLESPACE and OWNER TO are documented to work that way, and have been for a long time, whereas REPLICA IDENTITY has never been. If you want to change long-standing behavior, be my guest, but that's not my patch. On the other hand, there's no consensus that those should be changed, whereas there no opposition specifically against changing this one, and in fact it was reported as a bug to me by actual users. FWIW I refrained from pushing today because after posting I realized that I've failed to investigate Dolgov's reported problem. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services