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 1tD33v-00FRQP-IJ for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Nov 2024 14:49:11 +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 1tD33s-005StX-Ou for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Nov 2024 14:49:09 +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 1tD1yD-00568m-IC for pgsql-bugs@lists.postgresql.org; Mon, 18 Nov 2024 13:39:14 +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 1tD1y5-002Zun-7i for pgsql-bugs@lists.postgresql.org; Mon, 18 Nov 2024 13:39:13 +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=W+HndcFNB2KDvvz6R56lH5Yt66/bPPBxP32vW/YFiaw=; b=5jKdyZRYXNf8GuXRenbl4WbVCJ 8crI32bdIzrD4SCzGABNqO+9il4LYeAZT07m4Vvp4RYPTEo26nlfciTSAdWRI/u2RvPT6/pZFQoOR FoAxlZuBwfQJh1tU95ztMx4NvtWL9Z97Wd8BL95fZ0e8KSH+4A1w0VpnjYs80zkzjPbNc/Vo/Uhl7 ZEz3eqNS8eM+5hzq/y5Vm5/dHZzI1scngCHOlkCZU9ogtgdY9lmXsFTgGQZvhOCsDfDFm4bOJIjDk qlSYvOW/X/nnhtDlDAkIYs8QoF7Hh9gYgppG6zmJaujINwCAGJs+mwce2VuLwRcS6zLliebWh+6TV k4kylc2A==; 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 1tD1y4-007sjP-IB for pgsql-bugs@lists.postgresql.org; Mon, 18 Nov 2024 13:39: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 1tD1y2-006pq6-60 for pgsql-bugs@lists.postgresql.org; Mon, 18 Nov 2024 13:39:03 +0000 Content-Type: multipart/mixed; boundary="===============0136205092548507819==" MIME-Version: 1.0 Subject: BUG #18713: pg_upgrade fails when owner of an extension is changed or dropped To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mittalhanumant@gmail.com Reply-To: mittalhanumant@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 18 Nov 2024 13:38:30 +0000 Message-ID: <18713-21afc479c25cce4b@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 --===============0136205092548507819== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODcxMwpMb2dnZWQgYnk6ICAgICAgICAgIEhhbnVtYW50IE1pdHRhbApF bWFpbCBhZGRyZXNzOiAgICAgIG1pdHRhbGhhbnVtYW50QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZl cnNpb246IDE1LjQKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gR05VL0xpbnV4IHJvZGV0ZQpE ZXNjcmlwdGlvbjogICAgICAgIAoKcGdfdXBncmFkZSBmcm9tIHBnMTQgdG8gcGcxNSBmYWlscyB3 aXRoIGVycm9yIG9mIHRoaXMga2luZDoNCmBgYA0KcGdfcmVzdG9yZTogZnJvbSBUT0MgZW50cnkg Mzk5OTsgMCAwIEFDTCBGVU5DVElPTgoicGdfc3RhdF9zdGF0ZW1lbnRzX3Jlc2V0IigidXNlcmlk IiAib2lkIiwgImRiaWQiICJvaWQiLCAicXVlcnlpZCIgYmlnaW50KQpuZXd1c2VyDQpwZ19yZXN0 b3JlOiBlcnJvcjogY291bGQgbm90IGV4ZWN1dGUgcXVlcnk6IEVSUk9SOiAgcm9sZSAiMTYzODQi IGRvZXMgbm90CmV4aXN0DQpgYGANCg0KQ29uZGl0aW9uIHRoYXQgc2VlbXMgdG8gYmUgdHJpZ2dl cmluZyB0aGlzIGlzIGlmIHdlIGNyZWF0ZSBhbiBleHRlbnNpb24gd2l0aApvbmUgdXNlciAoZS5n LiBvbGR1c2VyKSwgcmVhc3NpZ25lZCB0byBhbm90aGVyIHVzZXIgKGUuZy4gbmV3dXNlcikgYW5k IGRyb3AKdGhlIG9sZHVzZXIuIFBvc3QgdGhhdCBpZiB3ZSB0cmlnZ2VyIHBnX3VwZ3JhZGUgaXQg ZmFpbHMuDQoNClN0ZXBzIHRvIHJlcHJvZHVjZToNCiMgU2V0dXAgcGcxNA0KL3Vzci9saWIvcG9z dGdyZXNxbC8xNC9iaW4vaW5pdGRiIC0tbG9jYWxlPUMuVVRGLTggL3RtcC9kYXRhLTE0DQovdXNy L2xpYi9wb3N0Z3Jlc3FsLzE0L2Jpbi9wZ19jdGwgLUQgL3RtcC9kYXRhLTE0IC1sIGxvZ2ZpbGUg c3RhcnQNCg0KDQojIFN0ZXBzIG9uIHBzcWwNCnBvc3RncmVzPSMgc2VsZWN0IHZlcnNpb24oKTsN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgdmVy c2lvbiAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQogUG9zdGdyZVNRTCAxNC41IChEZWJpYW4gMTQuNS0zK2J1aWxkMSkgb24geDg2XzY0LXBj LWxpbnV4LWdudSwgY29tcGlsZWQgYnkKZ2NjIChEZWJpYW4gMTIuMi4wLTE0KSAxMi4yLjAsIDY0 LWJpdA0KKDEgcm93KQ0KDQpwb3N0Z3Jlcz0jIENSRUFURSBVU0VSIG9sZHVzZXIgV0lUSCBQQVNT V09SRCAnb2xkX3Bhc3N3b3JkJzsNCkFMVEVSIFVTRVIgb2xkdXNlciBXSVRIIFNVUEVSVVNFUjsN CkNSRUFURSBVU0VSIG5ld3VzZXIgV0lUSCBQQVNTV09SRCAnbmV3X3Bhc3N3b3JkJzsNCkFMVEVS IFVTRVIgbmV3dXNlciBXSVRIIFNVUEVSVVNFUjsNCkNSRUFURSBST0xFDQpBTFRFUiBST0xFDQpD UkVBVEUgUk9MRQ0KQUxURVIgUk9MRQ0KcG9zdGdyZXM9IyBccQ0KcG9zdGdyZXNAaGFudW1hbnQ6 fiQgL3Vzci9saWIvcG9zdGdyZXNxbC8xNC9iaW4vcHNxbCAtVSBvbGR1c2VyIC1kCnBvc3RncmVz DQpwc3FsICgxNC41IChEZWJpYW4gMTQuNS0zK2J1aWxkMSkpDQpUeXBlICJoZWxwIiBmb3IgaGVs cC4NCg0KcG9zdGdyZXM9IyBDUkVBVEUgRVhURU5TSU9OIElGIE5PVCBFWElTVFMgcGdfc3RhdF9z dGF0ZW1lbnRzOw0KQ1JFQVRFIEVYVEVOU0lPTg0KcG9zdGdyZXM9IyBccQ0KcG9zdGdyZXNAaGFu dW1hbnQ6fiQgL3Vzci9saWIvcG9zdGdyZXNxbC8xNC9iaW4vcHNxbCAtVSBwb3N0Z3JlcyAtZApw b3N0Z3Jlc15DDQpwb3N0Z3Jlc0BoYW51bWFudDp+JCAvdXNyL2xpYi9wb3N0Z3Jlc3FsLzE0L2Jp bi9wc3FsIC1VIHBvc3RncmVzIC1kCnBvc3RncmVzDQpwc3FsICgxNC41IChEZWJpYW4gMTQuNS0z K2J1aWxkMSkpDQpUeXBlICJoZWxwIiBmb3IgaGVscC4NCg0KcG9zdGdyZXM9IyBSRUFTU0lHTiBP V05FRCBieSBvbGR1c2VyIHRvIG5ld3VzZXI7DQpEUk9QIFVTRVIgb2xkdXNlcjsNClxxDQpSRUFT U0lHTiBPV05FRA0KRFJPUCBST0xFDQpwb3N0Z3Jlc0BoYW51bWFudDp+JCANCg0KIyBkbyBwZ191 cGdyYWRlDQojIyBTZXR1cCBwZzE1DQoNCi91c3IvbGliL3Bvc3RncmVzcWwvMTUvYmluL2luaXRk YiAtLWxvY2FsZT1DLlVURi04IC90bXAvZGF0YS0xNQ0KDQojIyBUcmlnZ2VyIHVwZ3JhZGUNCiAv dXNyL2xpYi9wb3N0Z3Jlc3FsLzE1L2Jpbi9wZ191cGdyYWRlIC1iIC91c3IvbGliL3Bvc3RncmVz cWwvMTQvYmluIC1CCi91c3IvbGliL3Bvc3RncmVzcWwvMTUvYmluIC1kIC90bXAvZGF0YS0xNCAt RCAvdG1wL2RhdGEtMTUgLXIgLXYNCg0KRmFpbHMgd2l0aDoNCmV4ZWN1dGluZzogQUxURVIgREFU QUJBU0UgInRlbXBsYXRlMCIgQUxMT1dfQ09OTkVDVElPTlMgPSBmYWxzZQ0Kb2sNClJlc3Rvcmlu ZyBnbG9iYWwgb2JqZWN0cyBpbiB0aGUgbmV3IGNsdXN0ZXIgICAgICAgICAgICAgICAgCiIvdXNy L2xpYi9wb3N0Z3Jlc3FsLzE1L2Jpbi9wc3FsIiAtLWVjaG8tcXVlcmllcyAtLXNldCBPTl9FUlJP Ul9TVE9QPW9uCi0tbm8tcHNxbHJjIC0tZGJuYW1lPXRlbXBsYXRlMSAtLWhvc3QgL3Zhci9saWIv cG9zdGdyZXNxbCAtLXBvcnQgNTA0MzIKLS11c2VybmFtZSBwb3N0Z3JlcyAtZgoiL3RtcC9kYXRh LTE1L3BnX3VwZ3JhZGVfb3V0cHV0LmQvMjAyNDExMThUMTMyNzIyLjk5Mi9kdW1wL3BnX3VwZ3Jh ZGVfZHVtcF9nbG9iYWxzLnNxbCIKPj4KIi90bXAvZGF0YS0xNS9wZ191cGdyYWRlX291dHB1dC5k LzIwMjQxMTE4VDEzMjcyMi45OTIvbG9nL3BnX3VwZ3JhZGVfdXRpbGl0eS5sb2ciCjI+JjENCm9r DQpSZXN0b3JpbmcgZGF0YWJhc2Ugc2NoZW1hcyBpbiB0aGUgbmV3IGNsdXN0ZXIgICAgICAgICAg ICAgICANCiIvdXNyL2xpYi9wb3N0Z3Jlc3FsLzE1L2Jpbi9wZ19yZXN0b3JlIiAtLWhvc3QgL3Zh ci9saWIvcG9zdGdyZXNxbCAtLXBvcnQKNTA0MzIgLS11c2VybmFtZSBwb3N0Z3JlcyAtLWNsZWFu IC0tY3JlYXRlIC0tZXhpdC1vbi1lcnJvciAtLXZlcmJvc2UKLS1kYm5hbWUgcG9zdGdyZXMKIi90 bXAvZGF0YS0xNS9wZ191cGdyYWRlX291dHB1dC5kLzIwMjQxMTE4VDEzMjcyMi45OTIvZHVtcC9w Z191cGdyYWRlX2R1bXBfMS5jdXN0b20iCj4+CiIvdG1wL2RhdGEtMTUvcGdfdXBncmFkZV9vdXRw dXQuZC8yMDI0MTExOFQxMzI3MjIuOTkyL2xvZy9wZ191cGdyYWRlX2R1bXBfMS5sb2ciCjI+JjEN CiIvdXNyL2xpYi9wb3N0Z3Jlc3FsLzE1L2Jpbi9wZ19yZXN0b3JlIiAtLWhvc3QgL3Zhci9saWIv cG9zdGdyZXNxbCAtLXBvcnQKNTA0MzIgLS11c2VybmFtZSBwb3N0Z3JlcyAtLWNsZWFuIC0tY3Jl YXRlIC0tZXhpdC1vbi1lcnJvciAtLXZlcmJvc2UKLS1kYm5hbWUgdGVtcGxhdGUxCiIvdG1wL2Rh dGEtMTUvcGdfdXBncmFkZV9vdXRwdXQuZC8yMDI0MTExOFQxMzI3MjIuOTkyL2R1bXAvcGdfdXBn cmFkZV9kdW1wXzE0NDI2LmN1c3RvbSIKPj4KIi90bXAvZGF0YS0xNS9wZ191cGdyYWRlX291dHB1 dC5kLzIwMjQxMTE4VDEzMjcyMi45OTIvbG9nL3BnX3VwZ3JhZGVfZHVtcF8xNDQyNi5sb2ciCjI+ JjENCg0KKmZhaWx1cmUqDQpUaGVyZSB3ZXJlIHByb2JsZW1zIGV4ZWN1dGluZyAiIi91c3IvbGli L3Bvc3RncmVzcWwvMTUvYmluL3BnX3Jlc3RvcmUiCi0taG9zdCAvdmFyL2xpYi9wb3N0Z3Jlc3Fs IC0tcG9ydCA1MDQzMiAtLXVzZXJuYW1lIHBvc3RncmVzIC0tY2xlYW4gLS1jcmVhdGUKLS1leGl0 LW9uLWVycm9yIC0tdmVyYm9zZSAtLWRibmFtZSB0ZW1wbGF0ZTEKIi90bXAvZGF0YS0xNS9wZ191 cGdyYWRlX291dHB1dC5kLzIwMjQxMTE4VDEzMjcyMi45OTIvZHVtcC9wZ191cGdyYWRlX2R1bXBf MTQ0MjYuY3VzdG9tIgo+PgoiL3RtcC9kYXRhLTE1L3BnX3VwZ3JhZGVfb3V0cHV0LmQvMjAyNDEx MThUMTMyNzIyLjk5Mi9sb2cvcGdfdXBncmFkZV9kdW1wXzE0NDI2LmxvZyIKMj4mMSINCg0KQ29u c3VsdCB0aGUgbGFzdCBmZXcgbGluZXMgb2YKIi90bXAvZGF0YS0xNS9wZ191cGdyYWRlX291dHB1 dC5kLzIwMjQxMTE4VDEzMjcyMi45OTIvbG9nL3BnX3VwZ3JhZGVfZHVtcF8xNDQyNi5sb2ciCmZv cg0KdGhlIHByb2JhYmxlIGNhdXNlIG9mIHRoZSBmYWlsdXJlLg0KRmFpbHVyZSwgZXhpdGluZw0K Ii91c3IvbGliL3Bvc3RncmVzcWwvMTUvYmluL3BnX2N0bCIgLXcgLUQgIi90bXAvZGF0YS0xNSIg LW8gIiIgLW0gZmFzdCBzdG9wCj4+CiIvdG1wL2RhdGEtMTUvcGdfdXBncmFkZV9vdXRwdXQuZC8y MDI0MTExOFQxMzI3MjIuOTkyL2xvZy9wZ191cGdyYWRlX3NlcnZlci5sb2ciCjI+JjENCg0KIyMg Q2hlY2tpbmcgbG9nczoNCnBnX3Jlc3RvcmU6IGNyZWF0aW5nIEFDTCAicHVibGljLkZVTkNUSU9O CiJwZ19zdGF0X3N0YXRlbWVudHNfcmVzZXQiKCJ1c2VyaWQiICJvaWQiLCAiZGJpZCIgIm9pZCIs ICJxdWVyeWlkIgpiaWdpbnQpIg0KcGdfcmVzdG9yZTogd2hpbGUgUFJPQ0VTU0lORyBUT0M6DQpw Z19yZXN0b3JlOiBmcm9tIFRPQyBlbnRyeSAzOTk5OyAwIDAgQUNMIEZVTkNUSU9OCiJwZ19zdGF0 X3N0YXRlbWVudHNfcmVzZXQiKCJ1c2VyaWQiICJvaWQiLCAiZGJpZCIgIm9pZCIsICJxdWVyeWlk IiBiaWdpbnQpCm5ld3VzZXINCnBnX3Jlc3RvcmU6IGVycm9yOiBjb3VsZCBub3QgZXhlY3V0ZSBx dWVyeTogRVJST1I6ICByb2xlICIxNjM4NCIgZG9lcyBub3QKZXhpc3QNCkNvbW1hbmQgd2FzOiBT RUxFQ1QgcGdfY2F0YWxvZy5iaW5hcnlfdXBncmFkZV9zZXRfcmVjb3JkX2luaXRfcHJpdnModHJ1 ZSk7DQpSRVZPS0UgQUxMIE9OIEZVTkNUSU9OICJwdWJsaWMiLiJwZ19zdGF0X3N0YXRlbWVudHNf cmVzZXQiKCJ1c2VyaWQiICJvaWQiLAoiZGJpZCIgIm9pZCIsICJxdWVyeWlkIiBiaWdpbnQpIEZS T00gUFVCTElDOw0KUkVWT0tFIEFMTCBPTiBGVU5DVElPTiAicHVibGljIi4icGdfc3RhdF9zdGF0 ZW1lbnRzX3Jlc2V0IigidXNlcmlkIiAib2lkIiwKImRiaWQiICJvaWQiLCAicXVlcnlpZCIgYmln aW50KSBGUk9NICJuZXd1c2VyIjsNClNFVCBTRVNTSU9OIEFVVEhPUklaQVRJT04gIjE2Mzg0IjsN CkdSQU5UIEFMTCBPTiBGVU5DVElPTiAicHVibGljIi4icGdfc3RhdF9zdGF0ZW1lbnRzX3Jlc2V0 IigidXNlcmlkIiAib2lkIiwKImRiaWQiICJvaWQiLCAicXVlcnlpZCIgYmlnaW50KSBUTyAiMTYz ODQiOw0KUkVTRVQgU0VTU0lPTiBBVVRIT1JJWkFUSU9OOw0KU0VMRUNUIHBnX2NhdGFsb2cuYmlu YXJ5X3VwZ3JhZGVfc2V0X3JlY29yZF9pbml0X3ByaXZzKGZhbHNlKTsNClJFVk9LRSBBTEwgT04g RlVOQ1RJT04gInB1YmxpYyIuInBnX3N0YXRfc3RhdGVtZW50c19yZXNldCIoInVzZXJpZCIgIm9p ZCIsCiJkYmlkIiAib2lkIiwgInF1ZXJ5aWQiIGJpZ2ludCkgRlJPTSAiMTYzODQiOw0KR1JBTlQg QUxMIE9OIEZVTkNUSU9OICJwdWJsaWMiLiJwZ19zdGF0X3N0YXRlbWVudHNfcmVzZXQiKCJ1c2Vy aWQiICJvaWQiLAoiZGJpZCIgIm9pZCIsICJxdWVyeWlkIiBiaWdpbnQpIFRPICJuZXd1c2VyIjsK Cg== --===============0136205092548507819==--