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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1iSlbK-0000Va-UG
	for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Nov 2019 17:29:43 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1iSlbJ-00018d-Og
	for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Nov 2019 17:29:41 +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 <alvherre@2ndquadrant.com>)
	id 1iSlbJ-00018W-CN
	for pgsql-hackers@lists.postgresql.org; Thu, 07 Nov 2019 17:29:41 +0000
Received: from mail-qk1-x744.google.com ([2607:f8b0:4864:20::744])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1iSlbC-0002N5-6t
	for pgsql-hackers@lists.postgresql.org; Thu, 07 Nov 2019 17:29:41 +0000
Received: by mail-qk1-x744.google.com with SMTP id q70so2668504qke.12
        for <pgsql-hackers@lists.postgresql.org>;
 Thu, 07 Nov 2019 09:29:33 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:subject:message-id:mime-version:content-disposition
         :content-transfer-encoding:in-reply-to:user-agent;
        bh=/VgxpltDM1D5YEVhD/3MsBR1ozmPAwosNwtl2pGQEKE=;
        b=YymexvN3ISvNV/R7CywH5fezLBOq2tbVkX76DNq818/vbnI+AbvpegwBuFxan51eYg
         gKyDy75ha9NI8lOppFA4jcXUFxSYKEWVX9eduBfasN6cBsHleWxkn7BgkZcHtWYNBNKk
         VxHdZwVmv9vFs6gEyCw2dUPJxCS+Vdvz/xRMIZaieSS1bLIBlcbYNOeLcucNF81ins3o
         s4YJHKTN9MypdDK+pkI0yG2kYnD7ktArYK9c1FcFfq2H1xMIlQOkCz2zrgDltYWIhvlC
         UwoSY59vFWtdPr3U3DUPjcY0MC3NTnCEOimaSfueUWnm/1fZFq9DngCoORcyZO0kE6T8
         uq8Q==
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:subject:message-id:mime-version
         :content-disposition:content-transfer-encoding:in-reply-to
         :user-agent;
        bh=/VgxpltDM1D5YEVhD/3MsBR1ozmPAwosNwtl2pGQEKE=;
        b=mb5vO/VPNFQShSjtgbSMyrqG7SR2I1QyWiN0TxsO4HUEmrkaR76QnjFX0yFF1xPmiR
         n0DrAHP5muDfqH50kYQzNxo56SI0h9PeMdoOTOb1rfqRp3ImPfH5LwezWPVSadOrMWz0
         QnAmrFyH4AvkQ7CJOdnxiCBdCka+gEW1HzyxdUtBl2N0GmrDAMUPH4uIQ83OAJ/40U0e
         pSP3DROSUCxWtLQqhkWPyc0Bha8AcHNvoiNFtJ/FcrG7G44ZTyIyN+eLq5hyiMTzVOVy
         ilL6HSrlP9EvEMQg/7OnT5Z9WdCjyYnPUja8U0AA6qbonq03f1V64XETzVhEdhphg/Sa
         q7Sw==
X-Gm-Message-State: APjAAAVT/giWnlKTZg/p+XjVR2G/LlIUSvMERcUgu6qefagkRy+huD7y
	UQZRVG44Zqwn7E4aiHtxyYIYX4uhBJ24bbHxO52zDY2VJeBzDNb/kJ+NCkOQjhxpnynEhWSJYEK
	VyCxUNPSIG8uPCJ++tdexTJwSQnMCBW0qWIqaewq4kDPv8iJNXNLpYqxbAvVWsft1iz8DHY78VI
	h3lPJ/1fT+HJZf8Q==
X-Google-Smtp-Source: 
 APXvYqxDDfnjXBmO/WTI+x86tfgoC2noZa55EvtvC1QNFe/Talv6WOe3FK91PxCiUXsRAtRrpnvePg==
X-Received: by 2002:a37:a741:: with SMTP id q62mr4103280qke.435.1573147772038;
        Thu, 07 Nov 2019 09:29:32 -0800 (PST)
Received: from nimloth.alvh.no-ip.org
 (ip-104-2-52-196.nyc.us.northamericancoax.com. [196.52.2.104])
        by smtp.gmail.com with ESMTPSA id
 o3sm2709553qtf.84.2019.11.07.09.29.31
        for <pgsql-hackers@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Thu, 07 Nov 2019 09:29:31 -0800 (PST)
Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000)
	id ABAE5302246; Thu,  7 Nov 2019 14:29:27 -0300 (-03)
Date: Thu, 7 Nov 2019 14:29:27 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: deferrable FK constraints on partitioned rels
Message-ID: <20191107172927.GA18722@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20191105212915.GA11324@alvherre.pgsql>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

On 2019-Nov-05, Alvaro Herrera wrote:

> Uh, somehow I posted a previous version of the patch that implements my
> rejected approach, instead of the final version I described.  Here's the
> real patch (which also includes tests).

This was broken in pg11 also.  Pushed to all branches.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services