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 1hnRac-0006QQ-1e for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Jul 2019 17:50:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hnRaa-0005q7-FX for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Jul 2019 17:50:08 +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 1hnRaa-0005q0-83 for pgsql-bugs@lists.postgresql.org; Tue, 16 Jul 2019 17:50:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hnRaX-0006QZ-1R for pgsql-bugs@lists.postgresql.org; Tue, 16 Jul 2019 17:50:07 +0000 Content-Type: multipart/mixed; boundary="===============6508358834530880722==" MIME-Version: 1.0 Subject: BUG #15913: Could not open relation with oid on PL/pgSQL method referencing temporary table that got recreated To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zeroimpl@gmail.com Reply-To: zeroimpl@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 16 Jul 2019 17:49:14 +0000 Message-ID: <15913-a7e112e16dedcffc@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6508358834530880722== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTkxMwpMb2dnZWQgYnk6ICAgICAgICAgIERhbmllbCBGaW9yaQpFbWFp bCBhZGRyZXNzOiAgICAgIHplcm9pbXBsQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEx LjQKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gMTEuNC0xLnBnZGc5MCsxCkRlc2NyaXB0aW9u OiAgICAgICAgCgpJIGhhdmUgc29tZSBTUUwgd2hpY2ggd29ya3MgZmluZSBpbiA5LnggYW5kIDEw LngsIGJ1dCBmYWlscyBpbiAxMS54IGFuZCAxMi54CihJIHRlc3RlZCBvbiB2YXJpb3VzIERvY2tl ciBpbWFnZXMpLg0KDQpPbmUgb2YgdGhlIGZ1bmN0aW9ucyBkZWNsYXJlcyBhIHZhcmlhYmxlIHdo b3NlIHR5cGUgbWF0Y2hlcyBhIHRlbXBvcmFyeQp0YWJsZS4gSWYgSSBkcm9wIGFuZCByZWNyZWF0 ZSB0aGF0IHRlbXBvcmFyeSB0YWJsZSB0d2ljZSBpbiB0aGUgc2FtZQpzZXNzaW9uLCBJIGdldCBh biBlcnJvciBsaWtlOiAiRVJST1I6ICBjb3VsZCBub3Qgb3BlbiByZWxhdGlvbiB3aXRoIE9JRAp4 eHgiLiBUaGlzIG9jY3VycyBvbiB0aGUgc2Vjb25kIGNhbGwgdG8gdGhlIERvU29tZXRoaW5nKCkg ZnVuY3Rpb24gYWZ0ZXIgdGhlCnRlbXBvcmFyeSB0YWJsZSBoYXMgYmVlbiByZWNyZWF0ZWQuIA0K DQotLS0NCg0KQkVHSU47DQoNCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIEJlZ2luVGVzdCgg YXJnIFRFWFQgKSBSRVRVUk5TIFZPSUQgQVMgJCQNCkJFR0lODQogICAgQ1JFQVRFIFRFTVBPUkFS WSBUQUJMRSBUZXN0VmFsIEFTIFNFTEVDVCBhcmc7DQpFTkQNCiQkIExBTkdVQUdFIFBMUEdTUUw7 DQoNClNFTEVDVCBCZWdpblRlc3QoIE5VTEwgKTsNCg0KQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJ T04gRW5kVGVzdCgpIFJFVFVSTlMgVk9JRCBBUyAkJA0KQkVHSU4NCiAgICBEUk9QIFRBQkxFIFRl c3RWYWw7DQpFTkQNCiQkIExBTkdVQUdFIFBMUEdTUUw7DQoNCkNSRUFURSBPUiBSRVBMQUNFIEZV TkNUSU9OIERvU29tZXRoaW5nKCkgUkVUVVJOUyBWT0lEIEFTICQkDQpERUNMQVJFDQogICAgdmFy bmFtZSBUZXN0VmFsOw0KQkVHSU4NCiAgICBTRUxFQ1QgKiBJTlRPIHZhcm5hbWUgRlJPTSBUZXN0 VmFsOw0KRU5EDQokJCBMQU5HVUFHRSBQTFBHU1FMOw0KDQpTRUxFQ1QgRW5kVGVzdCgpOw0KDQpD T01NSVQ7DQoNCi0tLQ0KDQpUaGVuIGluIGEgZGlmZmVyZW50IHNlc3Npb24gcnVuOg0KLS0tDQoN CkJFR0lOOw0KDQpTRUxFQ1QgQmVnaW5UZXN0KCAnYWJjJyApOw0KU0VMRUNUIERvU29tZXRoaW5n KCk7DQpTRUxFQ1QgRW5kVGVzdCgpOw0KDQpTRUxFQ1QgQmVnaW5UZXN0KCAnZGVmJyApOw0KU0VM RUNUIERvU29tZXRoaW5nKCk7DQpTRUxFQ1QgRW5kVGVzdCgpOw0KDQpDT01NSVQ7DQoNCi0tLQ0K DQpOb3RlIGlmIHRoZSBhYm92ZSBTUUwgaXMgYWxsIHJ1biBpbiB0aGUgc2FtZSBzZXNzaW9uLCBh IHNsaWdodGx5IGRpZmZlcmVudAplcnJvciBpcyByZXBvcnRlZDogIkVSUk9SOiAgdHlwZSB3aXRo IE9JRCB4eHggZG9lcyBub3QgZXhpc3QiDQoNCkJhc2VkIG9uIHRoZSBQRyAxMSByZWxlYXNlIG5v dGVzLCBpdCBzb3VuZHMgbGlrZSBpdCdzIHJlbGF0ZWQgdG8gdGhpcwpjaGFuZ2U6DQoNCj4gQWxs b3cgUEwvcGdTUUwgdG8gaGFuZGxlIGNoYW5nZXMgdG8gY29tcG9zaXRlIHR5cGVzIChlLmcuIHJl Y29yZCwgcm93KQp0aGF0IGhhcHBlbiBiZXR3ZWVuIHRoZSBmaXJzdCBhbmQgbGF0ZXIgZnVuY3Rp b24gZXhlY3V0aW9ucyBpbiB0aGUgc2FtZQpzZXNzaW9uIChUb20gTGFuZSkuIFByZXZpb3VzbHks IHN1Y2ggY2lyY3Vtc3RhbmNlcyBnZW5lcmF0ZWQgZXJyb3JzLgoK --===============6508358834530880722==--