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 1rEpMU-007AQK-2r for pgsql-bugs@arkaria.postgresql.org; Sun, 17 Dec 2023 11:31:10 +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 1rEpMS-000Zhg-G3 for pgsql-bugs@arkaria.postgresql.org; Sun, 17 Dec 2023 11:31:08 +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 1rE9CK-002gaj-FX for pgsql-bugs@lists.postgresql.org; Fri, 15 Dec 2023 14:29:53 +0000 Received: from mx0b-000e5c14.pphosted.com ([148.163.137.209]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rE9CB-00C94X-DM for pgsql-bugs@lists.postgresql.org; Fri, 15 Dec 2023 14:29:50 +0000 Received: from pps.filterd (m0206229.ppops.net [127.0.0.1]) by mx0a-000e5c14.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 3BFCxclE029015; Fri, 15 Dec 2023 08:29:40 -0600 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=express-scripts.com; h=from : to : date : message-id : references : in-reply-to : content-type : content-transfer-encoding : mime-version : subject; s=pod140124231234; bh=SEYIPXb3yD8TjkisFAcAKgpKHcQ5ZAViqHiJLzrYkdI=; b=NzW+sITc+ebefr50OfrADq6dlSP8WdbOuG+5z6nJUFBSOJVk6pygBLW2oV3PuCzWeELf yKNT2vJs3KVsAjG0VY1SmwkaGi6dZVFjjDPn/PhbQP9cexQKGVrGcHgpcbx4bSRPNCmL uR6gjsvYhvAcgjxWW5PFm3VO0BHjRbGPl159qt+42nUVdjGL/nIFKiWUyyqJRj2d6Xa5 zXmy3GdKTb1kUiMlR9Kmg2e0sskQSaFmXWj0A13x5pG/VPnjnA+/JIEWmbD4QkLFJr/N CQOKXdUSAbfTO1a+P+UL0IWprkVXnVxAw59UvvVVOOEG2u30SYxn5zpAPbfjMYRlf5Hs 2g== Received: from eiaappxp0005.gid.prd.globalcore.com ([170.48.0.128]) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3v0376dywm-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Fri, 15 Dec 2023 08:29:40 -0600 Received: from cvlappxp20755.internal.cigna.com (HELO PS2PW1012185.accounts.root.corp) ([10.36.52.91]) by EIAAPPXP0005.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 15 Dec 2023 14:29:39 +0000 Received: from PS2PW1012186.accounts.root.corp (10.221.225.154) by PS2PW1012185.accounts.root.corp (10.221.225.153) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1258.27; Fri, 15 Dec 2023 09:29:38 -0500 Received: from PS2PW1012186.accounts.root.corp ([fe80::ddfb:faf8:59ca:a8ec]) by PS2PW1012186.accounts.root.corp ([fe80::ddfb:faf8:59ca:a8ec%6]) with mapi id 15.02.1258.027; Fri, 15 Dec 2023 09:29:38 -0500 From: "Wetmore, Matthew (CTR)" To: "wilma.wantren@web.de" , "pgsql-bugs@lists.postgresql.org" Thread-Topic: [EXTERNAL] BUG #18249: pg_dump/pg_restore single schema with function1 calling function2 Thread-Index: AQHaL0ykyHloNtk9uE6ACv0k3jCv8bCqZnkQ Date: Fri, 15 Dec 2023 14:29:38 +0000 Message-ID: <0d1acf9063604f36817072a226eb09aa@express-scripts.com> References: <18249-630edb096ed98a50@postgresql.org> In-Reply-To: <18249-630edb096ed98a50@postgresql.org> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.222.252.1] x-proofpoint-routing: 000e5c14 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-CFilter-Loop: Reflected Subject: BUG #18249: pg_dump/pg_restore single schema with function1 calling function2 X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.272,Aquarius:18.0.997,Hydra:6.0.619,FMLib:17.11.176.26 definitions=2023-12-15_08,2023-12-14_01,2023-05-22_02 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Tm90IHRvIGJlIHRyaXRlLCBidXQgc2NoZW1hIHF1YWxpZnlpbmcgeW91ciBmdW5jdGlvbi90YWJs ZXMgd291bGQgaGF2ZSBwcmV2ZW50ZWQgdGhpcy4NCg0KY3JlYXRlIG9yIHJlcGxhY2UgZnVuY3Rp b24gTVlTQ0hFTUEuZnVuY3Rpb24xKHN0ciB2YXJjaGFyKSByZXR1cm5zIHZhcmNoYXIgYXMgJCQg YmVnaW4gcmV0dXJuIHN0ciB8fCAnaGFsbG8nIHx8IGZ1bmN0aW9uMihzdHIpOyBlbmQ7ICQkIGxh bmd1YWdlIHBscGdzcWwgc3RyaWN0IGltbXV0YWJsZTsNCg0KcmVseWluZyBvbiBzZWFyY2hfcGF0 aCBpcyBhIGRhbmdlcm91cyBnYW1lcy4gIEJlIHNwZWNpZmljIGluIHlvdXIgU1FMIGFuZCB5b3Un bGwgZ2V0IGJldHRlciBsb25nIHRlcm0gcmVzdWx0cy4NCg0KVGhlbiBpZiB0aGUgc2NoZW1hIG5h bWUgY2hhbmdlcywgZXZlcnl0aGluZyBkb3duc3RyZWFtIGNoYW5nZXMgdG9vLiAgT3IgeW91IGNh biBlZGl0IHRoZSBkdW1wLnNxbA0KDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9t OiBQRyBCdWcgcmVwb3J0aW5nIGZvcm0gPG5vcmVwbHlAcG9zdGdyZXNxbC5vcmc+IA0KU2VudDog RnJpZGF5LCBEZWNlbWJlciAxNSwgMjAyMyAxOjA5IEFNDQpUbzogcGdzcWwtYnVnc0BsaXN0cy5w b3N0Z3Jlc3FsLm9yZw0KQ2M6IHdpbG1hLndhbnRyZW5Ad2ViLmRlDQpTdWJqZWN0OiBbRVhURVJO QUxdIEJVRyAjMTgyNDk6IHBnX2R1bXAvcGdfcmVzdG9yZSBzaW5nbGUgc2NoZW1hIHdpdGggZnVu Y3Rpb24xIGNhbGxpbmcgZnVuY3Rpb24yDQoNCg0KDQpUaGUgZm9sbG93aW5nIGJ1ZyBoYXMgYmVl biBsb2dnZWQgb24gdGhlIHdlYnNpdGU6DQoNCkJ1ZyByZWZlcmVuY2U6ICAgICAgMTgyNDkNCkxv Z2dlZCBieTogICAgICAgICAgV2lsbWEgV2FudHJlbg0KRW1haWwgYWRkcmVzczogICAgICB3aWxt YS53YW50cmVuQHdlYi5kZQ0KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMy40DQpPcGVyYXRpbmcgc3lz dGVtOiAgIEFsbA0KRGVzY3JpcHRpb246ICAgICAgICANCg0KVGhlIGNvbXBhbnkgSSB3b3JrIGZv ciB1c2VkIHRvIG9ubHkgdXNlIE9yYWNsZSBkYXRhYmFzZXMgZm9yIHRoZWlyIHByb2dyYW0gYW5k IG5vdyBhbHNvIHN1cHBvcnRzIFBvc3RncmVTUUwuDQpXaXRoIFBvc3RncmVzLCB3ZSBjcmVhdGUg YSBkYXRhYmFzZSwgYSB1c2VyIGFuZCBhIHNjaGVtYSwgd2hpY2ggYWxsIGhhdmUgdGhlIHNhbWUg bmFtZS4gVGhlIG5hbWUgaXMgY2hvc2VuIGJ5IHRoZSBjdXN0b21lcnMuDQpOZXZlcnRoZWxlc3Ms IHRoZSBjdXN0b21lcnMgd291bGQgbGlrZSB0byBleHBvcnQgdGhlIGRhdGEgYW5kIGRlZmluaXRp b25zIGFuZCBpbXBvcnQgdGhlbSB1bmRlciBhIG5ldyBuYW1lLg0KVGhpcyB3b3JrcyB3ZWxsIGJ5 IHVzaW5nIHRoZSAtTyAobm8gb3duZXIpIG9wdGlvbiBmb3IgcGdfZHVtcC9wZ19yZXN0b3JlIGFu ZCBvbmx5IGV4cG9ydGluZyBhbmQgaW1wb3J0aW5nIHRoZSBzY2hlbWEuIEFmdGVyIHRoZSBpbXBv cnQgdGhlIHNjaGVtYSBpcyByZW5hbWVkLiBTbyBmYXIgc28gc2ltcGxlIGFuZCBlYXN5IQ0KQnV0 IHRoZXJlIGlzIG9uZSBwcm9ibGVtOiB3ZSBoYXZlIGEgZGF0YWJhc2UgZnVuY3Rpb24gZnVuY3Rp b24xLCB3aGljaCBjYWxscyBhbm90aGVyIGZ1bmN0aW9uIGZ1bmN0aW9uMi4gVGhlIGNhbGwgaXMg bWFkZSB3aXRob3V0IGEgc2NoZW1hIHByZWZpeCBiZWNhdXNlIHRoZXNlIGFyZSBqdXN0IHR3byBm dW5jdGlvbnMgdGhhdCB3ZSBtYWtlIGF2YWlsYWJsZSB0byB0aGUgY3VzdG9tZXJzIGFuZCB3ZSBk b24ndCB0aGluayBhbiBleHRyYSBzY2hlbWEgZm9yIHRoZXNlIHR3byBmdW5jdGlvbnMgaXMgd29y dGh3aGlsZS4gSG93ZXZlciwNCmZ1bmN0aW9uMSBpcyB1c2VkIGluIGFuIGluZGV4IGFuZCB0aGUg cmVzdG9yZSBvZiB0aGUgaW5kZXggZmFpbHMgaWYgdGhlcmUgaXMgZGF0YSBpbiB0aGUgY29ycmVz cG9uZGluZyB0YWJsZSBjb2x1bW4uIFRoaXMgaXMgYmVjYXVzZSBwZ19kdW1wL3BnX3Jlc3RvcmUg c2V0IHRoZSBzZWFyY2hfcGF0aCB0byAnJyB3aGVuIHJlc3RvcmluZywgd2hpY2ggbWVhbnMgdGhh dCBmdW5jdGlvbjEgY2Fubm90IGZpbmQgdGhlIGZ1bmN0aW9uMi4NCklzIHRoZXJlIGFueSB3YXkg dG8gc29sdmUgdGhpcz8gSXQgaXMgbm90IGEgYmlnIHByb2JsZW0gYW5kIHdlIGNhbiB0ZWxsIHRo ZSBjdXN0b21lciB0byBpZ25vcmUgdGhlIGVycm9yIG1lc3NhZ2UgYW5kIHJlY3JlYXRlIHRoZSBp bmRpY2VzIGFmdGVyIHRoZSBpbXBvcnQsIGJ1dCBpdCB3b3VsZCBiZSBuaWNlciB3aXRob3V0IGFu IGVycm9yIG1lc3NhZ2UuDQoNCkhlcmUgYXJlIHRoZSBzdGVwcyB0byByZXByb2R1Y2U6DQpDb250 ZW50cyBvZiBmaWxlICJjcmVhdGVfZHVtcGVyLnNxbCI6DQpjcmVhdGUgdXNlciBkdW1wZXI7DQpj cmVhdGUgZGF0YWJhc2UgZHVtcGVyIG93bmVyIGR1bXBlcjsNCmFsdGVyIHVzZXIgZHVtcGVyIHNl dCBzZWFyY2hfcGF0aCB0byBkdW1wZXI7IFxjIGR1bXBlciBkdW1wZXI7IGNyZWF0ZSBzY2hlbWEg ZHVtcGVyOyBjcmVhdGUgb3IgcmVwbGFjZSBmdW5jdGlvbiBmdW5jdGlvbjIoc3RyIHZhcmNoYXIp IHJldHVybnMgdmFyY2hhciBhcyAkJCBiZWdpbiByZXR1cm4gc3RyIHx8IHN0cjsgZW5kOyAkJCBs YW5ndWFnZSBwbHBnc3FsIHN0cmljdCBpbW11dGFibGU7DQoNCmNyZWF0ZSBvciByZXBsYWNlIGZ1 bmN0aW9uIGZ1bmN0aW9uMShzdHIgdmFyY2hhcikgcmV0dXJucyB2YXJjaGFyIGFzICQkIGJlZ2lu IHJldHVybiBzdHIgfHwgJ2hhbGxvJyB8fCBmdW5jdGlvbjIoc3RyKTsgZW5kOyAkJCBsYW5ndWFn ZSBwbHBnc3FsIHN0cmljdCBpbW11dGFibGU7DQoNCmNyZWF0ZSB0YWJsZSB0YWJsZTEoc3RyIHZh cmNoYXIgbm90IG51bGwpOyBpbnNlcnQgaW50byB0YWJsZTEgdmFsdWVzKCd0ZXN0Jyk7IGNyZWF0 ZSBpbmRleCBpbmRleDEgb24gdGFibGUxKGZ1bmN0aW9uMShzdHIpKTsNCg0KQ2FsbCB3aXRoDQpw c3FsIC1mIGNyZWF0ZV9kdW1wZXIuc3FsDQoNCkV4cG9ydDoNCnBnX2R1bXAgLWggbG9jYWxob3N0 IC1wIDU0MzIgLVUgZHVtcGVyIC0tc2NoZW1hIGR1bXBlciAtTyAtZiBkdW1wZXIuc3FsDQoNCkNv bnRlbnRzIG9mIGZpbGUgImNyZWF0ZV9yZXN0b3Jlci5zcWwiOg0KY3JlYXRlIHVzZXIgcmVzdG9y ZXI7DQpjcmVhdGUgZGF0YWJhc2UgcmVzdG9yZXIgb3duZXIgcmVzdG9yZXI7DQoNCkNhbGwgd2l0 aDoNCnBzcWwgLWYgY3JlYXRlX3Jlc3RvcmVyLnNxbA0KDQpJbXBvcnQ6DQpwc3FsIHJlc3RvcmVy IHJlc3RvcmVyIC1mIGR1bXBlci5zcWwNCg0K