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 1gZT5u-0006tQ-1a for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Dec 2018 04:04:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gZT5s-0001zL-O3 for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Dec 2018 04:04:24 +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 1gZT5s-0001zE-Hw for pgsql-bugs@lists.postgresql.org; Wed, 19 Dec 2018 04:04:24 +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 1gZT5q-0000IC-0r for pgsql-bugs@lists.postgresql.org; Wed, 19 Dec 2018 04:04:24 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id CEB82220F4; Tue, 18 Dec 2018 23:04:20 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Tue, 18 Dec 2018 23:04:20 -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=w5Dveis9Cm3wv5pD6q6LOHbL3Vy wPvwCS58nwEeQipU=; b=nnm4eekFfBoT3UBuNxbUck/wDijl0nD1wPErSx+ge9s ci4ZX+Yqd0ED5BzvDGfY8yJyKqXWctwARjo9Q8FHbkvpFht55Q7Y0tBkfkbetLCh WWi7VmbRRrxJEn72LPcA5wIW83sclQSbHajKOoYM5kc5+TNtOre7/4++0kdnWucQ epOUhTolflRvkyDgZq4FDrru8bEFS4/vuBW6ALFIrM1K8S6TDxwqRC02GwSK+k5n e07GAky1OLdCxDAwI4MRtIY/A5LmbO/HYnaoXa1/OaWI9xO56vYiS28keLbMJkAv M1E3J6ktzFBGMkmYGXH0NYQH/yIVE3ItJ3HJWzpqZcQ== 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=w5Dvei s9Cm3wv5pD6q6LOHbL3VywPvwCS58nwEeQipU=; b=GmQRE1LrqF3CZPh1/WrQiw 1BtaPp/vjOYfHpGBTrTWhEPtWacbc6RkW9DIQWO2OlXibsFSew7aFmqH5LJ0CYAH GgE3SwWE8Hf8R6op7+iAAOfU/eGhFsvMOQKUWBRfvbbG94nG0/VcixPiRcb9scoK rc6RloXaFeGlnOWYhYa8ey90nrVKq3JRt0x1VbntyO9fqwf98qRtGIRpI+S6Rx5e lGNvF4JdFwVmK0k0O98pUHkTehrlt9e9Qn6hUmRE2EA61H4C70Q5wyAirZj2Hlzi QX5wksxqigQBzlYyQPmWN35MK1NJH2WQxaUJvWkITVOTRKGDB5SuqnXJlRWwD7bg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtkedrudeiledgfeekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfquhhtnecuuegrihhlohhuthemucef tddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlhcuvffnffculdefhe dmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgt hhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqne cuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfkphepiedurddvudehrddu feejrdduiedvnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquh hivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 3F86310084; Tue, 18 Dec 2018 23:04:16 -0500 (EST) Date: Wed, 19 Dec 2018 13:04:14 +0900 From: Michael Paquier To: Amit Langote Cc: Luis Carril , Etsuro Fujita , "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: <20181219040414.GA19856@paquier.xyz> References: <8e82d10d-cc16-eed4-7634-3654f59d8053@lab.ntt.co.jp> <30718b48-8020-329a-c6f0-74e1222e5283@lab.ntt.co.jp> <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> <20181219035157.GB6577@paquier.xyz> <9c0508a1-da8e-b122-a3c7-61b2cbe4e10c@lab.ntt.co.jp> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="vkogqOf2sHV7VnPd" Content-Disposition: inline In-Reply-To: <9c0508a1-da8e-b122-a3c7-61b2cbe4e10c@lab.ntt.co.jp> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --vkogqOf2sHV7VnPd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Dec 19, 2018 at 01:01:01PM +0900, Amit Langote wrote: > It may happen sooner that you may think. :) >=20 > Currently, COPY into foreign tables uses APIs used by INSERT, so one row > at a time interface. It'd certainly be better to allow FDWs to be able to > do bulk transfer. I think Fujita-san has said he wants to work on that: >=20 > https://www.postgresql.org/message-id/5AB4F190.1000804%40lab.ntt.co.jp That's interesting. >> One argument for doing nothing yet is that >> this command does not fail now so changing it may cause compatibility >> problems. >=20 > Just FYI, COPYing into foreign tables is only supported as of PG 11. Which has already been released.. Anyway. -- Michael --vkogqOf2sHV7VnPd Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlwZwz4ACgkQnvQgOdby QH18oRAAlFAZxXBxonDuQkxyqYX0/zJByxVcCgC8kzmT0YE5Fej0+RnGQU/IXC6J YflKrrdw1bv2S9yhxla69xFKyzk8oUNhLd6xsYS2z77GwqlHgiMOHkNP8snnQjCK XHKJkwk6tE9JrBOsMgfIxq9SqKE8Hcz+7A1cvnl1CooWJtAl98vb5Em6xcHT7Cqc SBeQABtBaB91oB29hBKb5V7bheY8+f/Opxq9h/KkRya9dMWoKYKpI2LlFEOb9Ti6 BkcyeyfnASxIn64zsXBYOdM/RXDdAtiXHJmwcY4Pz0rcbnTNbWvi5wBWcqioRyvA HLPcxkIDYvjStnCOQg14Pulw5AQfdiGOvJaj98ONdesUnUDJR8x1+Bv4kZy8hZrn zMtObkx0EzUo4MRisdz1+kUVbhWp4LzfllX7nEb6G9DXuDVe1VcyIkFJnaiVjVei 84u3H8nhv4y5S11UFPcSYhhqZx6UfI3Jn1axvEM/EyKIvwjs2GbPxl9DP7AVCEFd WHJ27fjCgOlwVdz1jBK6Y/fpLWCXX++qjQWlwuEC7a5rqPW4I373diRJShgLufqr pGzgZw1fK7fm8kjwdtZJsAGxUJtIeo/ck9KXM5+AIDOkF9sPwDrNQpdn1E/YpeIO 0JqSoApVb3Mx4OyJExOwOUdg05UmkhM+BFrtfUSWibtqnjbGT0I= =V0Jc -----END PGP SIGNATURE----- --vkogqOf2sHV7VnPd--