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 1gZXJL-0006qz-SM for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Dec 2018 08:34: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 1gZXJK-0006sj-6t for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Dec 2018 08:34:34 +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 1gZXJJ-0006sc-DH for pgsql-bugs@lists.postgresql.org; Wed, 19 Dec 2018 08:34:34 +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 1gZXJH-0000Ax-0T for pgsql-bugs@lists.postgresql.org; Wed, 19 Dec 2018 08:34:33 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 62BFE21FE0; Wed, 19 Dec 2018 03:34:29 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 19 Dec 2018 03:34:29 -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=y1YUbqdegMe1WCA9wAh+4m2QhAs Hd+Hnr1gvupoNyF4=; b=DKF5edi5dp9rvKkT8LKMohWO1bkY5PQ39zxV2FYj15p AL+5eo5aYD01Gxc9maj0ZD72HQgTedLvssiXc4hOPRY1IPsNbhDgvUaD4Lq1rP/h 5tiaDbyC0IHXMCnbuMUM5h0+5IEvLWx8c75pwpQJ5Ex35og7qSbXkhSfXLAOr+oP unnkPgR26eGzoA6aYGPVOhy4Ij9Sj3npqODF7pTbKikyRDJ94mOMjQKVoR3e/ARu jWezEt/Yc3iC7LUCokgn1G/e3I4J1wSW3SKV+4yYf/uOdknhbv10kgQ2tta3Q9Bk dvYdkz+j218YEelnpTJfiEpJYcFvV2Sh5fg7NzB8q/Q== 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=y1YUbq degMe1WCA9wAh+4m2QhAsHd+Hnr1gvupoNyF4=; b=CRUWQ7vo3YxuYNpI3JqBJh kyLE3U1JJT/R2FZh1injDcBO5ufZ1RSK1paIgCB5WmxWbYbJ3RR3RpUx0Ge2Q3L1 wq13FVHTiC5cYK0IQCLztHImbbj8TMgHPNYU+hktdjudJ3wydlV7iiWHBSVO1a6q RGSV21V8EFrDDnenLm4Gp2imCu9Qo8BwqfykK0VTFueSCOu1Ge+BkPIKyTH0XRFE mblfue9TpZJgE44D+A0UBUGS0m43qZEMlnbQJSRRb4R/AYij1woNAR4TEotl+sl6 CpmSUQEXLWLX1/dfSsDcT8GtrZtuh4/QygBkZVhLBrmebjnQPAW6SLQ2P0bvXurw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtkedrudeiledgledvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfquhhtnecuuegrihhlohhuthemucef tddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlhcuvffnffculdejtd dmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgt hhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqne cukfhppeeiuddrvdduhedrudefjedrudeivdenucfrrghrrghmpehmrghilhhfrhhomhep mhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id B005B10087; Wed, 19 Dec 2018 03:34:25 -0500 (EST) Date: Wed, 19 Dec 2018 17:34:22 +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: <20181219083422.GA680@paquier.xyz> References: <15552-c64aa14c5c22f63c@postgresql.org> <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> <5C19F7FF.9060904@lab.ntt.co.jp> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Nq2Wo0NMKNjxTN9z" Content-Disposition: inline In-Reply-To: <5C19F7FF.9060904@lab.ntt.co.jp> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Nq2Wo0NMKNjxTN9z Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Dec 19, 2018 at 04:49:19PM +0900, Etsuro Fujita wrote: > BTW I noticed that this error occurs not only for foreign tables but for > views with INSTEAD OF INSERT triggers. Here is an example on HEAD: >=20 > To fix this I think we would also need the same treatment for the view ca= se. Yes, this means an extra relkind check for views. Would you like to update the patch yourself? -- Michael --Nq2Wo0NMKNjxTN9z Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlwaAo4ACgkQnvQgOdby QH0q0w//Z+Djuucg5JfcDuK/aJx/CPq6F8jR+DgXEzZ9Fk7oCfuGFNASqXYjbJYZ FUjITN85cJgw2P7DJnyPwo9qWXbdgPQB0Rfyn5cym9Vf29DRShO2MlXTSPOu70qG qWsUMrdsZByaeLOXvBrjYMKrsqiFxsdPebA/P/YajYfABEZ4s8EqL+Tz8E9itjMK 4tUzNelnxuXMoqJ8vOr3xOJtJBM+OovRYXI9CLKwdYiNr+wowy+LpsJN2Mf0NRP0 77RRQrGCIZzxPX7cTQCDz6o6HBPAjjMJFRUs60zxNTdwooOC0hmF2gspS3uLuGhA DDSkQrdO4zJ0dwKx8jzQHLl3x27nJbTRLh3p3+vgLnjsD2hLAtDcejjdEy+K6xcu 3MlAEpiUWnXHdJiIkONi3OpeoafsG7ZHngtqJALbTgQvv3XutW3taAXEp5G8NK0W TWoEfF2gJTfd/TLHP3lfS/bjwVcm0nD5yZBT4+QXtaQLLcNvuWxE/xK1Zgu4gP1C cOhowprhvmf38S1956WmdaFJ434GAk4Fpm4UHIALmH4Bl2MxyQvz6ht5qobL+hDF 7NNtonrQL/qddGO/Pl4TulmmrSLADcHT39D1iuchgLefP6SwTArLN1SVLEiANzFe nnf2G3ShnHlUNfN0R7qeSBhm/U6M0FoZrPxou7r5q39A//LT2/o= =EP0N -----END PGP SIGNATURE----- --Nq2Wo0NMKNjxTN9z--