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 1kLA9k-00012g-52 for pgsql-bugs@arkaria.postgresql.org; Wed, 23 Sep 2020 19:10:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kLA9j-0003AD-1N for pgsql-bugs@arkaria.postgresql.org; Wed, 23 Sep 2020 19:10:19 +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 1kL9iT-0003A8-Sp for pgsql-bugs@lists.postgresql.org; Wed, 23 Sep 2020 18:42:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kL9iN-0002jS-Jm for pgsql-bugs@lists.postgresql.org; Wed, 23 Sep 2020 18:42:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=VwXuGX8G9MkHsawtziVXMicFoxb5LAnR8u3xtWgHhug=; b=jdqQNeMEpBejqiLMyZpnXQ53sj mN+sIuTqalEkCdbwqqqZWaqthM17IlRg8ArN8OLuJFeVFKaT+Amv6Ey9xvRSCeEZB/TCJTIZQd2G4 pwV3JQQbh1bJ3PU2ev149FXFsp9Oy9uYrc2hkZqbOH/Ci3ryOIjLN5ImtYNY9YhzdDMsrI0wi8kf7 s48AQEgjHMwJ6Xi2MkoO3NpRxQopfkQYDfjfkA/Wj7J9BI4otff3m+RDPzTBB1HJtSvGy84alGWFy Jh2G+WCZ5J23+2LATCZndlymIVPEssqabW7oVM7SQ8KwWr8ghEwOWnbkDQhjZcRtJvU2Y+WAF01VB aG6BedWw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kL9iN-00043F-5S for pgsql-bugs@lists.postgresql.org; Wed, 23 Sep 2020 18:42:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kL9iL-0001ZM-Ut for pgsql-bugs@lists.postgresql.org; Wed, 23 Sep 2020 18:42:01 +0000 Content-Type: multipart/mixed; boundary="===============2404161277622520059==" MIME-Version: 1.0 Subject: BUG #16631: postgres_fdw tries to insert into generated columns To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dacherny@gmail.com Reply-To: dacherny@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 23 Sep 2020 18:41:29 +0000 Message-ID: <16631-e929fe9db0ffc7cf@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============2404161277622520059== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjYzMQpMb2dnZWQgYnk6ICAgICAgICAgIERhbmllbCBDaGVybml5CkVt YWlsIGFkZHJlc3M6ICAgICAgZGFjaGVybnlAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTIuNApPcGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiAoYXMgJnF1b3Q7ZG9ja2VyIHB1bGwgcG9z dGdyZXM6bGF0ZXN0JnF1b3Q7KQpEZXNjcmlwdGlvbjogICAgICAgIAoKUG9zdGdyZXMgRkRXIGlt cG9ydHMgZ2VuZXJhdGVkIChzdG9yZWQpIGNvbHVtbnMgZnJvbSBmb3JlaWduIHRhYmxlIGxpa2UK dXN1YWwgY29sdW1ucyBhbmQgdHJpZXMgdG8gaW5zZXJ0IHZhbHVlcyBpbnRvIHRoZW0gaW5zdGVh ZCBvZiBza2lwcGluZy4NCg0KU3RlcHMgdG8gcmVwcm9kdWNlOg0KDQpjcmVhdGUgZXh0ZW5zaW9u IHBvc3RncmVzX2ZkdzsNCmNyZWF0ZSBzZXJ2ZXIgaG9zdF9hc19mb3JlaWduIGZvcmVpZ24gZGF0 YSB3cmFwcGVyIHBvc3RncmVzX2ZkdyBvcHRpb25zCihkYm5hbWUgJ3Bvc3RncmVzJyk7DQpjcmVh dGUgdXNlciBtYXBwaW5nIGZvciBjdXJyZW50X3VzZXIgc2VydmVyIGhvc3RfYXNfZm9yZWlnbjsN Cg0KY3JlYXRlIHNjaGVtYSBzcmM7DQpjcmVhdGUgdGFibGUgc3JjLnRlc3QgKA0KICBpZCBpbnQg cHJpbWFyeSBrZXksDQogIG5hbWUgdGV4dCBub3QgbnVsbCwNCiAgbmFtZV9oYXNoIGNoYXIoMzIp IGdlbmVyYXRlZCBhbHdheXMgYXMgKG1kNShuYW1lKSkgc3RvcmVkDQopOw0KDQppbnNlcnQgaW50 byBzcmMudGVzdCAoaWQsIG5hbWUpIHZhbHVlcyAoMSwgJ0hlbGxvJykgcmV0dXJuaW5nICo7DQor LS0rLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rDQp8aWR8bmFtZSB8bmFt ZV9oYXNoICAgICAgICAgICAgICAgICAgICAgICB8DQorLS0rLS0tLS0rLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0rDQp8MSB8SGVsbG98OGIxYTk5NTNjNDYxMTI5NmE4MjdhYmY4YzQ3 ODA0ZDd8DQorLS0rLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rDQoNCi0t IGxldHMgaW1wb3J0IHNjaGVtYQ0KY3JlYXRlIHNjaGVtYSBmZ247DQppbXBvcnQgZm9yZWlnbiBz Y2hlbWEgc3JjIGxpbWl0IHRvICh0ZXN0KSBmcm9tIHNlcnZlciBob3N0X2FzX2ZvcmVpZ24gaW50 bwpmZ247DQoNCi0tIGFuZCBjaGVjayB3aGF0IHdlJ3ZlIGdvdA0Kc2VsZWN0ICogZnJvbSBmZ24u dGVzdDsNCistLSstLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSsNCnxpZHxu YW1lIHxuYW1lX2hhc2ggICAgICAgICAgICAgICAgICAgICAgIHwNCistLSstLS0tLSstLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSsNCnwxIHxIZWxsb3w4YjFhOTk1M2M0NjExMjk2YTgy N2FiZjhjNDc4MDRkN3wNCistLSstLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LSsNCg0KLS0gdHJ5IHRvIGluc2VydCBvbmx5IGNvbHVtbnMgd2hhdCB3ZSBzdXBwb3NlIHRvDQpp bnNlcnQgaW50byBmZ24udGVzdCAoaWQsIG5hbWUpIHZhbHVlcyAoMiwgJ1RyeSB0byBpbnNlcnQg d2l0aG91dCBnZW5lcmF0ZWQKY29sdW1uJyk7DQo+IFs0MjYwMV0gRVJST1I6IGNhbm5vdCBpbnNl cnQgaW50byBjb2x1bW4gIm5hbWVfaGFzaCINCj4gRGV0YWlsOiBDb2x1bW4gIm5hbWVfaGFzaCIg aXMgYSBnZW5lcmF0ZWQgY29sdW1uLg0KPiBXaGVyZTogcmVtb3RlIFNRTCBjb21tYW5kOiBJTlNF UlQgSU5UTyBzcmMudGVzdChpZCwgbmFtZSwgbmFtZV9oYXNoKQpWQUxVRVMgKCQxLCAkMiwgJDMp DQoNCi0tIG1heWJlIG5vdz8NCmluc2VydCBpbnRvIGZnbi50ZXN0IChpZCwgbmFtZSwgbmFtZV9o YXNoKSB2YWx1ZXMgKDIsICdUcnkgdG8gaW5zZXJ0IHdpdGgKImRlZmF1bHQiIHZhbHVlJywgZGVm YXVsdCk7DQo+IFs0MjYwMV0gRVJST1I6IGNhbm5vdCBpbnNlcnQgaW50byBjb2x1bW4gIm5hbWVf aGFzaCINCj4gRGV0YWlsOiBDb2x1bW4gIm5hbWVfaGFzaCIgaXMgYSBnZW5lcmF0ZWQgY29sdW1u Lg0KPiBXaGVyZTogcmVtb3RlIFNRTCBjb21tYW5kOiBJTlNFUlQgSU5UTyBzcmMudGVzdChpZCwg bmFtZSwgbmFtZV9oYXNoKQpWQUxVRVMgKCQxLCAkMiwgJDMpDQoNCg0Kc2VsZWN0IHZlcnNpb24o KTsNCistLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tKw0KfHZlcnNpb24gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICB8DQorLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLSsNCnxQb3N0Z3JlU1FMIDEyLjQgKERlYmlhbiAxMi40LTEucGdkZzEwMCsxKSBvbiB4 ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxlZApieSBnY2MgKERlYmlhbiA4LjMuMC02KSA4LjMu MCwgNjQtYml0fA0KKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0rCgo= --===============2404161277622520059==--