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 1h9XHs-0005yp-QK for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Mar 2019 15:49:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9XHq-0006Eq-5j for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Mar 2019 15:49:50 +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 1h9X3d-00037Z-AS for pgsql-bugs@lists.postgresql.org; Thu, 28 Mar 2019 15:35:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9X3Y-0001hi-Ql for pgsql-bugs@lists.postgresql.org; Thu, 28 Mar 2019 15:35:08 +0000 Content-Type: multipart/mixed; boundary="===============0304605394736144332==" MIME-Version: 1.0 Subject: BUG #15720: `executor could not find named tuplestore ABC` in AFTER DELETE trigger referencing OLD TABLE as ABC To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jason.madden@nextthought.com Reply-To: jason.madden@nextthought.com, pgsql-bugs@lists.postgresql.org Date: Thu, 28 Mar 2019 15:34:43 +0000 Message-ID: <15720-38c2b29e5d720187@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0304605394736144332== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTcyMApMb2dnZWQgYnk6ICAgICAgICAgIEphc29uIE1hZGRlbgpFbWFp bCBhZGRyZXNzOiAgICAgIGphc29uLm1hZGRlbkBuZXh0dGhvdWdodC5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxMS4yCk9wZXJhdGluZyBzeXN0ZW06ICAgUmVkIEhhdCBFbnRlcnByaXNlIExpbnV4 IDcuNgpEZXNjcmlwdGlvbjogICAgICAgIAoKVmVyc2lvbjogUG9zdGdyZVNRTCAxMS4yIG9uIHg4 Nl82NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdjYyAoR0NDKSA0LjguNQoyMDE1MDYyMyAo UmVkIEhhdCA0LjguNS0zNiksIDY0LWJpdA0KDQpBcyBkZXNjcmliZWQgaW4gdGhlIHN1YmplY3Qs IHdlIHNlZW0gdG8gaGF2ZSBwcm9kdWNlZCBhIHJhcmUsIGludGVybWl0dGVudAppc3N1ZSBpbiBh IHRyaWdnZXIgd2hlbiBjYWxsaW5nIGEgcHJvY2VkdXJlIHRoYXQgbW9kaWZpZXMgYSBkZWNsYXJh dGl2ZWx5Cmhhc2ggcGFydGl0aW9uZWQgdGFibGUgd2hpY2ggcmVzdWx0cyBpbiBleGVjdXRpbmcg YSB0cmlnZ2VyIHJlZmVyZW5jaW5nIHRoZQp0cmFuc2l0aW9uIHRhYmxlLiBJbiBzZXZlcmFsIHdl ZWtzIG9mIGZhaXJseSBoZWF2eSB0ZXN0aW5nIG9mIG91cgphcHBsaWNhdGlvbiBhbmQgdGhpcyBz cGVjaWZpYyBjb2RlIHBhdGggd2UndmUgb25seSBwcm9kdWNlZCB0aGlzIGVycm9yIG9uY2UKKGR1 cmluZyBhIGxhcmdlIGF1dG9tYXRlZCBjb25jdXJyZW50IHJ1biwgd2hpY2ggc3VjY2VlZGVkIG9u IHRoZSBzZWNvbmQKYXR0ZW1wdCksIHNvIHNhZGx5IEkgZG9uJ3QgaGF2ZSBjbGVhciByZXByb2R1 Y3Rpb24gc3RlcHMuIFVuZm9ydHVuYXRlbHksIGJ5CnRoZSB0aW1lIHRoaXMgZ290IHJlcG9ydGVk IHRvIG1lIGJhY2tlbmQgbG9nIGluZm9ybWF0aW9uIHdhcyBubyBsb25nZXIKYXZhaWxhYmxlIHNv IEkgY2FuIG9ubHkgcmVwb3J0IHdoYXQgd2Ugc2F3IG9uIHRoZSBmcm9udGVkLg0KDQpIZXJlJ3Mg dGhlIGVycm9yLCBhcyByZXBvcnRlZCBmcm9tIHRoZSBKREJDIGRyaXZlciAobmFtZXMgc2hvcnRl bmVkIGZvcgpjbGFyaXR5KToNCg0KYGBgDQpTUUwgZmFpbHVyZSBjYWxsaW5nOiBTRUxFQ1QgKiBG Uk9NIHdpcF91cGxvYWRfZmluaXNoKC4uLikNCi4uLg0KQ2F1c2VkIGJ5OiBvcmcucG9zdGdyZXNx bC51dGlsLlBTUUxFeGNlcHRpb246IEVSUk9SOiBleGVjdXRvciBjb3VsZCBub3QgZmluZApuYW1l ZCB0dXBsZXN0b3JlICJ1cGRhdGVkX3Bvc2l0aW9ucyINCiAgV2hlcmU6IFNRTCBzdGF0ZW1lbnQg IlVQREFURSB3X2luc3RhbmNlcyBwaQ0KICAgIFNFVCBsYXN0X21vZGlmaWVkID0gTk9XKCkNCiAg ICBGUk9NIHVwZGF0ZWRfcG9zaXRpb25zIHVwDQogICAgV0hFUkUgcGkub2JqZWN0X2lkID0gdXAu cF9pbnN0YW5jZV9pZCINClBML3BnU1FMIGZ1bmN0aW9uIHdpcF91cGRhdGVfQUNfdHJpZ2dlcl9m dW5jKCkgbGluZSAyNCBhdCBTUUwgc3RhdGVtZW50DQpTUUwgc3RhdGVtZW50ICINCiAgICAgIERF TEVURSBGUk9NIHdpcA0KICAgICAgV0hFUkUgcF9pbnN0YW5jZV9pZCA9ICgNCiAgICAgICAgU0VM RUNUIG9iamVjdF9pZA0KICAgICAgICBGUk9NIHdfaW5zdGFuY2VzDQogICAgICAgIFdIRVJFIGMx ID0gJDEgYW5kIGMyID0gJDINCiAgICAgICkNCiAgICAiDQpgYGANCg0KYHdpcGAgaXMgYSBkZWNs YXJhdGl2ZWx5IGhhc2ggcGFydGl0aW9uZWQgdGFibGUgd2l0aCB0ZW4gcGFydGl0aW9uczoNCmBg YA0KQ1JFQVRFIFRBQkxFIHdpcCAoDQogICAgb2JqZWN0X2lkIG9iamVjdF9pZF90eXBlIE5PVCBO VUxMIERFRkFVTFQgbmV4dHZhbCgnc2VxX29iamVjdF9pZCcpLA0KICAgIHBfaW5zdGFuY2VfaWQg b2JqZWN0X2lkX3R5cGUgTk9UIE5VTEwsDQogICAgc21faWQgb2JqZWN0X2lkX3R5cGUgTk9UIE5V TEwsDQogICAgY3NuIFRFWFQsDQogICAgdGFncyBqc29uYiwNCiAgICBDT05TVFJBSU5UIHdpcF9w a2V5DQogICAgICAgICAgICAgUFJJTUFSWSBLRVkgKG9iamVjdF9pZCwgcF9pbnN0YW5jZV9pZCks DQopDQogIFBBUlRJVElPTiBCWSBIQVNIKHBfaW5zdGFuY2VfaWQpOw0KYGBgDQoNCkl0IGhhcyBm b3VyIHN0YXRlbWVudCB0cmlnZ2VycyBvbiBpdCwgdHdvIGVhY2ggZm9yIElOU0VSVCBhbmQgREVM RVRFLCBhbGwgb2YKd2hpY2ggcmVmZXJlbmNlIGEgdHJhbnNpdGlvbiB0YWJsZToNCg0KYGBgDQpD UkVBVEUgVFJJR0dFUiB3aXBfdXBkYXRlX0FDX2RlbGV0ZV90cmlnZ2VyDQogIEFGVEVSIERFTEVU RQ0KICBPTiB3aXANCiAgUkVGRVJFTkNJTkcgT0xEIFRBQkxFIEFTIHVwZGF0ZWRfcG9zaXRpb25z DQogIEZPUiBFQUNIIFNUQVRFTUVOVA0KICBFWEVDVVRFIFBST0NFRFVSRSB3aXBfdXBkYXRlX0FD X3RyaWdnZXJfZnVuYygpOw0KDQpDUkVBVEUgVFJJR0dFUiB3aXBfdXBkYXRlX0FDX2luc2VydF90 cmlnZ2VyDQogIEFGVEVSIElOU0VSVA0KICBPTiB3aXANCiAgUkVGRVJFTkNJTkcgTkVXIFRBQkxF IEFTIHVwZGF0ZWRfcG9zaXRpb25zDQogIEZPUiBFQUNIIFNUQVRFTUVOVA0KICBFWEVDVVRFIFBS T0NFRFVSRSB3aXBfdXBkYXRlX0FDX3RyaWdnZXJfZnVuYygpOw0KYGBgDQoNClRoZSB0cmlnZ2Vy IGZ1bmN0aW9uIHJlZmVyZW5jZXMgdGhlIHRyYW5zaXRpb24gdGFibGUgaW4gYSBsb29wLCBhbmQg dGhhdAp3b3JrZWQuIEFmdGVyIHRoZSBsb29wIHRoZXJlJ3MgYSBzdGF0ZW1lbnQgdGhhdCByZXN1 bHRlZCBpbiB0aGUgZXJyb3IgKGxpbmUKbnVtYmVycyBzaG91bGQgbWF0Y2ggdXApOg0KDQpgYGAN CkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHdpcF91cGRhdGVfQUNfdHJpZ2dlcl9mdW5jKCkN ClJFVFVSTlMgVFJJR0dFUg0KTEFOR1VBR0UgcGxwZ3NxbA0KQVMNCiQkDQpERUNMQVJFDQogIHJl YyBSRUNPUkQ7DQpCRUdJTg0KICAtLSBjb21tZW50DQogIC0tIGNvbW1lbnQNCiAgLS0gY29tbWVu dA0KICAtLSBjb21tZW50DQogIEZPUiByZWMgSU4gU0VMRUNUIERJU1RJTkNUIHBfaW5zdGFuY2Vf aWQgRlJPTSB1cGRhdGVkX3Bvc2l0aW9ucyBMT09QDQoNCiAgICBVUERBVEUgd19pbnN0YW5jZXMg cGkNCiAgICBTRVQgYzEgPSBDT0FMRVNDRSgNCiAgICAgIChTRUxFQ1QgYzENCiAgICAgICBGUk9N IHZpZXcxIGFwDQogICAgICAgV0hFUkUgYXAucF9pbnN0YW5jZV9pZCA9IHJlYy5wX2luc3RhbmNl X2lkKSwNCiAgICAgcGkuYzEpDQogICAgV0hFUkUgb2JqZWN0X2lkID0gcmVjLnBfaW5zdGFuY2Vf aWQNCiAgICBBTkQgRVhJU1RTIChTRUxFQ1QgMSBGUk9NIHdpcCBXSEVSRSBwX2luc3RhbmNlX2lk ID0KcmVjLnBfaW5zdGFuY2VfaWQpOw0KICBFTkQgTE9PUDsNCg0KICAtLSBjb21tZW50DQogIC0t IGNvbW1lbnQNCiAgLS0gY29tbWVudA0KICBVUERBVEUgd19pbnN0YW5jZXMgcGkNCiAgU0VUIGxh c3RfbW9kaWZpZWQgPSBOT1coKQ0KICBGUk9NIHVwZGF0ZWRfcG9zaXRpb25zIHVwIC0tIEVSUk9S IGxpbmUNCiAgV0hFUkUgcGkub2JqZWN0X2lkID0gdXAucF9pbnN0YW5jZV9pZDsNCg0KICBSRVRV Uk4gTlVMTDsNCkVORDsNCiQkOw0KYGBgDQoNClRoZSBvdGhlciBwYWlyIG9mIHRyaWdnZXJzIChu YW1lZCBgd2lwX3N0YXRzX2RlbGV0ZV90cmlnZ2VyYCBhbmQKYHdpcF9zdGF0c19kZWxldGVfdHJp Z2dlcmApIGFyZSBzaW1pbGFybHkgZGVmaW5lZCBhcyBBRlRFUiBTVEFURU1FTlQKdHJpZ2dlcnMg dGhhdCBjYWxsIGEgZnVuY3Rpb24gcGFzc2luZyB0aGUgdHJhbnNpdGlvbiB0YWJsZS4gVGhpcyBm dW5jdGlvbgoqb25seSogY29udGFpbnMgYSBgRk9SIHJlYyBJTiBTRUxFQ1QgLi4uIEZST00gdXBk YXRlZF9wb3NpdGlvbnNgIExPT1AuIA0KDQpJIGJlbGlldmUgdGhlIEpJVCB3YXMgb2ZmLg0KDQpJ IGFwb2xvZ2l6ZSBmb3IgdGhlIGRlYXJ0aCBvZiBpbmZvcm1hdGlvbiBJJ20gYWJsZSB0byBwcm92 aWRlIGFuZCBmb3IgdGhlCmxhY2sgb2YgYSBzaW1wbGUgcmVwcm9kdWNpYmxlIGV4YW1wbGU7IEkg a25vdyB0aGF0IG1ha2VzIGZvciBhbiBhbm5veWluZyBidWcKcmVwb3J0LiBJIGFsc28gYXBvbG9n aXplIGlmIG91ciBhcHAgaXMgZG9pbmcgc29tZXRoaW5nIHdyb25nIG9yIGlmIHRoaXMgaXMgYQpr bm93biBpc3N1ZSBvZiBzb21lIHNvcnQ7IEkgd2Fzbid0IGFibGUgdG8gZmluZCBhbnl0aGluZyBy ZWxhdGVkIG91dHNpZGUgdGhlClBvc3RncmVTUUwgc291cmNlIGNvZGUgaXRzZWxmLiBJJ20gaGFw cHkgdG8gdHJ5IHRvIHByb3ZpZGUgYW55IG90aGVyIGhlbHBmdWwKaW5mb3JtYXRpb24uDQoNClRo YW5rcywNCkphc29uCgo= --===============0304605394736144332==--