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 1f3Sq6-0008Ht-P0 for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Apr 2018 20:47:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f3Sq3-0006Z4-HQ for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Apr 2018 20:47:31 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f3Sq2-0006Yo-Fp for pgsql-hackers@lists.postgresql.org; Tue, 03 Apr 2018 20:47:31 +0000 Received: from new1-smtp.messagingengine.com ([66.111.4.221]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f3Spy-0001FB-Rk for pgsql-hackers@postgresql.org; Tue, 03 Apr 2018 20:47:28 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailnew.nyi.internal (Postfix) with ESMTP id D6383137C; Tue, 3 Apr 2018 16:47:25 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Tue, 03 Apr 2018 16:47:25 -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=zkOsJ3fiz28TJ0086 SfZOa6r9fxOOgCFWiXqpaHfP7Q=; b=dKg6PhnR3A2DJpD67utpSCYTNcXKK19Sy 3tmnkhqoXCYTFL1hvbK2NQ6lpc9vGeJMOKuupXXUElgH4sm8FpO7V7Kti6uRm25c F6CQeZw3Pf34536iidDUmTjQGPAUG/cv2qK9uFlz7HKyuFcmtp+MVFk3BE4VyU2M xOccePY7/dkHmkbweOZIJUs4s7nUE9jwi+Y0XM4kT8E94P6XfePZY2w06NWLTg86 gdXqom7doxTdemm3w+tLsfue7+IwR+B+b52LWHHviJNteDpGjv0rhm52ZQPFQ4Dv JJYI2kRiJSpeJpsnIb/+Dudo+Zp7k4LGPCC+Ksp9eYlph1pneM/6g== X-ME-Sender: Received: from alvin.alvh.no-ip.org (unknown [179.56.29.253]) by mail.messagingengine.com (Postfix) with ESMTPA id 3D8391025A; Tue, 3 Apr 2018 16:47:25 -0400 (EDT) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 72F822AB; Tue, 3 Apr 2018 17:47:23 -0300 (-03) Date: Tue, 3 Apr 2018 17:47:23 -0300 From: Alvaro Herrera To: Peter Eisentraut Cc: Pg Hackers Subject: Re: Foreign keys and partitioned tables Message-ID: <20180403204723.fqte755nukgm42uf@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20180403191135.veeeihh53po7dx5k@alvherre.pgsql> User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Alvaro Herrera wrote: > While adding some more tests for the "action" part (i.e. updates and > deletes on the referenced table) I came across a bug that was causing > the server to crash ... but it's actually a preexisting bug in an > assert. The fix is in 0001. Yeah, it's a live bug that only manifests on Assert-enabled builds. Here's an example: create table pk (a int, b int, c int, d int primary key); create table fk (d int references pk); insert into pk values (1, 2, 3, 4); insert into fk values (4); delete from pk; Will fix -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services