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 1iZrdN-0007hs-Bq for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Nov 2019 07:21:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iZrdL-0004YL-QW for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Nov 2019 07:21:07 +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 1iZrdL-0004YD-IG for pgsql-bugs@lists.postgresql.org; Wed, 27 Nov 2019 07:21:07 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iZrdJ-0007v0-Aq for pgsql-bugs@lists.postgresql.org; Wed, 27 Nov 2019 07:21:07 +0000 Content-Type: multipart/mixed; boundary="===============3007505193418558187==" MIME-Version: 1.0 Subject: BUG #16139: Assertion fails on INSERT into a postgres_fdw' table with two AFTER INSERT triggers To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 27 Nov 2019 07:20:45 +0000 Message-ID: <16139-94f9ccf0db6119ec@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3007505193418558187== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjEzOQpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTIuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAxOC4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyBzY3JpcHQ6DQpDUkVBVEUgRVhURU5TSU9OIHBvc3RncmVzX2Zk dzsNCkNSRUFURSBTRVJWRVIgbG9vcGJhY2sgRk9SRUlHTiBEQVRBIFdSQVBQRVIgcG9zdGdyZXNf ZmR3IE9QVElPTlMgKGRibmFtZQoncG9zdGdyZXMnKTsNCkNSRUFURSBVU0VSIE1BUFBJTkcgRk9S IENVUlJFTlRfVVNFUiBTRVJWRVIgbG9vcGJhY2s7DQpDUkVBVEUgVEFCTEUgbG9jMiAoZjEgaW50 KTsNCkNSRUFURSBGT1JFSUdOIFRBQkxFIHJlbTIgKGYxIGludCkgU0VSVkVSIGxvb3BiYWNrIE9Q VElPTlModGFibGVfbmFtZQonbG9jMicpOw0KQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gdHJp Z2dlcl9kYXRhKCkgUkVUVVJOUyB0cmlnZ2VyDQpMQU5HVUFHRSBwbHBnc3FsIEFTICdiZWdpbiBy ZXR1cm4gTkVXOyBlbmQ7JzsNCg0KQ1JFQVRFIFRSSUdHRVIgdHJpZ2dlcjEgQUZURVIgSU5TRVJU IE9OIHJlbTIgRk9SIEVBQ0ggUk9XIEVYRUNVVEUgUFJPQ0VEVVJFCnRyaWdnZXJfZGF0YSgpOw0K Q1JFQVRFIFRSSUdHRVIgdHJpZ2dlcjIgQUZURVIgSU5TRVJUIE9OIHJlbTIgRk9SIEVBQ0ggUk9X IEVYRUNVVEUgUFJPQ0VEVVJFCnRyaWdnZXJfZGF0YSgpOw0KSU5TRVJUIElOVE8gcmVtMiBWQUxV RVMoMSk7DQoNCnJhaXNlcyB0aGUgYXNzZXJ0aW9uOg0KQ29yZSB3YXMgZ2VuZXJhdGVkIGJ5IGBw b3N0Z3JlczogbGF3IHJlZ3Jlc3Npb24gW2xvY2FsXSBJTlNFUlQgICAgICAgICAgICAgIAogICAg ICAgICAgICAgICAgICAgICAgICAnLg0KUHJvZ3JhbSB0ZXJtaW5hdGVkIHdpdGggc2lnbmFsIFNJ R0FCUlQsIEFib3J0ZWQuDQojMCAgX19HSV9yYWlzZSAoc2lnPXNpZ0BlbnRyeT02KSBhdCAuLi9z eXNkZXBzL3VuaXgvc3lzdi9saW51eC9yYWlzZS5jOjUxDQo1MSAgICAgIC4uL3N5c2RlcHMvdW5p eC9zeXN2L2xpbnV4L3JhaXNlLmM6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3RvcnkuDQooZ2RiKSBi dA0KIzAgIF9fR0lfcmFpc2UgKHNpZz1zaWdAZW50cnk9NikgYXQgLi4vc3lzZGVwcy91bml4L3N5 c3YvbGludXgvcmFpc2UuYzo1MQ0KIzEgIDB4MDAwMDdmZDg2NmU5NzgwMSBpbiBfX0dJX2Fib3J0 ICgpIGF0IGFib3J0LmM6NzkNCiMyICAweDAwMDA1NWMyY2ZjMmYwMjIgaW4gRXhjZXB0aW9uYWxD b25kaXRpb24gKA0KICAgIGNvbmRpdGlvbk5hbWU9Y29uZGl0aW9uTmFtZUBlbnRyeT0weDU1YzJj ZmRhYTIyOCAiISghKCgoc2xvdCktPnR0c19mbGFncwomICgxIDw8IDEpKSAhPSAwKSkiLCANCiAg ICBlcnJvclR5cGU9ZXJyb3JUeXBlQGVudHJ5PTB4NTVjMmNmYzg2MTA4ICJGYWlsZWRBc3NlcnRp b24iLApmaWxlTmFtZT1maWxlTmFtZUBlbnRyeT0weDU1YzJjZmRjN2UzYiAiZXhlY1R1cGxlcy5j IiwgDQogICAgbGluZU51bWJlcj1saW5lTnVtYmVyQGVudHJ5PTE2MjApIGF0IGFzc2VydC5jOjU0 DQojMyAgMHgwMDAwNTVjMmNmOTkzODBmIGluIEV4ZWNGZXRjaFNsb3RIZWFwVHVwbGUKKHNsb3Q9 c2xvdEBlbnRyeT0weDU1YzJkMDNiMmJjOCwgbWF0ZXJpYWxpemU9bWF0ZXJpYWxpemVAZW50cnk9 dHJ1ZSwgDQogICAgc2hvdWxkRnJlZT1zaG91bGRGcmVlQGVudHJ5PTB4N2ZmZDg2Y2YyNjBlKSBh dCBleGVjVHVwbGVzLmM6MTYyMA0KIzQgIDB4MDAwMDU1YzJjZjk2MDliNyBpbiBBZnRlclRyaWdn ZXJFeGVjdXRlCihlc3RhdGU9ZXN0YXRlQGVudHJ5PTB4NTVjMmQwMzlkZDg4LCBldmVudD1ldmVu dEBlbnRyeT0weDU1YzJkMDNjMGI3YywgDQogICAgcmVsSW5mbz1yZWxJbmZvQGVudHJ5PTB4NTVj MmQwMzllMDI4LAp0cmlnZGVzYz10cmlnZGVzY0BlbnRyeT0weDU1YzJkMDM5ZTE0MCwgZmluZm89 ZmluZm9AZW50cnk9MHg1NWMyZDAzOWUzMDAsIA0KICAgIGluc3RyPWluc3RyQGVudHJ5PTB4MCwg cGVyX3R1cGxlX2NvbnRleHQ9MHg1NWMyZDAzYzJhNTAsCnRyaWdfdHVwbGVfc2xvdDE9MHg1NWMy ZDAzYjJiYzgsIA0KICAgIHRyaWdfdHVwbGVfc2xvdDI9MHg1NWMyZDAzYjJjNjApIGF0IHRyaWdn ZXIuYzo0MjU5DQojNSAgMHgwMDAwNTVjMmNmOTYwZmE1IGluIGFmdGVyVHJpZ2dlckludm9rZUV2 ZW50cwooZXZlbnRzPWV2ZW50c0BlbnRyeT0weDU1YzJkMDM0ZWJmOCwgZmlyaW5nX2lkPTEsIA0K ICAgIGVzdGF0ZT1lc3RhdGVAZW50cnk9MHg1NWMyZDAzOWRkODgsIGRlbGV0ZV9vaz1kZWxldGVf b2tAZW50cnk9ZmFsc2UpIGF0CnRyaWdnZXIuYzo0NTQwDQojNiAgMHgwMDAwNTVjMmNmOTY2ODc2 IGluIEFmdGVyVHJpZ2dlckVuZFF1ZXJ5Cihlc3RhdGU9ZXN0YXRlQGVudHJ5PTB4NTVjMmQwMzlk ZDg4KSBhdCB0cmlnZ2VyLmM6NDg1MQ0KIzcgIDB4MDAwMDU1YzJjZjk4NmM1MyBpbiBzdGFuZGFy ZF9FeGVjdXRvckZpbmlzaCAocXVlcnlEZXNjPTB4NTVjMmQwMmVkYmM4KQphdCBleGVjTWFpbi5j OjQzOQ0KIzggIDB4MDAwMDU1YzJjZjk4NmM3NCBpbiBFeGVjdXRvckZpbmlzaAoocXVlcnlEZXNj PXF1ZXJ5RGVzY0BlbnRyeT0weDU1YzJkMDJlZGJjOCkgYXQgZXhlY01haW4uYzo0MDcNCiM5ICAw eDAwMDA1NWMyY2ZiMDg3NzEgaW4gUHJvY2Vzc1F1ZXJ5IChwbGFuPXBsYW5AZW50cnk9MHg1NWMy ZDAzYWMzZDAsIA0KICAgIHNvdXJjZVRleHQ9MHg1NWMyZDAyY2EzZDggIklOU0VSVCBJTlRPIHJl bTIgVkFMVUVTKDEpOyIsIHBhcmFtcz0weDAsCnF1ZXJ5RW52PTB4MCwgZGVzdD1kZXN0QGVudHJ5 PTB4NTVjMmQwM2FiZTcwLCANCiAgICBjb21wbGV0aW9uVGFnPWNvbXBsZXRpb25UYWdAZW50cnk9 MHg3ZmZkODZjZjI5ZTAgIklOU0VSVCAwIDEiKSBhdApwcXVlcnkuYzoyMDMNCiMxMCAweDAwMDA1 NWMyY2ZiMDg4ZDIgaW4gUG9ydGFsUnVuTXVsdGkKKHBvcnRhbD1wb3J0YWxAZW50cnk9MHg1NWMy ZDAzMzE0OTgsIGlzVG9wTGV2ZWw9aXNUb3BMZXZlbEBlbnRyeT10cnVlLCANCiAgICBzZXRIb2xk U25hcHNob3Q9c2V0SG9sZFNuYXBzaG90QGVudHJ5PWZhbHNlLApkZXN0PWRlc3RAZW50cnk9MHg1 NWMyZDAzYWJlNzAsIGFsdGRlc3Q9YWx0ZGVzdEBlbnRyeT0weDU1YzJkMDNhYmU3MCwgDQogICAg Y29tcGxldGlvblRhZz1jb21wbGV0aW9uVGFnQGVudHJ5PTB4N2ZmZDg2Y2YyOWUwICJJTlNFUlQg MCAxIikgYXQKcHF1ZXJ5LmM6MTI4Mw0KIzExIDB4MDAwMDU1YzJjZmIwOTc3ZCBpbiBQb3J0YWxS dW4gKHBvcnRhbD1wb3J0YWxAZW50cnk9MHg1NWMyZDAzMzE0OTgsCmNvdW50PWNvdW50QGVudHJ5 PTkyMjMzNzIwMzY4NTQ3NzU4MDcsIA0KICAgIGlzVG9wTGV2ZWw9aXNUb3BMZXZlbEBlbnRyeT10 cnVlLCBydW5fb25jZT1ydW5fb25jZUBlbnRyeT10cnVlLApkZXN0PWRlc3RAZW50cnk9MHg1NWMy ZDAzYWJlNzAsIA0KICAgIGFsdGRlc3Q9YWx0ZGVzdEBlbnRyeT0weDU1YzJkMDNhYmU3MCwgY29t cGxldGlvblRhZz0weDdmZmQ4NmNmMjllMAoiSU5TRVJUIDAgMSIpIGF0IHBxdWVyeS5jOjc5Ng0K IzEyIDB4MDAwMDU1YzJjZmIwNWEyZCBpbiBleGVjX3NpbXBsZV9xdWVyeSAoDQogICAgcXVlcnlf c3RyaW5nPXF1ZXJ5X3N0cmluZ0BlbnRyeT0weDU1YzJkMDJjYTNkOCAiSU5TRVJUIElOVE8gcmVt MgpWQUxVRVMoMSk7IikgYXQgcG9zdGdyZXMuYzoxMjE1DQojMTMgMHgwMDAwNTVjMmNmYjA3OWZk IGluIFBvc3RncmVzTWFpbiAoYXJnYz08b3B0aW1pemVkIG91dD4sCmFyZ3Y9YXJndkBlbnRyeT0w eDU1YzJkMDJmNTU5OCwgZGJuYW1lPTxvcHRpbWl6ZWQgb3V0PiwgDQogICAgdXNlcm5hbWU9PG9w dGltaXplZCBvdXQ+KSBhdCBwb3N0Z3Jlcy5jOjQyMzYNCiMxNCAweDAwMDA1NWMyY2ZhNzllMmQg aW4gQmFja2VuZFJ1biAocG9ydD1wb3J0QGVudHJ5PTB4NTVjMmQwMmViOWQwKSBhdApwb3N0bWFz dGVyLmM6NDQzNw0KIzE1IDB4MDAwMDU1YzJjZmE3ZDBmMyBpbiBCYWNrZW5kU3RhcnR1cCAocG9y dD1wb3J0QGVudHJ5PTB4NTVjMmQwMmViOWQwKSBhdApwb3N0bWFzdGVyLmM6NDEyOA0KIzE2IDB4 MDAwMDU1YzJjZmE3ZDQwYSBpbiBTZXJ2ZXJMb29wICgpIGF0IHBvc3RtYXN0ZXIuYzoxNzA0DQoj MTcgMHgwMDAwNTVjMmNmYTdlN2ZiIGluIFBvc3RtYXN0ZXJNYWluIChhcmdjPTMsIGFyZ3Y9PG9w dGltaXplZCBvdXQ+KSBhdApwb3N0bWFzdGVyLmM6MTM3Nw0KIzE4IDB4MDAwMDU1YzJjZjlkOWQ4 NyBpbiBtYWluIChhcmdjPTMsIGFyZ3Y9MHg1NWMyZDAyYzRhMzApIGF0IG1haW4uYzoyMjgKCg== --===============3007505193418558187==--