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 1rwGvV-000ggn-5T for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Apr 2024 07:38:53 +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 1rwGvT-00BFWZ-Tg for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Apr 2024 07:38:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rvoh9-0063AJ-3V for pgsql-bugs@lists.postgresql.org; Sun, 14 Apr 2024 01:30:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rvoh4-002jnj-NV for pgsql-bugs@lists.postgresql.org; Sun, 14 Apr 2024 01:30:09 +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=bPVmNb1tEs/b13N3gYgwHjR/YI7a6s9EFm3kt+OICx4=; b=xQuAR+ah6LEYzyTF6lY1xlQnL6 O8hQVA3fz9u4qo5Cqm6+gqh3ywDY2S8WXcrTMjhPph4VAAiEoCJ8qqv480pic0mGITFEpZ6H115f1 yCD0ofZS4WDOscmQy1jktDVRqZ6084e08GolZBcpFAKCTNN7B5iTwb5K5tgCsPN1FQqgsqTplyUDv x83JDKh4mdj4mFB0GY6dp/tYPO/h8D6IOKlvoZNfMa2JLXbTCZfK0ztQFYAMVc/r1LFnOH9WPhG8E rxCTJespoM2o6BJdl3nkYTyDb555ZvpSWalBTv369zEDMSFPccP0QtRNhJZC8CGn2uh1Iqb3drr5q Mwmm+9gg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rvoh3-006MRY-EN for pgsql-bugs@lists.postgresql.org; Sun, 14 Apr 2024 01:30:05 +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 1rvoh0-004Zg3-OZ for pgsql-bugs@lists.postgresql.org; Sun, 14 Apr 2024 01:30:03 +0000 Content-Type: multipart/mixed; boundary="===============0251253058504309548==" MIME-Version: 1.0 Subject: BUG #18432: Polymorphic, table-returning PL/pgSQL function fails with an erroneous "schema mismatch" error To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: narek@lantern.dev Reply-To: narek@lantern.dev, pgsql-bugs@lists.postgresql.org Date: Sun, 14 Apr 2024 01:29:35 +0000 Message-ID: <18432-62450522bb8f0754@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 --===============0251253058504309548== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQzMgpMb2dnZWQgYnk6ICAgICAgICAgIE5hcmVrIEdhbHN0eWFuCkVt YWlsIGFkZHJlc3M6ICAgICAgbmFyZWtAbGFudGVybi5kZXYKUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ni4yCk9wZXJhdGluZyBzeXN0ZW06ICAgTGludXggKHZpYSBvZmZpY2lhbCBkb2NrZXIgaW1hZ2Up CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSBhbGwsDQoNCkkgdGhpbmsgSSBhbSBydW5uaW5nIGlu dG8gc29tZSBraW5kIG9mIGNhdGFsb2cgY2FjaGUgaW52YWxpZGF0aW9uIGlzc3VlLg0KU2F5IEkg aGF2ZSBhIFBML3BnU1FMIGZ1bmN0aW9uIHRoYXQgdGFrZXMgaW4gYW4gYW55ZWxlbWVudCBwb2x5 bW9ycGhpYwphcmd1bWVudCBhbmQgdGhlIGFyZ3VtZW50IHJlc29sdmVzIGludG8gYSB0YWJsZSBv ZiBhcmJpdHJhcnkgc3RydWN0dXJlLg0KVGhlIGZ1bmN0aW9uIHJldHVybnMgYSB0YWJsZSB0eXBl IGFuZCByZXR1cm5zIGEgZmlsdGVyZWQgc3Vic2V0IG9mIHRoZQphcmd1bWVudCB0YWJsZS4NClRo ZSBmdW5jdGlvbiBkb2VzIG5vdCBkaXJlY3RseSBpbXBsZW1lbnQgdGhlIGxvZ2ljIGJ1dCBpbnN0 ZWFkIGNhbGxzIGFub3RoZXIKZnVuY3Rpb24uDQpXaGVuIEkgcnVuIEFMVEVSIFRBQkxFIG9uIHRo ZSB0YWJsZSBJIGhhdmUgY2FsbGVkIHRoZSBmdW5jdGlvbiB3aXRoLCB0aGUKZnVuY3Rpb24gc3Rv cHMgd29ya2luZyB1bnRpbCBzb21lIGtpbmQgb2YgZXZlbnQgKGUuZy4gY3JlYXRpbmcgYSBuZXcg c2NoZW1hCnRoYXQgaGFzIG5vIG92ZXJsYXAgd2l0aCB0aGUgZnVuY3Rpb24pDQoNClRvIHJlcHJv ZHVjZTogKHRlc3RlZCBvbiBwZzE1IGFuZCBwZzE2KQ0KDQpEUk9QIHNjaGVtYSBpZiBleGlzdHMg aXNzdWU0IGNhc2NhZGU7DQpDUkVBVEUgc2NoZW1hIGlzc3VlNDsNCg0KLS0gVGhlIG5leHQgdHdv IGZ1bmN0aW9ucyBkZWZpbmUgc29tZSBpbnRlcm5hbCB0YWJsZS1wb2xpbW9ycGhpYyBmdW5jdGlv biwKYW5kIHRoZSBwYWJsaWMgd3JhcHBlciBhcm91bmQgaXQNCg0KQ1JFQVRFIEZVTkNUSU9OIGlz c3VlNC5pZGVudGl0eV9pbnRlcm5hbCh0IGFueWVsZW1lbnQpIFJFVFVSTlMgVEFCTEUgKCJyb3ci CmFueWVsZW1lbnQpIEFTICQkDQpERUNMQVJFDQogIHF1ZXJ5X2Jhc2UgdGV4dDsNCkJFR0lODQog IHF1ZXJ5X2Jhc2UgOj0gZm9ybWF0KCdTRUxFQ1QgKiBGUk9NICVzICcsIHBnX3R5cGVvZih0KSk7 DQogIFJFVFVSTiBRVUVSWSBFWEVDVVRFIHF1ZXJ5X2Jhc2U7DQpFTkQgJCQgTEFOR1VBR0UgcGxw Z3NxbDsNCg0KQ1JFQVRFIEZVTkNUSU9OIGlzc3VlNC5pZGVudGl0eSh0IGFueWVsZW1lbnQpIFJF VFVSTlMgVEFCTEUgKCJyb3ciCmFueWVsZW1lbnQpIEFTICQkDQpERUNMQVJFDQogIHF1ZXJ5X2Jh c2UgdGV4dDsNCkJFR0lODQogIHF1ZXJ5X2Jhc2UgOj0gZm9ybWF0KCdTRUxFQ1QgKiBGUk9NICVz ICcsIHBnX3R5cGVvZih0KSk7DQogIFJFVFVSTiBRVUVSWSBTRUxFQ1QgKiBGUk9NIGlzc3VlNC5p ZGVudGl0eV9pbnRlcm5hbCh0KTsNCkVORCAkJCBMQU5HVUFHRSBwbHBnc3FsOw0KDQotLSBDcmVh dGUgdGFibGVzIHRvIGNhbGwgdGhlIHRhYmxlLXBvbGltb3JwaGljIGZ1bmN0aW9uIG9uDQpDUkVB VEUgVEFCTEUgaXNzdWU0LnRlc3RfdGFibGUoaWQgU0VSSUFMIFBSSU1BUlkgS0VZLCB2ZWMgcmVh bFtdKTsNCklOU0VSVCBJTlRPIGlzc3VlNC50ZXN0X3RhYmxlKHZlYykgVkFMVUVTICgnezEsMiwz fScpLCAoJ3s0LDUsNn0nKSwKKCd7Nyw4LDl9Jyk7DQotLSB0aGUgaXNzdWUgaXMgbm90IHRyaWdn ZXJlZCB3aGVuIHRoZSB0YWJsZSBpcyBtb2RpZmllZCBiZWZvcmUgdGhlIGZpcnN0Cmludm9jYXRp b24gb2YgdGhlIGZ1bmN0aW9uDQotLSBUaGUgbGluZSBiZWxvdyBkZW1vc250cmF0ZXMgdGhhdCB0 aGVyZSBpcyBubyBpc3N1ZSBjYWxsaW5nIHRoZQpwb2x5bW9ycGhpYyBmdW5jdGlvbnMgYWZ0ZXIg YW4gQUxURVIgVEFCTEUNCi0tIGlmIHRoZXJlIHdlcmUgbm8gcHJpb3IgY2FsbHMgdG8gdGhlIGZ1 bmN0aW9uDQpBTFRFUiBUQUJMRSBpc3N1ZTQudGVzdF90YWJsZSBBREQgQ09MVU1OIHZlYzIzIHJl YWxbXTsNCg0KLS0gc3VjY2VlZHMhDQpTRUxFQ1QgKiBGUk9NIGlzc3VlNC5pZGVudGl0eShDQVNU KE5VTEwgYXMgImlzc3VlNCIuInRlc3RfdGFibGUiKSk7DQoNClxlY2hvIC0tLS0tLS0tLS0tLS0t LS0tLS0tLSBDT1JFIE9GIFRIRSBJU1NVRQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0NCi0tIE5vdywgbGV0J3MgbW9kaWZ5IHRoZSAyLWNvbHVtbiB0YWJsZSwgYW5k ZCBhZGQgYSBjb2x1bW4gdG8gaXQgYWZ0ZXIgdGhlCmZ1bmN0aW9uIHdhcyBjYWxsZWQNCkFMVEVS IFRBQkxFIGlzc3VlNC50ZXN0X3RhYmxlIEFERCBDT0xVTU4gdmVjMiByZWFsW107DQpVUERBVEUg aXNzdWU0LnRlc3RfdGFibGUgU0VUIHZlYzIgPSB2ZWM7DQpcc2V0IE9OX0VSUk9SX1NUT1Agb2Zm DQotLSB0aGlzIGZhaWxzIHdpdGg6DQotLSAgICAgcHNxbDouLi9wZ19hbnllbGVtZW50X2lzc3Vl LnNxbDozNDogRVJST1I6ICBzdHJ1Y3R1cmUgb2YgcXVlcnkgZG9lcwpub3QgbWF0Y2ggZnVuY3Rp b24gcmVzdWx0IHR5cGUNCi0tICAgICBERVRBSUw6ICBOdW1iZXIgb2YgcmV0dXJuZWQgY29sdW1u cyAoMykgZG9lcyBub3QgbWF0Y2ggZXhwZWN0ZWQKY29sdW1uIGNvdW50ICg0KS4NCi0tICAgICBD T05URVhUOiAgU1FMIHN0YXRlbWVudCAiU0VMRUNUICogRlJPTSBpc3N1ZTQuaWRlbnRpdHlfaW50 ZXJuYWwodCkiDQotLSAgICAgUEwvcGdTUUwgZnVuY3Rpb24gaXNzdWU0LmlkZW50aXR5KGFueWVs ZW1lbnQpIGxpbmUgNiBhdCBSRVRVUk4KUVVFUlkNClNFTEVDVCAqIEZST00gaXNzdWU0LmlkZW50 aXR5KENBU1QoTlVMTCBhcyAiaXNzdWU0Ii4idGVzdF90YWJsZSIpKTsNClxzZXQgT05fRVJST1Jf U1RPUCBvbg0KXGVjaG8gXl5eXl5eXl5eXl5eXl5eXl5eXl5eIENPUkUgT0YgVEhFIElTU1VFCl5e Xl5eXl5eXl5eXl5eXl5eXl5eXl5eXl5eXl5eXl5eXl5eXl5eXl4NCkNSRUFURSBTQ0hFTUEgaXNz dWU0X2R1bW15Ow0KRFJPUCBTQ0hFTUEgaXNzdWU0X2R1bW15Ow0KDQotLSBUaGlzIChFWEFDVCBT QU1FIFFVRVJZIEFTIEFCT1ZFKSBub3cgc3VjY2VlZHMhPyBhZnRlciBjcmVhdGluZyBhbmQKZHJv cHBpbmcgYSBzY2hlbWENClNFTEVDVCAqIEZST00gaXNzdWU0LmlkZW50aXR5KENBU1QoTlVMTCBh cyAiaXNzdWU0Ii4idGVzdF90YWJsZSIpKTsNCg0KLS0gY2xlYW51cA0KRFJPUCBTQ0hFTUEgaXNz dWU0IENBU0NBREU7Cgo= --===============0251253058504309548==--