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 1lZCZw-0001B5-61 for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Apr 2021 13:07:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lZCZv-00009v-3l for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Apr 2021 13:07:39 +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 1lZC9G-0002Tg-Jt for pgsql-bugs@lists.postgresql.org; Wed, 21 Apr 2021 12:40:07 +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 1lZC9E-0000Tx-BI for pgsql-bugs@lists.postgresql.org; Wed, 21 Apr 2021 12:40:05 +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=FYDoLmCcJCq9b5stLyYm3WP89i9W/8D20h+DKA54wvo=; b=pf3Sfs79wu0EPdhSFicUWRFdza QouMze0fXAesxr3hamo8sjdxRcA1NjFD1rlO+SJ4mcwgAh21JizDQjYjFFxwar8kRMFfz05Nm5TwE HBjNBrOmAwXsSMwLRqy44GbT9KuvsLDPL8sVN7xi7945EsbL9n2kvob/ROB+xqkd1WdJtdBszxiXQ b8lMKXAMTiqDqM38IfzmdjHl3M3yKS0T2DOYGVTAPgUii8RXM0xTP0P4ivNFuVijKgoRacpeoINjp PWISXeNQwnMlgqV7rQsftlWMZ4d8g/cFQujF858B9uYugSpwdBliHHgnFRc/5dP2bCKkLDX4/PfqJ A8hfJAzQ==; 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 1lZC9D-00061H-Ob for pgsql-bugs@lists.postgresql.org; Wed, 21 Apr 2021 12:40: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 1lZC9C-0002Rh-EZ for pgsql-bugs@lists.postgresql.org; Wed, 21 Apr 2021 12:40:02 +0000 Content-Type: multipart/mixed; boundary="===============8013198836414968245==" MIME-Version: 1.0 Subject: BUG #16976: server crash when deleting via a trigger on a foreign table To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: herwig.goemans@gmail.com Reply-To: herwig.goemans@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 21 Apr 2021 12:39:30 +0000 Message-ID: <16976-abe0cb88252bc02e@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8013198836414968245== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjk3NgpMb2dnZWQgYnk6ICAgICAgICAgIEhlcndpZyBHb2VtYW5zCkVt YWlsIGFkZHJlc3M6ICAgICAgaGVyd2lnLmdvZW1hbnNAZ21haWwuY29tClBvc3RncmVTUUwgdmVy c2lvbjogMTIuNgpPcGVyYXRpbmcgc3lzdGVtOiAgIHVidW50dSAxOC4wNApEZXNjcmlwdGlvbjog ICAgICAgIAoKSGVsbG8sDQoNCkkgaGF2ZSBleHBlcmllbmNlZCBhIHNlcnZlciBjcmFzaCB3aGVu IGRlbGV0aW5nIGZyb20gYSB0YWJsZSB0aGF0IGFocyBhCmJlZm9yZSB0cmlnZ2VyIG9uIGl0LiBU aGUgYmVmb3JlIHRyaWdnZXIgY2FsbHMgYSBmdW5jdGlvbiB0aGF0IGRlbGV0ZXMgZnJvbQphIGZv cmVpZ24gKGluZm9ybWl4KSB0YWJsZS4NClRoZSB0YWJsZSBpbiBQRzoNCkNSRUFURSBUQUJMRSBt ZXRhZGJsdWNodC5jX2VlbmhlaWQgKA0KCWVuaF9pZCBzZXJpYWwgTk9UIE5VTEwsDQoJZGF0X3dp anppZ2luZyB0aW1lc3RhbXAgTk9UIE5VTEwsDQoJZ2Vicl93aWp6aWdpbmcgdmFyY2hhcigyNTUp IE5VTEwsDQoJQ09OU1RSQUlOVCBwa19lbmggUFJJTUFSWSBLRVkgKGVuaF9pZCkNCik7DQpUcmln Z2VyIGFuZCBmdW5jdGlvbjoNCmNyZWF0ZSB0cmlnZ2VyIHRkX2NfZWVuaGVpZCBiZWZvcmUNCmRl bGV0ZQ0KICAgIG9uDQogICAgbWV0YWRibHVjaHQuY19lZW5oZWlkIGZvciBlYWNoIHJvdyBleGVj dXRlIGZ1bmN0aW9uIHBkX2NfZWVuaGVpZCgpOw0KY3JlYXRlIHRyaWdnZXIgdGlfY19lZW5oZWlk IGJlZm9yZQ0KaW5zZXJ0DQogICAgb24NCiAgICBtZXRhZGJsdWNodC5jX2VlbmhlaWQgZm9yIGVh Y2ggcm93IGV4ZWN1dGUgZnVuY3Rpb24gcGlfY19lZW5oZWlkKCk7DQpjcmVhdGUgdHJpZ2dlciB0 dV9jX2VlbmhlaWQgYmVmb3JlDQp1cGRhdGUNCiAgICBvbg0KICAgIG1ldGFkYmx1Y2h0LmNfZWVu aGVpZCBmb3IgZWFjaCByb3cgZXhlY3V0ZSBmdW5jdGlvbiBwdV9jX2VlbmhlaWQoKTsNCiAgICAN CiAgIA0KICAgQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gbWV0YWRibHVjaHQucGRfY19lZW5o ZWlkKCkNCiBSRVRVUk5TIHRyaWdnZXINCiBMQU5HVUFHRSBwbHBnc3FsDQpBUyAkZnVuY3Rpb24k DQogICAgICAgICAgICBCRUdJTg0KICAgICAgICAgICAgICAgIGRlbGV0ZSBmcm9tIGluZm9ybWl4 LnRfd2F0ZXJfZWVuaGVpZA0KICAgICAgICAgICAgICAgIHdoZXJlIGVuaF9pZCA9IG5ldy5lbmhf aWQ7DQogICAgICAgICAgICBFTkQ7DQogICAgICAgICRmdW5jdGlvbiQNCjsNCmZvcmVpZ24gdGFi bGU6IA0KQ1JFQVRFIEZPUkVJR04gVEFCTEUgaW5mb3JtaXgudF93YXRlcl9lZW5oZWlkICgNCgll bmhfaWQgaW50NCBOT1QgTlVMTA0KKQ0KU0VSVkVSIG9fb2x0cF9hcHBfd2F0ZXINCk9QVElPTlMg KHRhYmxlICdjX2VlbmhlaWRfbWV0YWRibHVjaHQnLCBkYXRhYmFzZSAnd2F0ZXInLCBjbGllbnRf bG9jYWxlCidlbl9VUy51dGY4JywgZGJfbG9jYWxlICdubF9iZS51dGY4Jyk7DQoNClRoZSBzdGF0 ZW1lbnQgY2F1c2luZyB0aGUgc2VydmVyIGNyYXNoOg0Kc3RhcnQgdHJhbnNhY3Rpb247DQpkZWxl dGUgZnJvbSBtZXRhZGJsdWNodC5jX2VlbmhlaWQgd2hlcmUgZW5oX2lkID0gNDA7DQoNCklmIEkg ZG8gYSBkZWxldGUgZGlyZWN0bHkgb24gdGhlIGZvcmVpZ24gdGFibGUgaXQgd29ya3MgZmluZToN Cg0Kc3RhcnQgdHJhbnNhY3Rpb247DQpkZWxldGUgZnJvbSBpbmZvcm1peC50X3dhdGVyX2Vlbmhl aWQgIHdoZXJlIGVuaF9pZCA9IDQwOw0Kcm9sbGJhY2s7DQoNClRoaXMgaXMgdGhlIHJlbGV2YW50 IHNlY3Rpb24gaW4gdGhlIFBHIGxvZyBmaWxlOg0KX18yMDIxLTA0LTIxIDExOjU0OjMwIENFU1Qg TE9HOiAgc2VydmVyIHByb2Nlc3MgKFBJRCAzOTMzKSB3YXMgdGVybWluYXRlZCBieQpzaWduYWwg MTE6IFNlZ21lbnRhdGlvbiBmYXVsdA0KX18yMDIxLTA0LTIxIDExOjU0OjMwIENFU1QgREVUQUlM OiAgRmFpbGVkIHByb2Nlc3Mgd2FzIHJ1bm5pbmc6IGRlbGV0ZSBmcm9tCm1ldGFkYmx1Y2h0LmNf ZWVuaGVpZCB3aGVyZSBlbmhfaWQgPSA0MA0KX18yMDIxLTA0LTIxIDExOjU0OjMwIENFU1QgTE9H OiAgdGVybWluYXRpbmcgYW55IG90aGVyIGFjdGl2ZSBzZXJ2ZXIKcHJvY2Vzc2VzDQpnZWJvdXdl bmJlaGVlcmRiYV9nZWJvdXdlbmJlaGVlcl8yMDIxLTA0LTIxIDExOjU0OjMwIENFU1QgV0FSTklO RzogCnRlcm1pbmF0aW5nIGNvbm5lY3Rpb24gYmVjYXVzZSBvZiBjcmFzaCBvZiBhbm90aGVyIHNl cnZlciBwcm9jZXNzDQpnZWJvdXdlbmJlaGVlcmRiYV9nZWJvdXdlbmJlaGVlcl8yMDIxLTA0LTIx IDExOjU0OjMwIENFU1QgREVUQUlMOiAgVGhlCnBvc3RtYXN0ZXIgaGFzIGNvbW1hbmRlZCB0aGlz IHNlcnZlciBwcm9jZXNzIHRvIHJvbGwgYmFjayB0aGUgY3VycmVudAp0cmFuc2FjdGlvbiBhbmQg ZXhpdCwgYmVjYXVzZSBhbm90aGVyIHNlcnZlciBwcm9jZXNzIGV4aXRlZCBhYm5vcm1hbGx5IGFu ZApwb3NzaWJseSBjb3JydXB0ZWQgc2hhcmVkIG1lbW9yeS4NCmdlYm91d2VuYmVoZWVyZGJhX2dl Ym91d2VuYmVoZWVyXzIwMjEtMDQtMjEgMTE6NTQ6MzAgQ0VTVCBISU5UOiAgSW4gYSBtb21lbnQK eW91IHNob3VsZCBiZSBhYmxlIHRvIHJlY29ubmVjdCB0byB0aGUgZGF0YWJhc2UgYW5kIHJlcGVh dCB5b3VyIGNvbW1hbmQuDQpvYXJpX2FyaV8yMDIxLTA0LTIxIDExOjU0OjMwIENFU1QgV0FSTklO RzogIHRlcm1pbmF0aW5nIGNvbm5lY3Rpb24gYmVjYXVzZQpvZiBjcmFzaCBvZiBhbm90aGVyIHNl cnZlciBwcm9jZXNzDQpvYXJpX2FyaV8yMDIxLTA0LTIxIDExOjU0OjMwIENFU1QgREVUQUlMOiAg VGhlIHBvc3RtYXN0ZXIgaGFzIGNvbW1hbmRlZCB0aGlzCnNlcnZlciBwcm9jZXNzIHRvIHJvbGwg YmFjayB0aGUgY3VycmVudCB0cmFuc2FjdGlvbiBhbmQgZXhpdCwgYmVjYXVzZQphbm90aGVyIHNl cnZlciBwcm9jZXNzIGV4aXRlZCBhYm5vcm1hbGx5IGFuZCBwb3NzaWJseSBjb3JydXB0ZWQgc2hh cmVkCm1lbW9yeS4NCm9hcmlfYXJpXzIwMjEtMDQtMjEgMTE6NTQ6MzAgQ0VTVCBISU5UOiAgSW4g YSBtb21lbnQgeW91IHNob3VsZCBiZSBhYmxlIHRvCnJlY29ubmVjdCB0byB0aGUgZGF0YWJhc2Ug YW5kIHJlcGVhdCB5b3VyIGNvbW1hbmQuDQoNCg0KSSBob3BlIHNvbWVvbmUgY2FuIGhlbHAuDQpU aGFua3MuCgo= --===============8013198836414968245==--