Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPCYz-009wAr-Te for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Jan 2024 02:18:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rPCYx-00DAI8-1u for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Jan 2024 02:18:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rP5Xn-00CTOi-4a for pgsql-bugs@lists.postgresql.org; Sun, 14 Jan 2024 18:49:15 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rP5Xe-001lO7-TQ for pgsql-bugs@lists.postgresql.org; Sun, 14 Jan 2024 18:49:14 +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=XD2OvgV74HBuJMPt/YFrx3McckgrAGrZu8I4lL8OcAg=; b=qdPjxLaxeajcjDO+RFBc6W7VT6 G+AUzkMw+GeeWkN3RdzdIhXKxfJOL+HQ6wfGzMwvqGZNNlO6qqili0Bj1G+9d3jMpeqV3jxWYtZil oZHwWntGBPII63odK7eNkvaBBs4CUmpzGYICk3Tv2m3cj3PIvePXnhJugmH82PhVKTcqcikqcJFP/ QBTddEXdeP42ifpHNXg77f1hVzIA617VA3FuLVGE1SebhaSlK+/3SzTcj1/hcbG1JrJ44+jsWGIim e6sr6S7liUMjtF+3x7JGT439oZtdr76t1ZCeKm4KvsaxX3PYnzUGWorYJks/ZK1bebgdY1Vc+Avhm vsnKJ2WQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rP5Xa-004drR-V4 for pgsql-bugs@lists.postgresql.org; Sun, 14 Jan 2024 18:49:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rP5Xa-00BsOM-1h for pgsql-bugs@lists.postgresql.org; Sun, 14 Jan 2024 18:49:02 +0000 Content-Type: multipart/mixed; boundary="===============5055426215247287948==" MIME-Version: 1.0 Subject: BUG #18292: Unexpected error: "relation "hobbies_r" does not exist" caused by user-defined functions To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zuming.jiang@inf.ethz.ch Reply-To: zuming.jiang@inf.ethz.ch, pgsql-bugs@lists.postgresql.org Date: Sun, 14 Jan 2024 18:48:13 +0000 Message-ID: <18292-55856fb8254c79d6@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 --===============5055426215247287948== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI5MgpMb2dnZWQgYnk6ICAgICAgICAgIFp1bWluZyBKaWFuZwpFbWFp bCBhZGRyZXNzOiAgICAgIHp1bWluZy5qaWFuZ0BpbmYuZXRoei5jaApQb3N0Z3JlU1FMIHZlcnNp b246IDE2LjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCk15IGZ1enplciBmaW5kcyBhIHN1c3BpY2lvdXMgYWxhcm0gaW4gUG9zdGdyZXMgMTdk ZXZlbDogIkVSUk9SOiAgcmVsYXRpb24KImhvYmJpZXNfciIgZG9lcyBub3QgZXhpc3QiLiBJIHJl cG9ydCBpdCBhcyBJIHRoaW5rIGl0IG1pZ2h0IGJlIGFuCnVuZXhwZWN0ZWQgZXJyb3IuDQoNCi0t LSBTZXQgdXAgZGF0YWJhc2UgLS0tDQpjcmVhdGUgdGFibGUgZXhlZXRfdDIgKHZrZXkgaW50NCk7 DQppbnNlcnQgaW50byBleGVldF90MiB2YWx1ZXMgKDUpOw0KDQpDUkVBVEUgVEFCTEUgcGVyc29u IChuYW1lIHRleHQpOw0KaW5zZXJ0IGludG8gcGVyc29uIHZhbHVlcyAoJ21pa2UnKTsNCkNSRUFU RSBUQUJMRSBob2JiaWVzX3IgKG5hbWUgdGV4dCwgcGVyc29uIHRleHQpOw0KQ1JFQVRFIFRBQkxF IGVxdWlwbWVudF9yIChuYW1lIHRleHQsIGhvYmJ5IHRleHQpOw0KSU5TRVJUIElOVE8gaG9iYmll c19yIChuYW1lLCBwZXJzb24pDQogICBTRUxFQ1QgJ3Bvc3RoYWNraW5nJywgcC5uYW1lDQogICBG Uk9NIHBlcnNvbiogcDsNCklOU0VSVCBJTlRPIGVxdWlwbWVudF9yIChuYW1lLCBob2JieSkgVkFM VUVTICgnYWR2aWwnLCAncG9zdGhhY2tpbmcnKTsNCkNSRUFURSBGVU5DVElPTiBob2JiaWVzKHBl cnNvbikNCiAgIFJFVFVSTlMgc2V0b2YgaG9iYmllc19yDQogICBBUyAnc2VsZWN0ICogZnJvbSBo b2JiaWVzX3Igd2hlcmUgcGVyc29uID0gJDEubmFtZScNCiAgIExBTkdVQUdFIFNRTDsNCkNSRUFU RSBGVU5DVElPTiBlcXVpcG1lbnQoaG9iYmllc19yKQ0KICAgUkVUVVJOUyBzZXRvZiBlcXVpcG1l bnRfcg0KICAgQVMgJ3NlbGVjdCAqIGZyb20gZXF1aXBtZW50X3Igd2hlcmUgaG9iYnkgPSAkMS5u YW1lJw0KICAgTEFOR1VBR0UgU1FMOw0KDQpjcmVhdGUgc2NoZW1hIHNpbXBsZTE7DQpjcmVhdGUg ZnVuY3Rpb24gc2ltcGxlMS5zaW1wbGV0YXJnZXQoaW50KSByZXR1cm5zIGludCBsYW5ndWFnZSBw bHBnc3FsDQphcyAkJGJlZ2luIHJldHVybiAkMTtlbmQkJDsNCmNyZWF0ZSBmdW5jdGlvbiBzaW1w bGV0YXJnZXQoaW50KSByZXR1cm5zIGludCBsYW5ndWFnZSBwbHBnc3FsDQphcyAkJGJlZ2luIHJl dHVybiAkMSArIDEwMDtlbmQkJDsNCmNyZWF0ZSBvciByZXBsYWNlIGZ1bmN0aW9uIHNpbXBsZWNh bGxlcigpIHJldHVybnMgaW50IGxhbmd1YWdlIHBscGdzcWwNCmFzICQkDQpkZWNsYXJlDQogIHN1 bSBpbnQgOj0gMDtiZWdpbg0KICBmb3IgbiBpbiAxLi4xMCBsb29wDQogICAgc3VtIDo9IHN1bSAr IHNpbXBsZXRhcmdldChuKTtpZiBuID0gNSB0aGVuDQogICAgICBzZXQgbG9jYWwgc2VhcmNoX3Bh dGggPSAnc2ltcGxlMSc7ZW5kIGlmO2VuZCBsb29wO3JldHVybiBzdW07ZW5kJCQ7DQoNClRoZSBm dXp6ZXIgZ2VuZXJhdGVzIGEgdGVzdCBjYXNlOg0KDQotLS0gVGVzdCBjYXNlIC0tLQ0Kc2VsZWN0 ICANCiAgKFNFTEVDVCAocC5ob2JiaWVzKS5lcXVpcG1lbnQubmFtZSBGUk9NIE9OTFkgcGVyc29u IHAgb3JkZXIgYnkgMSBsaW1pdCAxKQphcyBjXzExDQpmcm9tIA0KICAoc2VsZWN0ICANCiAgICAg IDEgYXMgY18wDQogICAgZnJvbSANCiAgICAgIGV4ZWV0X3QyIGFzIHJlZl8wDQogICAgd2hlcmUg JzU1NScgPSAoKHNlbGVjdCBjYXN0KHNpbXBsZWNhbGxlcigpIGFzIHRleHQpKSkpIGFzIHN1YnFf MDsNCg0KLS0tIEV4cGVjdGVkIGJlaGF2aW9yIC0tLQ0KVGhlIHRlc3QgY2FzZSBzaG91bGQgbm90 IHRyaWdnZXIgYW55IGVycm9yLg0KDQotLS0gQWN0dWFsIGJlaGF2aW9yIC0tLQ0KVGhlIHRlc3Qg Y2FzZSB0cmlnZ2VyIGFuIGVycm9yOiANCg0KRVJST1I6ICByZWxhdGlvbiAiaG9iYmllc19yIiBk b2VzIG5vdCBleGlzdA0KDQotLS0gUG9zdGdyZXMgdmVyc2lvbiAtLS0NCkdpdGh1YiBjb21taXQ6 IDE1MjM1YWJiZjM0ZjZiMjQ2Zjc2ODFlODhkY2NmOGMyNzk2YTI0NWINClZlcnNpb246IFBvc3Rn cmVTUUwgMTdkZXZlbCBvbiB4ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxlZCBieSBnY2MgKFVi dW50dQo5LjQuMC0xdWJ1bnR1MX4yMC4wNC4yKSA5LjQuMCwgNjQtYml0DQoNCi0tLSBQbGF0Zm9y bSBpbmZvcm1hdGlvbiAtLS0NClBsYXRmb3JtOiBVYnVudHUgMjAuMDQNCktlcm5lbDogTGludXgg NS40LjAtMTQ3LWdlbmVyaWMNCg0KLS0tIE5vdGUgLS0tDQpUaGUgZm9sbG93aW5nIHF1ZXJ5IGNh biBiZSBzdWNjZXNzZnVsbHkgZXhlY3V0ZWQ6DQoNCnNlbGVjdCAgDQogIChzZWxlY3QgbmFtZSBm cm9tIGhvYmJpZXNfciBvcmRlciBieSAxIGxpbWl0IDEpIGFzIGNfMTENCmZyb20gDQogIChzZWxl Y3QgIA0KICAgICAgMSBhcyBjXzANCiAgICBmcm9tIA0KICAgICAgZXhlZXRfdDIgYXMgcmVmXzAN CiAgICB3aGVyZSAnNTU1JyA9ICgoc2VsZWN0IGNhc3Qoc2ltcGxlY2FsbGVyKCkgYXMgdGV4dCkp KSkgYXMgc3VicV8wOyAgLS0tCnJldHVybiB7J3Bvc3RoYWNraW5nJ30KCg== --===============5055426215247287948==--