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 ) id 1gaC64-0005LS-Od for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Dec 2018 04:07:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gaC63-000445-Gs for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Dec 2018 04:07:35 +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 ) id 1gaC63-00043y-AF for pgsql-bugs@lists.postgresql.org; Fri, 21 Dec 2018 04:07:35 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gaC60-0004NC-On for pgsql-bugs@lists.postgresql.org; Fri, 21 Dec 2018 04:07:34 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 58BCD222A3; Thu, 20 Dec 2018 23:07:31 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Thu, 20 Dec 2018 23:07:31 -0500 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=fm3; bh=7gv4J4ZxphJr2tT51NJ0FDPAuDk bqOoGWWsFe0W5EyM=; b=X/RaoKgRa8d0eDWXHZ0AN5v7n8sjtiRTSRzpOVMGRfy FPTjgClvXSSO17Ce3qne8HaUJxKXaUAEr+jeGQf6Ehpl0/fzGw/GWYk786jZMyXv Nz3cMlHdSGJXCQe0zCaUzbaemJFXHcSA8+pmaNb1R9nOo0ljPCw06bXvgoZA24c4 5hJ+FYSo8Z4Lf55OwJYeXmb8VlAc2xeqau7vO2rb+wxJKKfPRHwYonnr7MnEM10W oZVbsBwltvb/1Fz2B9kKiNBRjcBTT3T6Y3xnYRUGdeyDc3N6jIfdsjAorJ3eW6J5 FA13o95l7W5JI1aTVLcDAf/4wCvdCnult/x6G5B+MkA== 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=fm1; bh=7gv4J4 ZxphJr2tT51NJ0FDPAuDkbqOoGWWsFe0W5EyM=; b=T1uyVbE0B6woogE6Io3SJX kyXcCFU3UHH9XjkbFcgfVwQetW8WJFS+bh2Rtu1zDcfeFhvXQOoixIfEJYA5XU48 N/Zgdp1iM5YHP/LKNHHtroUsSmsftazzLFonhO2QnIw1/UO23drFzyb8UurbamYz HDPV0ojgoiWNUT90+EIR/J6XSVfWXs+qFdZp5w7uFTEvDI0dRljL1hsPw3psJgLj b8sSTkZGgph5p9X0LBTocg1FvhW48eR12AxSfDuATqSZ/Dw0JZWTliLu/h85HEQn wF32tFr15wOyg4TYB1X29GPuWQzfsPdT1idOaQk8/uM4V8s1xYb/cQVNUhw201KQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtkedrudejgedgieehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfquhhtnecuuegrihhlohhuthemucef tddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlhcuvffnffculdejtd dmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgt hhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqne cukfhppeduudekrddvgedurddvgeelrddvfeelnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (mp76f1f9ef.ap.nuro.jp [118.241.249.239]) by mail.messagingengine.com (Postfix) with ESMTPA id 50151E4596; Thu, 20 Dec 2018 23:07:28 -0500 (EST) Date: Fri, 21 Dec 2018 13:07:24 +0900 From: Michael Paquier To: Etsuro Fujita Cc: Amit Langote , Luis Carril , "pgsql-bugs@lists.postgresql.org" , PG Bug reporting form , Michael Paquier Subject: Re: BUG #15552: Unexpected error in COPY to a foreign table in a transaction Message-ID: <20181221040724.GF1886@paquier.xyz> References: <5C18ECBB.2000507@lab.ntt.co.jp> <3539e73a-313a-5406-27c7-850affb47921@lab.ntt.co.jp> <20181219023814.GA6577@paquier.xyz> <6daa6d4a-d4a9-bd2c-0b84-c4e31d2b9844@lab.ntt.co.jp> <5C19F7FF.9060904@lab.ntt.co.jp> <20181219083422.GA680@paquier.xyz> <5C1A0B6C.1040502@lab.ntt.co.jp> <20181220003140.GE27104@paquier.xyz> <5C1C62C5.8040409@lab.ntt.co.jp> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="TmwHKJoIRFM7Mu/A" Content-Disposition: inline In-Reply-To: <5C1C62C5.8040409@lab.ntt.co.jp> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --TmwHKJoIRFM7Mu/A Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Dec 21, 2018 at 12:49:25PM +0900, Etsuro Fujita wrote: > (2018/12/20 9:31), Michael Paquier wrote: >> Attached is the patch with two new test cases blowing with wal_level =3D >> minimal. On HEAD, I suggest that we use RELKIND_CAN_HAVE_STORAGE to not >> fall again in this trap in the future. For back-branches, let's just >> add the appropriate relkind checks as suggested upthread. >=20 > To make maintenance easy, I think it might be better to add the appropria= te > relkind checks on HEAD as well. Other than that, the patch looks good to > me. Well, using RELKIND_CAN_HAVE_STORAGE is exactly to ease future maintenance so as we don't fall again into the same trap if a new relkind which has no physical storage gets introduced if it supports COPY FROM. So I would keep really it on HEAD. > Thanks for the updated patch! And thanks for taking the time to review the patch. -- Michael --TmwHKJoIRFM7Mu/A Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlwcZvwACgkQnvQgOdby QH3xOA/+MOspx4uFNb6Q+600vvwum9RX8ODgiRlWxgGc8uJ3Xc0Hm/iQ2hkckG0Z Cvv5FYGy15SNHLlCWN1k1XHrd+dICGognA3BXrOwU+HV+kfWXeIe2+FxCvRdS+S7 xgayrDTYlkpXDkBHAz2BARdRNHKnKvs1vPn1b4VZSnlTNjUyuYfiueA1/9HZb4AD 2+Ng4h5qZ3TOcCOIObXi5kvdGIvlqBHwvdK4PU6qnjxUJ1+tWkVxDUXUqWjvzksk Z5QJfIT+1G6ch5xGqlt4crCNuUNzPBeJTwYJeSltxaEFV1HAryBEjgMayiEhf4wG WhglZBkw4DLa+iKJGYN31i+HW+eRR8cv1kjI9HYsd3fkULtcu7IfFEaYFkoKHbHD YX9pZyZodM1y57iFu99WBY2/26GFAC8sK8BxuO859pMO9XmFMELCQfcbl2W9e8e6 UEoK3QvyChx3q2OI68PNDtA9saD7f+rpwzTMNTUczh7/G1Z713VpVjdOt/eatckd oT6ccWc4tizucujfCRk7yqrCebqew6UQaRHfVLx4Usd76UEeFcsDRGzFp/vviZSF b+cPxIjjtk0CMsLPHa9Ka1Hd9FTLVpboSt7HWtlAfSUiQ0B+eAC8EFjzQFVarUCJ itGrApSkOdXc4YB8kAHAwK/z9zOpJKmsNPpgU7XexiOo3vlQbTU= =7KFe -----END PGP SIGNATURE----- --TmwHKJoIRFM7Mu/A--