Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1leKKI-0001LO-Ke
	for pgsql-bugs@arkaria.postgresql.org; Wed, 05 May 2021 16:24:42 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1leKKH-0001XN-Eg
	for pgsql-bugs@arkaria.postgresql.org; Wed, 05 May 2021 16:24:41 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <alvherre@alvh.no-ip.org>)
	id 1leKKH-0001XD-7Q
	for pgsql-bugs@lists.postgresql.org; Wed, 05 May 2021 16:24:41 +0000
Received: from wout1-smtp.messagingengine.com ([64.147.123.24])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <alvherre@alvh.no-ip.org>)
	id 1leKKF-0007td-B9
	for pgsql-bugs@lists.postgresql.org; Wed, 05 May 2021 16:24:40 +0000
Received: from compute2.internal (compute2.nyi.internal [10.202.2.42])
	by mailout.west.internal (Postfix) with ESMTP id 9DC3F15A3;
	Wed,  5 May 2021 12:24:36 -0400 (EDT)
Received: from mailfrontend1 ([10.202.2.162])
  by compute2.internal (MEProxy); Wed, 05 May 2021 12:24:36 -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-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=
	fm2; bh=RzcvFvS4iZBldpFedC6A6uv3Vs9jd+9zWbQFIhah7eE=; b=S7qjGnkt
	hEcWwkqc/Vdlo3JvFCzw5Jx5sKr5QuMg+9UCQQpVlXMWMsKl3E313dcUAo2nY7Qv
	klJYR613fWGrtvK/QpxY83VofREn7NFrr4TjodBl2qz8nWBbZP/eDONJ5NRttAgk
	UQMrfmDOhoyMjft9tnGfHoISRqBMh2yd7Sjkk9Dft5401+5m9XUIAUi6a+JKa3ER
	F50ml/XHE3X5tRIIo4ZdqYeBhm9vcz8cBmM24bZeIpL6ihdQYMOrquC8nkMxKdUp
	VPTaRtvn7hTezV4kweUDeGiIeNCaOPJWx2IUnXGiAMMLxVzfvYA8FmWZF6tsR3Hu
	mSGnWb4WwfUHkA==
X-ME-Sender: <xms:tMaSYBnmNlh0tQuI8coHclUTypmnDUlIohmHQjsEfLSBzerznTPZLw>
    <xme:tMaSYM2KHPc2QKMWyiQS6bN-gtRu-CoOH-ZbH6yX2XKJZz7QdknH0SKjoaoORvgqM
    uHdcad-xtedI1VidQ>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeduledrvdefkedgleeiucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucenucfjughrpeffhffvuffkgggtugfgjggfsehtke
    ertddtredunecuhfhrohhmpeetlhhvrghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhr
    vgesrghlvhhhrdhnohdqihhprdhorhhgqeenucggtffrrghtthgvrhhnpeeufffhjeeiue
    euffegvddukeegledtveeivdeiueefieeivefgteehueefteehvdenucfkphepudeltddr
    leehrdduledrleehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilh
    hfrhhomheprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh
X-ME-Proxy: <xmx:tMaSYHqfN469PlepeJEQg5hZtFg7lcAgbJGrmnT0gGrfiqeIIMCmlw>
    <xmx:tMaSYBnvUZx5IW-EwWXY2WzVjCbsPPWyLObeoEjENey4cYN1wPPfuQ>
    <xmx:tMaSYP0HA4ETgHJ8bwIBWKcf1JKHI8S8O62yxacFVRakDCrf_FZbAw>
    <xmx:xMaSYEhqSGebxSkLQREPASl-gPO78wVQddnF1ZVlZLtdJC9fMqzQoA>
Received: from perhan.alvh.no-ip.org (unknown [190.95.19.95])
	by mail.messagingengine.com (Postfix) with ESMTPA;
	Wed,  5 May 2021 12:24:20 -0400 (EDT)
Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000)
	id 657A82A0BB4; Wed,  5 May 2021 12:24:17 -0400 (-04)
Date: Wed, 5 May 2021 12:24:17 -0400
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org, Ron <ronljohnsonjr@gmail.com>
Subject: Re: ALTER CONSTRAINT on a partitioned FK isn't working
Message-ID: <20210505162417.GA10762@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20210504162653.GA27100@alvherre.pgsql>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/20210505162417.GA10762%40alvherre.pgsql>
Precedence: bulk

On 2021-May-04, Alvaro Herrera wrote:

> So the attached version does that and I intend to get it pushed to all
> branches (since 11) this afternoon unless I get any objections.

Pushed it now, with some further adjustments.

-- 
Álvaro Herrera                            39°49'30"S 73°17'W