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 1tDlaM-0032Qw-4S for pgsql-bugs@arkaria.postgresql.org; Wed, 20 Nov 2024 14:21:38 +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 1tDlaK-006H1Z-St for pgsql-bugs@arkaria.postgresql.org; Wed, 20 Nov 2024 14:21:36 +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 1tDjuL-005807-6I for pgsql-bugs@lists.postgresql.org; Wed, 20 Nov 2024 12:34:09 +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 1tDjuI-002vD0-Ay for pgsql-bugs@lists.postgresql.org; Wed, 20 Nov 2024 12:34:08 +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=lXm3hQReVuBM/Z3gbeDyxIm0AnOAygHnH47fFMhRLnI=; b=n0gt/1KmUyid7ofgga5zulrTLY tGYfaubQjWOmO9nVPmNzjgTMuGvyU3QNZqApLimS0IIcG0K+ttZ4vuhn9/2g3/B4bJlotnDE2HUpk 7CqsFlE57enCypVVmQ31KgyWv8TF7HRrfs0ZArQw69Hu97f3HR7Oa28zKFmWbFepYGQ3uZMggijkB u8gL1j+ZHo+2PFtmCm06b71Fav76JjCT3qgkKNv8CjUq0nCajDDqCETypKKXONKciGayu52NtgPSD nmzdFy1D6vCs3s8GQMJWdjhceEhlRppYtSjvrcPfW5IDbAGIQ1aUUuFi6z7wEpIFET69lwL3Hjd9R Z/mH6+Og==; 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 1tDjuG-008wRD-R9 for pgsql-bugs@lists.postgresql.org; Wed, 20 Nov 2024 12:34: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 1tDjuF-009h0f-6D for pgsql-bugs@lists.postgresql.org; Wed, 20 Nov 2024 12:34:03 +0000 Content-Type: multipart/mixed; boundary="===============1687378556762621177==" MIME-Version: 1.0 Subject: BUG #18717: ALTER ROLE SET ROLE functionality is broken To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kolpasch@gmail.com Reply-To: kolpasch@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 20 Nov 2024 12:33:41 +0000 Message-ID: <18717-6cddff21930a88e6@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 --===============1687378556762621177== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODcxNwpMb2dnZWQgYnk6ICAgICAgICAgIEdlbm5hZHkgS2sKRW1haWwg YWRkcmVzczogICAgICBrb2xwYXNjaEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNC4x NApPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNC42IExUUwpEZXNjcmlwdGlvbjogICAg ICAgIAoKQnVnIFJlcG9ydA0KDQoqKlN1bW1hcnkqKg0KDQpPdXIgZ29hbCBpcyB0byBjcmVhdGUg YSBkYXRhYmFzZSB3aGVyZSBzZXZlcmFsIHVzZXJzIHdvcmsgd2l0aCBvd25lcgpyaWdodHMuDQpF dmVyeSBvYmplY3QgY3JlYXRlZCBpbiB0aGUgZGF0YWJhc2UgbXVzdCBoYXZlIHRoZSBzYW1lIG93 bmVyIGFzIHRoZQpkYXRhYmFzZSBpdHNlbGYsc28gdGhhdCBhbnkgb2JqZWN0IGlzIGFjY2Vzc2li bGUgdG8gYWxsIHVzZXJzIHdpdGggbWF4aW11bQpwZXJtaXNzaW9ucy4NCg0KVG8gYWNoaWV2ZSB0 aGlzLCB3ZSBjcmVhdGUgc2V2ZXJhbCBsb2dpbiByb2xlcyBhbmQgb25lIG5vbi1sb2dpbiByb2xl IGFzIHRoZQpkYXRhYmFzZSBvd25lci4NCldlIGdyYW50IHRoZSBvd25lciByb2xlIHRvIHRoZSBs b2dpbiByb2xlcywgYW5kIGFzc2lnbiBpdCBieSBBTFRFUiBST0xFCjxsb2dpbl9yb2xlPiBTRVQg Uk9MRSA9IDxvd25lcl9yb2xlPi4gQXMgYSByZXN1bHQsIHdoZW4gbG9nZ2luZyBpbnRvIHRoZQpk YXRhYmFzZSB3aXRoIGEgbG9naW4gcm9sZSwgaXQgaXMgYXV0b21hdGljYWxseSBhc3NpZ25lZCB0 aGUgb3duZXIgcm9sZS4NCg0KU3RhcnRpbmcgd2l0aCB2ZXJzaW9uIDE0LjE0LCB0aGlzIGJlaGF2 aW9yIGlzIGJyb2tlbiwgYW5kIHRoZSBpc3N1ZSBwZXJzaXN0cwppbiB2ZXJzaW9uIDE3LjEuIFdo ZW4gY29ubmVjdGluZyB0byB0aGUgZGF0YWJhc2Ugd2l0aCBhIGxvZ2luIHJvbGUsIHRoZQpzZXNz aW9uIGlzIGFzc2lnbmVkIGFuIGVtcHR5IChub25lKSB2YWx1ZSBmb3IgdGhlIHJvbGUsIGxlYXZp bmcgdXNlcnMKd2l0aG91dCB0aGUgbmVjZXNzYXJ5IHBlcm1pc3Npb25zLg0KDQoqKlN0ZXBzIHRv IFJlcHJvZHVjZSoqDQoNCnBvc3RncmVzPSMgY3JlYXRlIHJvbGUgImJlbmNoLW93bmVyIjsNCnBv c3RncmVzPSMgY3JlYXRlIGRhdGFiYXNlIGJlbmNoIG93bmVyICJiZW5jaC1vd25lciI7DQpwb3N0 Z3Jlcz0jIGNyZWF0ZSB1c2VyICJiZW5jaC1zcnYiIG5vaW5oZXJpdDsNCnBvc3RncmVzPSMgZ3Jh bnQgImJlbmNoLW93bmVyIiB0byAiYmVuY2gtc3J2IjsNCnBvc3RncmVzPSMgYWx0ZXIgcm9sZSAi YmVuY2gtc3J2IiBzZXQgcm9sZSAnYmVuY2gtb3duZXInOw0KcG9zdGdyZXM9IyBccQ0KDQoqKkV4 cGVjdGVkIFJlc3VsdCoqDQoNCnJvb3RAaG9zdG5hbWU6fiMgcHNxbCAtVSBiZW5jaC1zcnYgYmVu Y2gNCnBzcWwgKDE0LjEzIChVYnVudHUgMTQuMTMtMS5wZ2RnMjAuMDQrMSkpDQpUeXBlICJoZWxw IiBmb3IgaGVscC4NCg0KYmVuY2g9PiBzaG93IHJvbGU7DQogICAgIHJvbGUgICAgIA0KLS0tLS0t LS0tLS0tLS0NCiBiZW5jaC1vd25lcg0KKDEgcm93KQ0KDQpiZW5jaD0+IGNyZWF0ZSB0YWJsZSB0 c3QoaWQgaW50KTsNCmJlbmNoPT4gXGQrDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgTGlzdCBvZiByZWxhdGlvbnMNCiBTY2hlbWEgfCBOYW1lIHwgVHlwZSAgfCAgICBPd25l ciAgICAgfCBQZXJzaXN0ZW5jZSB8IEFjY2VzcyBtZXRob2QgfCAgU2l6ZSAKIHwgRGVzY3JpcHRp b24gDQotLS0tLS0tLSstLS0tLS0rLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0KIHB1YmxpYyB8IHRzdCAg fCB0YWJsZSB8IGJlbmNoLW93bmVyIHwgcGVybWFuZW50ICAgfCBoZWFwICAgICAgICAgIHwgMCBi eXRlcwp8IA0KKDEgcm93KQ0KDQpiZW5jaD0+IHNlbGVjdCB2ZXJzaW9uKCk7DQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB2ZXJz aW9uICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogUG9zdGdyZVNRTCAxNC4xMyAoVWJ1bnR1 IDE0LjEzLTEucGdkZzIwLjA0KzEpIG9uIHg4Nl82NC1wYy1saW51eC1nbnUsCmNvbXBpbGVkIGJ5 IGdjYyAoVWJ1bnR1IDkuNC4wLTF1YnVudHUxfjIwLjA0LjIpIDkuNC4wLCA2NC1iaXQNCigxIHJv dykNCg0KKipBY3R1YWwgUmVzdWx0KioNCg0Kcm9vdEBob3N0bmFtZTp+IyBwc3FsIC1VIGJlbmNo LXNydiBiZW5jaA0KcHNxbCAoMTQuMTMgKFVidW50dSAxNC4xMy0xLnBnZGcyMC4wNCsxKSwgc2Vy dmVyIDE0LjE0IChVYnVudHUKMTQuMTQtMS5wZ2RnMjAuMDQrMSkpDQpUeXBlICJoZWxwIiBmb3Ig aGVscC4NCg0KYmVuY2g9PiBzaG93IHJvbGU7DQogcm9sZSANCi0tLS0tLQ0KIG5vbmUNCigxIHJv dykNCg0KYmVuY2g9PiBjcmVhdGUgdGFibGUgdHN0KGlkIGludCk7DQpFUlJPUjogIHBlcm1pc3Np b24gZGVuaWVkIGZvciBzY2hlbWEgcHVibGljDQoNCmJlbmNoPT4gc2VsZWN0IHZlcnNpb24oKTsN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIHZlcnNpb24gICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBQb3N0Z3JlU1FMIDE0 LjE0IChVYnVudHUgMTQuMTQtMS5wZ2RnMjAuMDQrMSkgb24geDg2XzY0LXBjLWxpbnV4LWdudSwK Y29tcGlsZWQgYnkgZ2NjIChVYnVudHUgOS40LjAtMXVidW50dTF+MjAuMDQuMikgOS40LjAsIDY0 LWJpdA0KKDEgcm93KQoK --===============1687378556762621177==--