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 1uH1cl-00C3Or-Ah for pgsql-bugs@arkaria.postgresql.org; Mon, 19 May 2025 14:37:51 +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 1uH1ck-00G4zX-Bf for pgsql-bugs@arkaria.postgresql.org; Mon, 19 May 2025 14:37:50 +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 1uGw7Q-00Eamw-7J for pgsql-bugs@lists.postgresql.org; Mon, 19 May 2025 08:45:08 +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.96) (envelope-from ) id 1uGw7N-002Xiz-03 for pgsql-bugs@lists.postgresql.org; Mon, 19 May 2025 08:45:06 +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=GgzDH5GTdYc61B/jr9uELvDWu1keNSVfgzTCWlGUu3g=; b=aTHpViqveUpBW0xX0yTGM0Of5P 2fYEkxKDFDnrdp7Rw8/5LcpzUKVUmJ+UEizPUx5i7y31tWJN4LWd9ZICb0wraNrGgtlTn8kwdQxn/ JYUjkuRoutVVEpfm6O/fvyvlce0h2A9kM9XQMxJJv0ThHmbGytju/Z76mtFiCVL1TGJY3UB395I4Z WdAjTgEzB4T+eIb90O1ueVDJNuE3tldrtA/bNeh1BK0CXdC1TV8AgZ9E0mMZt7L8OKmnbJGPDaUfl /RlbuHFyykGxzDkBzez7Y9X7ZubRaSvOU8i33VWVkw0GdH1F6iOHeUxGgDkEb7SkBzKFhJz1D8pCm 6kYVx32Q==; 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 1uGw7M-007gqR-T0 for pgsql-bugs@lists.postgresql.org; Mon, 19 May 2025 08:45: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 1uGw7K-00FORP-NR for pgsql-bugs@lists.postgresql.org; Mon, 19 May 2025 08:45:02 +0000 Content-Type: multipart/mixed; boundary="===============7614845613094892468==" MIME-Version: 1.0 Subject: BUG #18934: Even with WITH ADMIN OPTION, I Cannot Manage Role Memberships To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: snaperling@gmail.com Reply-To: snaperling@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 19 May 2025 08:44:51 +0000 Message-ID: <18934-67d2e90068801d2b@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 --===============7614845613094892468== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODkzNApMb2dnZWQgYnk6ICAgICAgICAgIEx1aXMgQ291dG8KRW1haWwg YWRkcmVzczogICAgICBzbmFwZXJsaW5nQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE2 LjgKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDEwCkRlc2NyaXB0aW9uOiAgICAgICAgCgpJ biBQb3N0Z3JlU1FMLCBJIGhhdmUgYSByb2xlIGhpZXJhcmNoeSBpbnZvbHZpbmcgYSB1c2VyIGFu ZCB0d28gZ3JvdXAgcm9sZXM6ClJvbGVzOgogICAgdGVzdGVyMUBzb21ldGhpbmcg4oCUIGEgdXNl ciByb2xlIChub3Qgc3VwZXJ1c2VyKQogICAgdXNlcl9tYW5hZ2VyIOKAlCBhbiBpbnRlcm1lZGlh dGUgZ3JvdXAgcm9sZQogICAgdXNlcl9ncm91cCDigJQgdGhlIHRhcmdldCBncm91cCByb2xlIHdo b3NlIG1lbWJlcnNoaXAgSSB3YW50IHRvIG1hbmFnZQp8IFJvbGUgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIHwgTWVtYmVyIE9mICAgICAgICAgICAgfCBgV0lUSCBBRE1JTgpPUFRJT05gIHwK fCBgdGVzdGVyMUBzb21ldGhpbmdgICAgfCBgdXNlcl9tYW5hZ2VyYCAgICB8IFlFUwp8CnwgYHVz ZXJfbWFuYWdlcmAgICAgICAgICAgIHwgYHVzZXJfZ3JvdXBgICAgICAgICAgfCBZRVMKfApJbiB0 aGlzIGNvbmZpZ3VyYXRpb246CiAgICB0ZXN0ZXIxQHNvbWV0aGluZyBzaG91bGQgYmUgYWJsZSB0 byBhZGQvcmVtb3ZlIG1lbWJlcnMgZnJvbSB1c2VyX2dyb3VwLgogICAgQnV0IGl0IGNhbm5vdCDi gJQgR1JBTlQgb3IgUkVWT0tFIG9uIHVzZXJfZ3JvdXAgZmFpbHMuCiAgICBFdmVuIHRob3VnaCB0 ZXN0ZXIxQHNvbWV0aGluZyBoYXMgZnVsbCBhZG1pbiByaWdodHMgb24gdXNlcl9tYW5hZ2VyLCBh bmQKdXNlcl9tYW5hZ2VyIGhhcyBhZG1pbiByaWdodHMgb24gdXNlcl9ncm91cC4KUm9sZSBTZXR1 cCAoQWZ0ZXIgTWFudWFsIEZpeCkKV2hlbiBJIHJ1bjoKUkVWT0tFIEFETUlOIE9QVElPTiBGT1Ig dXNlcl9ncm91cCBGUk9NIHVzZXJfbWFuYWdlcjsKU28gdGhhdCBub3c6ClJvbGUgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIE1lbWJlciBPZiAgICAgIFdJVEggQURNSU4gT1BUSU9OCnRlc3Rl cjFAc29tZXRoaW5nICAgICAgIHVzZXJfbWFuYWdlciAgICAgICAgICAgWUVTCnVzZXJfbWFuYWdl ciAgICAgICAgICAgIHVzZXJfZ3JvdXAgICAgICAgICAgICAgICAgIE5PCk5vdywgdW5leHBlY3Rl ZGx5OgogICAgdGVzdGVyMUBzb21ldGhpbmcgY2FuIGFkZCBhbmQgcmVtb3ZlIG1lbWJlcnMgZnJv bSB1c2VyX2dyb3VwLgogICAgRXZlbiB0aG91Z2ggbm8gcm9sZSBpbiB0aGUgY2hhaW4gaGFzIFdJ VEggQURNSU4gT1BUSU9OIG9uIHVzZXJfZ3JvdXAuClN1bW1hcnkgb2YgdGhlIFR3byBJc3N1ZXMK MS4gTWFpbiBJc3N1ZSAoVW5leHBlY3RlZCBSZXN0cmljdGlvbik6CiAgICBXaGVuIHVzZXJfbWFu YWdlciBoYXMgV0lUSCBBRE1JTiBPUFRJT04gb24gdXNlcl9ncm91cCwgYW5kIEkgKGFzCnRlc3Rl cjFAc29tZXRoaW5nKSBoYXZlIFdJVEggQURNSU4gT1BUSU9OIG9uIHVzZXJfbWFuYWdlciwgSSBj YW5ub3QgbWFuYWdlCnVzZXJfZ3JvdXAuClRoaXMgaXMgY29uZnVzaW5nIOKAlCBQb3N0Z3JlU1FM IHNob3VsZCBhbGxvdyBpdCwgYXMgYm90aCBhZG1pbiBsaW5rcyBhcmUKcHJlc2VudC4gKG1heWJl IEknbSBnZXR0aW5nIHNvbWV0aGluZyB3cm9uZykKMi4gU2Vjb25kYXJ5IElzc3VlIChVbmV4cGVj dGVkIFBlcm1pc3Npb24gR3JhbnQpOgogICAgSWYgSSByZXZva2UgYWRtaW4gb3B0aW9uIGZyb20g dXNlcl9tYW5hZ2VyIG9uIHVzZXJfZ3JvdXAsIHN1ZGRlbmx5IEkgY2FuCm1hbmFnZSB1c2VyX2dy b3VwIGZyb20gdGVzdGVyMUBzb21ldGhpbmcuClRoaXMgY29udHJhZGljdHMgdGhlIGRvY3VtZW50 ZWQgbmVlZCBmb3IgV0lUSCBBRE1JTiBPUFRJT04gYW5kIGFwcGVhcnMgdG8KZXhwb3NlIGEgcHJp dmlsZWdlIGluY29uc2lzdGVuY3kgb3IgZXNjYWxhdGlvbi4KV2hhdCBjb3VsZCBiZSBoYXBwZW5p bmc/ClRoYW5rIHlvdSBpbiBhZHZhbmNlLApMdWlzIENvdXRvCgo= --===============7614845613094892468==--