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 1iZLTp-0004rW-NL for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Nov 2019 21:01:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iZLTo-0004K9-CG for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Nov 2019 21:01: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 1iZLTo-0004K2-4Y for pgsql-bugs@lists.postgresql.org; Mon, 25 Nov 2019 21:01:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iZLTl-0006qj-Fa for pgsql-bugs@lists.postgresql.org; Mon, 25 Nov 2019 21:01:07 +0000 Content-Type: multipart/mixed; boundary="===============8120472757782755683==" MIME-Version: 1.0 Subject: BUG #16137: pg_upgrade fails with an index over nesting function To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 25 Nov 2019 21:00:07 +0000 Message-ID: <16137-4917a81e8491110e@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8120472757782755683== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjEzNwpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTIuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAxOC4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyBzaW1wbGUgc2NyaXB0Og0KQ1JFQVRFIFRBQkxFIHRlc3QoaSBJ TlQgUFJJTUFSWSBLRVkpOw0KQ1JFQVRFIEZVTkNUSU9OIGZ1bmMyKGkgSU5UKSBSRVRVUk5TIElO VCBJTU1VVEFCTEUgTEFOR1VBR0UgU1FMDQogICAgQVMgJ1NFTEVDVCAkMSc7DQpDUkVBVEUgRlVO Q1RJT04gZnVuYzEoYyBJTlQpIFJFVFVSTlMgSU5UIElNTVVUQUJMRSBMQU5HVUFHRSBTUUwNCiAg ICBBUyAnU0VMRUNUIGZ1bmMyKCQxKSc7DQpDUkVBVEUgSU5ERVggT04gdGVzdChmdW5jMShpKSk7 DQoNCm1ha2VzIHBnX3VwZ3JhZGUgY2hva2Ugb24gdGhlIGRhdGFiYXNlOg0KLi4uDQpQZXJmb3Jt aW5nIFVwZ3JhZGUNCi0tLS0tLS0tLS0tLS0tLS0tLQ0KQW5hbHl6aW5nIGFsbCByb3dzIGluIHRo ZSBuZXcgY2x1c3RlciAgICAgICAgICAgICAgICAgICAgICAgb2sNCkZyZWV6aW5nIGFsbCByb3dz IGluIHRoZSBuZXcgY2x1c3RlciAgICAgICAgICAgICAgICAgICAgICAgIG9rDQpEZWxldGluZyBm aWxlcyBmcm9tIG5ldyBwZ194YWN0ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBvaw0KQ29w eWluZyBvbGQgcGdfeGFjdCB0byBuZXcgc2VydmVyICAgICAgICAgICAgICAgICAgICAgICAgICAg b2sNClNldHRpbmcgbmV4dCB0cmFuc2FjdGlvbiBJRCBhbmQgZXBvY2ggZm9yIG5ldyBjbHVzdGVy ICAgICAgIG9rDQpEZWxldGluZyBmaWxlcyBmcm9tIG5ldyBwZ19tdWx0aXhhY3Qvb2Zmc2V0cyAg ICAgICAgICAgICAgICBvaw0KQ29weWluZyBvbGQgcGdfbXVsdGl4YWN0L29mZnNldHMgdG8gbmV3 IHNlcnZlciAgICAgICAgICAgICAgb2sNCkRlbGV0aW5nIGZpbGVzIGZyb20gbmV3IHBnX211bHRp eGFjdC9tZW1iZXJzICAgICAgICAgICAgICAgIG9rDQpDb3B5aW5nIG9sZCBwZ19tdWx0aXhhY3Qv bWVtYmVycyB0byBuZXcgc2VydmVyICAgICAgICAgICAgICBvaw0KU2V0dGluZyBuZXh0IG11bHRp eGFjdCBJRCBhbmQgb2Zmc2V0IGZvciBuZXcgY2x1c3RlciAgICAgICAgb2sNClJlc2V0dGluZyBX QUwgYXJjaGl2ZXMgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIG9rDQpTZXR0 aW5nIGZyb3plbnhpZCBhbmQgbWlubXhpZCBjb3VudGVycyBpbiBuZXcgY2x1c3RlciAgICAgICBv aw0KUmVzdG9yaW5nIGdsb2JhbCBvYmplY3RzIGluIHRoZSBuZXcgY2x1c3RlciAgICAgICAgICAg ICAgICAgb2sNClJlc3RvcmluZyBkYXRhYmFzZSBzY2hlbWFzIGluIHRoZSBuZXcgY2x1c3Rlcg0K ICBwb3N0Z3JlcyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgDQoqZmFpbHVyZSoNCg0KQ29uc3VsdCB0aGUgbGFzdCBmZXcgbGluZXMgb2YgInBnX3VwZ3Jh ZGVfZHVtcF8xMjcxNy5sb2ciIGZvcg0KdGhlIHByb2JhYmxlIGNhdXNlIG9mIHRoZSBmYWlsdXJl Lg0KRmFpbHVyZSwgZXhpdGluZw0KDQpwZ191cGdyYWRlX2R1bXBfMTI3MTcubG9nIGNvbnRhaW5z Og0KLi4uDQpwZ19yZXN0b3JlOiBjcmVhdGluZyBJTkRFWCAicHVibGljLnRlc3RfZnVuYzFfaWR4 Ig0KcGdfcmVzdG9yZTogd2hpbGUgUFJPQ0VTU0lORyBUT0M6DQpwZ19yZXN0b3JlOiBmcm9tIFRP QyBlbnRyeSAyMDg5OyAxMjU5IDE2MzkxIElOREVYIHRlc3RfZnVuYzFfaWR4IHBvc3RncmVzDQpw Z19yZXN0b3JlOiBlcnJvcjogY291bGQgbm90IGV4ZWN1dGUgcXVlcnk6IEVSUk9SOiAgZnVuY3Rp b24gZnVuYzIoaW50ZWdlcikKZG9lcyBub3QgZXhpc3QNCkxJTkUgMTogU0VMRUNUIGZ1bmMyKCQx KQ0KICAgICAgICAgICAgICAgXg0KSElOVDogIE5vIGZ1bmN0aW9uIG1hdGNoZXMgdGhlIGdpdmVu IG5hbWUgYW5kIGFyZ3VtZW50IHR5cGVzLiBZb3UgbWlnaHQgbmVlZAp0byBhZGQgZXhwbGljaXQg dHlwZSBjYXN0cy4NClFVRVJZOiAgU0VMRUNUIGZ1bmMyKCQxKQ0KQ09OVEVYVDogIFNRTCBmdW5j dGlvbiAiZnVuYzEiIGR1cmluZyBpbmxpbmluZw0KQ29tbWFuZCB3YXM6IA0KLS0gRm9yIGJpbmFy eSB1cGdyYWRlLCBtdXN0IHByZXNlcnZlIHBnX2NsYXNzIG9pZHMNClNFTEVDVApwZ19jYXRhbG9n LmJpbmFyeV91cGdyYWRlX3NldF9uZXh0X2luZGV4X3BnX2NsYXNzX29pZCgnMTYzOTEnOjpwZ19j YXRhbG9nLm9pZCk7DQoNCkNSRUFURSBJTkRFWCAidGVzdF9mdW5jMV9pZHgiIE9OICJwdWJsaWMi LiJ0ZXN0IiBVU0lORyAiYnRyZWUiCigicHVibGljIi4iZnVuYzEiKCJpIikpOwoK --===============8120472757782755683==--