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 1suQeO-006e2H-0Y for pgsql-bugs@arkaria.postgresql.org; Sat, 28 Sep 2024 06:09:52 +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 1suQeM-003Yjp-Id for pgsql-bugs@arkaria.postgresql.org; Sat, 28 Sep 2024 06:09:50 +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 1suKTQ-00Gzzj-Gf for pgsql-bugs@lists.postgresql.org; Fri, 27 Sep 2024 23:34:08 +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 1suKTM-001Qj5-Ux for pgsql-bugs@lists.postgresql.org; Fri, 27 Sep 2024 23:34:07 +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=G2l0QN1k4JcZxh0/gUljC9AzJ+uZc8/YMZ6ir1kKVX8=; b=6orvkIliFN1x7O1r0m7Rxgdi4u Fdw2xfni76aM+6IMsuGMQLmxqVs4H9Fp3iwKAdEtl8SVHyu8wDfnxAlJC7H9paZU8QOvs3obMHKKu OgggKngCYwW62LFA4KdNS/sOcMhC6yK1oPDRwEb2P8LNVKOa8kRyqpV/+EaEwRpM2jWaJTDVmUGog RpGwIInOD0aQJYbWtKzHZuj2BnceQyYhEzvpXhR3WgkIHOO+Hghv6eK+/HSK3Qdm8H7yhPTUiFHuJ duW/sI8PCdqQkngSV0DKzQzF/G7+jLQXRFx4O2K9r1tJgfnibb1Jrb7UvNoK9b8Xy58zIuxgTZsj3 0FOIljTA==; 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 1suKTM-004L3y-CW for pgsql-bugs@lists.postgresql.org; Fri, 27 Sep 2024 23: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 1suKTK-007FjZ-HN for pgsql-bugs@lists.postgresql.org; Fri, 27 Sep 2024 23:34:02 +0000 Content-Type: multipart/mixed; boundary="===============1966478242352509756==" MIME-Version: 1.0 Subject: BUG #18639: Unexpected behavior with SET ROLE and CREATE ROLE interaction 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: Fri, 27 Sep 2024 23:33:46 +0000 Message-ID: <18639-d7908c6b789395b5@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 --===============1966478242352509756== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODYzOQpMb2dnZWQgYnk6ICAgICAgICAgIEx1aXMgQ291dG8KRW1haWwg YWRkcmVzczogICAgICBzbmFwZXJsaW5nQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE2 LjQKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIEFueQpEZXNjcmlwdGlvbjogICAgICAgIAoK SSd2ZSBvYnNlcnZlZCBhbiB1bmV4cGVjdGVkIGJlaGF2aW9yIHdoZW4gdXNpbmcgU0VUIFJPTEUg aW4gY29tYmluYXRpb24gd2l0aApDUkVBVEUgUk9MRSBpbiBQb3N0Z3JlU1FMLiBJJ2QgbGlrZSB0 byBjb25maXJtIGlmIHRoaXMgaXMgaW50ZW5kZWQgYmVoYXZpb3IKb3IgaWYgaXQncyBhbiB1bmRv Y3VtZW50ZWQgc2lkZSBlZmZlY3QuDQoNClRoZSBzY2VuYXJpbzoNCg0KMS4gVXNlciBBIHNldHMg dGhlaXIgcm9sZSB0byBSb2xlIEIgdXNpbmcgU0VUIFJPTEUuDQoyLiBXaGlsZSBhY3RpbmcgYXMg Um9sZSBCLCBVc2VyIEEgY3JlYXRlcyBhIG5ldyBSb2xlIEMgdXNpbmcgQ1JFQVRFIFJPTEUuDQoz LiBVbmV4cGVjdGVkbHksIFJvbGUgQiBiZWNvbWVzIGEgbWVtYmVyIG9mIHRoZSBuZXdseSBjcmVh dGVkIFJvbGUgQy4NCg0KRXhhbXBsZToNCg0KU0VUIFJPTEUgYWRtaW5fcm9sZTsNCkNSRUFURSBS T0xFIG5ld191c2VyIFdJVEggUEFTU1dPUkQgJ3Bhc3N3b3JkJzsNCg0KSW4gdGhpcyBjYXNlLCBh ZG1pbl9yb2xlIGJlY29tZXMgYSBtZW1iZXIgb2YgbmV3X3VzZXIuDQoNClRoaXMgYXV0b21hdGlj IG1lbWJlcnNoaXAgYXNzaWdubWVudCBzZWVtcyB0byBwcmV2ZW50IGFkZGluZyBuZXdfdXNlciB0 byB0aGUKYWRtaW5fcm9sZSBncm91cCBsYXRlciBvbi4NCg0KUXVlc3Rpb25zOg0KDQoxLiBJcyB0 aGlzIGJlaGF2aW9yIGludGVudGlvbmFsIG9yIGRvY3VtZW50ZWQgYW55d2hlcmU/DQoyLiBJZiBp bnRlbnRpb25hbCwgd2hhdCdzIHRoZSByYXRpb25hbGUgYmVoaW5kIHRoaXMgYXV0b21hdGljIG1l bWJlcnNoaXAKYXNzaWdubWVudD8NCjMuIEFyZSB0aGVyZSBhbnkgcmVjb21tZW5kZWQgYmVzdCBw cmFjdGljZXMgdG8gYXZvaWQgdGhpcyB3aGVuIGNyZWF0aW5nCnJvbGVzPw0KDQpJIGNvdWxkbid0 IGZpbmQgYW55IGRvY3VtZW50YXRpb24gZXhwbGljaXRseSBtZW50aW9uaW5nIHRoaXMgYmVoYXZp b3IsIHNvCkknZCBhcHByZWNpYXRlIGFueSBpbnNpZ2h0cyBvciBjbGFyaWZpY2F0aW9uIG9uIHRo aXMgbWF0dGVyLgoK --===============1966478242352509756==--