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 ) id 1k9IXJ-0001DZ-M9 for pgsql-bugs@arkaria.postgresql.org; Sat, 22 Aug 2020 01:41:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k9IXI-0002UY-8d for pgsql-bugs@arkaria.postgresql.org; Sat, 22 Aug 2020 01:41:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k9IXI-0002UR-2R for pgsql-bugs@lists.postgresql.org; Sat, 22 Aug 2020 01:41:36 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k9IXB-0003PW-Rw for pgsql-bugs@lists.postgresql.org; Sat, 22 Aug 2020 01:41:35 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 7D92BAF7; Fri, 21 Aug 2020 21:41:28 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Fri, 21 Aug 2020 21:41:28 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=0PV8AgO2s7Bkyabe9ZA9uwYtnKZ Ga9SVnBVKw5zaZzo=; b=l7YRpl5/sJNCZvCHq/8noEzD4R4KroBTdKQ+Y9tTIVJ clcLWAiRN8r5ORCOPEe2UJrZuTcpOPb0cZa7WJ3WF9BZbqpdGXkRAJ/MqZiLN9ns p0oJ7yhNFdjEP6rf19TUHQMzohXRsUuqaCVp8kV/8kLXLW/DfibU8VgRldmL8glU iyFIpwnQHEVicl0eYzP5zhAqmou8BUh7sSxchYy1vT90PA2caRYpVYCo/AmBI7ST aplPZfm8pkN9XTI73HzAK5W/O45Y/lXmLtBsMuVjwNHbBCxv6ksq05UYsM0zpIVN 3Z/eeWOOZb1m3c/zXLSmq3n+uGtXPeeMwAwTuSqGVng== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=0PV8Ag O2s7Bkyabe9ZA9uwYtnKZGa9SVnBVKw5zaZzo=; b=I8sw7B/qSSUFAvOK/7cFZQ +vkhHL6ab+Fn3JU2+ceYQBFJSoTYXduZ3zMeL2oTgy4IjrsXvdx8OUVzvh9bjkk0 LwRsi5S/BPmwMKoQTGcsy5BHlV92JpMGTFO+1Zk669OODDFh9w3XNxmuX/1eouzC 2UNthrNPX+XhnvC4XMR8XSLYunkB+rihnSMd0mvwwogkKheiFHRiiyFsT40P/ENl 8B356ak8mt24RNYXoYKSsIMVYegsHIQZj4Zy33UQyrBdV7GJXGEPisB4s1AXwB3u oWpMGHunbVW7oF2Q3BgdDcB4XF8Wx14EphCzUKDgZP8qUK+E69KKmQY+5jumWcRw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduiedruddufedggeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucfkphepuddukedrvdeguddrvdehtd drudefudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (mp76f1fa83.ap.nuro.jp [118.241.250.131]) by mail.messagingengine.com (Postfix) with ESMTPA id ECD47328005E; Fri, 21 Aug 2020 21:41:25 -0400 (EDT) Date: Sat, 22 Aug 2020 10:41:21 +0900 From: Michael Paquier To: Tom Lane Cc: pgsql-bugs@lists.postgresql.org, tom@intevation.de, Peter Eisentraut Subject: Re: BUG #16272: Index expression can refer to wrong attributes if index is created via CREATE TABLE LIKE Message-ID: <20200822014121.GC2108@paquier.xyz> References: <16272-6e32da020e9a9381@postgresql.org> <6861.1582328011@sss.pgh.pa.us> <8840.1587948815@sss.pgh.pa.us> <1727369.1597951104@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="5G06lTa6Jq83wMTw" Content-Disposition: inline In-Reply-To: <1727369.1597951104@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --5G06lTa6Jq83wMTw Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Aug 20, 2020 at 03:18:24PM -0400, Tom Lane wrote: > So attached is a complete fix for the issues discussed in this thread. >=20 > Although I originally felt that we weren't going to be able to create > a back-patchable fix, this seems much less invasive than my prior > attempt, so I think it might be reasonable to back-patch. The only > external API break is the new AT_CookedColumnDefault subcommand, > which we could stick at the end of the enum in stable branches. >=20 > Thoughts? For the archive's sake, this has been committed as of 5028981, backpatched down to 9.5. -- Michael --5G06lTa6Jq83wMTw Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl9Ad8EACgkQnvQgOdby QH0kLg/+IewAwJnZVkLL5LDhNfQ7pjMU7j3XReSja0x2XbwY0aK+arwGbTcbC7oZ /9/6TrwCfKTwzgHuVX740eS0zqQf8GjqyPZnmXJhoGGD9IeuBOfw+1HB7pBVKwAT 2YXmqP3XyHz8pV2Ztk9pjrH0ftHrMbbzP6d0kCEniW829z3DdjrrFbpFWkLtBGWd n6eKIlDq8Hu0iHFjhZ/AHNY8Rktlmh6uYUXeqeyqxA/q62+4SUFDUYq4hDaCEvBY nRGP7hTK9HOJUu2ZQNUOTNp9yIf2uRGotPQLVnjsiXs4rWPY2BcolaEfnzBzU/wv 6cypysQOqbkoc12qCIjkV4k2OoZGOPQNQG4nA9nV2DGIyxLLTxPzZvsXCoQRCS0M FkGMknTdbLpqW2Ub7Bzvhg64qXhefVh2JI8ieAS6YEFElJJoHRkvnnLuQ+FwclgG ttzIN6bxVKOXbFVvP3THLvwOqk724JI9aQ+v9ZCuK+ns24EsjtMcxcZ0pxJNN+6n kKSdA9jHtLXFf+uYQW1o56nAWZPlTtq36hx+wK7vsZrxaMRa0xXSpRCcrhSh/F6l +90XZ/8FiceybA6v4q+LV/oWZoA0gU9Rh7iDxDJYiMEDb4slVAOYZ7RZUYgsyDK5 nn8a6xKy0gZHSDXzKm6COuz2EZrYY4yrAmaXR6f6UrtBzgJx9EU= =mCIi -----END PGP SIGNATURE----- --5G06lTa6Jq83wMTw--