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 1gZWd3-000429-Hg for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Dec 2018 07:50:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gZWd2-00041v-7Q for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Dec 2018 07:50:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gZWd1-00041o-U7 for pgsql-bugs@lists.postgresql.org; Wed, 19 Dec 2018 07:50:52 +0000 Received: from tama500.ecl.ntt.co.jp ([129.60.39.148]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gZWcz-0004Gi-0J for pgsql-bugs@lists.postgresql.org; Wed, 19 Dec 2018 07:50:50 +0000 Received: from vc2.ecl.ntt.co.jp (vc2.ecl.ntt.co.jp [129.60.86.154]) by tama500.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id wBJ7olNO003809; Wed, 19 Dec 2018 16:50:47 +0900 Received: from vc2.ecl.ntt.co.jp (localhost [127.0.0.1]) by vc2.ecl.ntt.co.jp (Postfix) with ESMTP id 2AB1863914A; Wed, 19 Dec 2018 16:50:47 +0900 (JST) Received: from jcms-pop21.ecl.ntt.co.jp (jcms-pop21.ecl.ntt.co.jp [129.60.87.134]) by vc2.ecl.ntt.co.jp (Postfix) with ESMTP id 14D80638EBF; Wed, 19 Dec 2018 16:50:47 +0900 (JST) Received: from [IPv6:::1] (unknown [129.60.241.75]) by jcms-pop21.ecl.ntt.co.jp (Postfix) with ESMTPSA id 001C9400A27; Wed, 19 Dec 2018 16:50:46 +0900 (JST) Message-ID: <5C19F85F.1040909@lab.ntt.co.jp> Date: Wed, 19 Dec 2018 16:50:55 +0900 From: Etsuro Fujita User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20120327 Thunderbird/11.0.1 MIME-Version: 1.0 Subject: Re: BUG #15552: Unexpected error in COPY to a foreign table in a transaction 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> <20181219040414.GA19856@paquier.xyz> In-Reply-To: <20181219040414.GA19856@paquier.xyz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-CC-Mail-RelayStamp: 1 To: Michael Paquier Cc: Amit Langote , Luis Carril , "pgsql-bugs@lists.postgresql.org" , PG Bug reporting form , Michael Paquier X-TM-AS-MML: disable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk (2018/12/19 13:04), Michael Paquier wrote: > On Wed, Dec 19, 2018 at 01:01:01PM +0900, Amit Langote wrote: >> It may happen sooner that you may think. :) >> >> 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: >> >> https://www.postgresql.org/message-id/5AB4F190.1000804%40lab.ntt.co.jp > > That's interesting. Thanks! Actually, I (re-)started working on that from this week. (Not sure whether I can post a patch for that before the next CF.) Best regards, Etsuro Fujita