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 ) id 1f3oIx-0001eh-Gs for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Apr 2018 19:42:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f3oIw-0007eQ-DJ for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Apr 2018 19:42:46 +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 ) id 1f3oIw-0007eG-6D for pgsql-hackers@lists.postgresql.org; Wed, 04 Apr 2018 19:42:46 +0000 Received: from new1-smtp.messagingengine.com ([66.111.4.221]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f3oIq-0007gj-U5 for pgsql-hackers@postgresql.org; Wed, 04 Apr 2018 19:42:45 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailnew.nyi.internal (Postfix) with ESMTP id 1AECFC03; Wed, 4 Apr 2018 15:42:38 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 04 Apr 2018 15:42:38 -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:subject:to :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=Eg4vXDGfXfxHxfaKT OtZ2g8aRYFMyTWx2ctnES2KCNw=; b=Hhy9aHoU52z1pGx2eVcyJPJNdKkQjxyXR S4Z1XVVVNxBJbFV04bHG7RsgahzxqlvybdjxkK8Ku255UoinGNnFupTS5ztbHAr6 czkIvFsVo72LgsTM7UhLvYBWp4Vlcb5+sTk1bcbgoApOiSO79sDunwUELLSD46F5 Uma+OM2tsfaR5W3+QDb4fAxdMU3l6dz4oFutZf6ZZX39v54RfjoQw8FHHmf10aBu XJ2WzWrKauuYZV9S+bvwbS3L3bo7xBwkRNAy46yGiKozBrIUqYNAH+VBB8mGhdr4 leZmeka/KrEzUh2R8P0K4D97WXCqcom21HtVn5/widcTAwbOnFUzg== X-ME-Sender: Received: from alvin.alvh.no-ip.org (unknown [179.56.29.253]) by mail.messagingengine.com (Postfix) with ESMTPA id 484F210253; Wed, 4 Apr 2018 15:42:37 -0400 (EDT) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 2FF1F5A7; Wed, 4 Apr 2018 16:42:35 -0300 (-03) Date: Wed, 4 Apr 2018 16:42:35 -0300 From: Alvaro Herrera To: Tom Lane Cc: Peter Eisentraut , Pg Hackers Subject: Re: Foreign keys and partitioned tables Message-ID: <20180404194235.bdqsv3oj5cgzuwp6@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <32347.1522865050@sss.pgh.pa.us> User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Tom Lane wrote: > Alvaro Herrera writes: > > Thanks, pushed. > > This has broken the selinux regression tests, evidently because it > removed ONLY from the emitted FK test queries. While we could change > the expected results, I would first like to hear a defense of why that > change is a good idea. It seems highly likely to be the wrong thing > for non-partitioned cases. Yeah, there ain't one, because this was a reversal mistake. I restored that ONLY. (There were two ONLYs in the original query; I initially removed both, and then went over the file and included them conditionally on the table not being a partitioned one, based on review comments. In this line I restored one conditionally but failed to realize I should have been restoring the other unconditionally.) Pushed a fix blind. Let's see if it appeases rhinoceros. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services