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 1tlbAv-000S5t-6i for pgsql-committers@arkaria.postgresql.org; Fri, 21 Feb 2025 22:07:13 +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 1tlbAu-00HKWU-An for pgsql-committers@arkaria.postgresql.org; Fri, 21 Feb 2025 22:07:12 +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 1tlbAu-00HKWM-3A for pgsql-committers@lists.postgresql.org; Fri, 21 Feb 2025 22:07:12 +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 1tlbAq-0002H9-3A for pgsql-committers@lists.postgresql.org; Fri, 21 Feb 2025 22:07:10 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tlbAr-00050i-Hq for pgsql-committers@lists.postgresql.org; Fri, 21 Feb 2025 22:07:09 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tlbAq-0002Fj-2t for pgsql-committers@lists.postgresql.org; Fri, 21 Feb 2025 22:07:09 +0000 Content-Type: multipart/mixed; boundary="===============5547504578730249547==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid race condition between "GRANT role" and "DROP ROLE". X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 21 Feb 2025 22:07:09 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5547504578730249547== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgcmFjZSBjb25kaXRpb24gYmV0d2VlbiAiR1JBTlQgcm9sZSIgYW5kICJEUk9QIFJPTEUi LgoKQ29uY3VycmVudGx5IGRyb3BwaW5nIGVpdGhlciB0aGUgZ3JhbnRlZCByb2xlIG9yIHRoZSBn cmFudGVlCmRvZXMgbm90IHN0b3AgR1JBTlQgZnJvbSBjb21wbGV0aW5nLCBpbnN0ZWFkIHJlc3Vs dGluZyBpbiBhCmRhbmdsaW5nIHJvbGUgcmVmZXJlbmNlIGluIHBnX2F1dGhfbWVtYmVycy4gIFRo YXQncyByZWxhdGl2ZWx5Cmhhcm1sZXNzIGluIHRoZSBzaG9ydCBydW4sIGJ1dCBpbmNvbnNpc3Rl bnQgY2F0YWxvZyBlbnRyaWVzCmFyZSBub3QgYSBnb29kIHRoaW5nLgoKVGhpcyBwYXRjaCBzb2x2 ZXMgdGhlIHByb2JsZW0gYnkgYWRkaW5nIHRoZSBncmFudGVkIGFuZCBncmFudGVlCnJvbGVzIGFz IGV4cGxpY2l0IHNoYXJlZCBkZXBlbmRlbmNpZXMgb2YgdGhlIHBnX2F1dGhfbWVtYmVycyBlbnRy eS4KVGhhdCdzIGEgYml0IGluZGlyZWN0LCBidXQgaXQgd29ya3MgYmVjYXVzZSB0aGUgcGdfc2hk ZXBlbmQgY29kZQphcHBsaWVzIHRoZSBuZWNlc3NhcnkgbG9ja2luZyBhbmQgcmVjaGVja2luZy4K CkNvbW1pdCA2NTY2MTMzYzUgcHJldmlvdXNseSBlc3RhYmxpc2hlZCBzaW1pbGFyIGhhbmRsaW5n IGZvcgp0aGUgZ3JhbnRvciBjb2x1bW4gb2YgcGdfYXV0aF9tZW1iZXJzOyBpdCdzIG5vdCBjbGVh ciB3aHkgaXQKZGlkbid0IGNvdmVyIHRoZSBvdGhlciB0d28gcm9sZSBPSUQgY29sdW1ucy4KCkEg c2lkZS1lZmZlY3Qgb2YgdGhpcyBhcHByb2FjaCBpcyB0aGF0IERST1AgT1dORUQgQlkgd2lsbCBu b3cgZHJvcApwZ19hdXRoX21lbWJlcnMgZW50cmllcyB0aGF0IG1lbnRpb24gdGhlIHRhcmdldCBy b2xlIGFzIGVpdGhlciB0aGUKZ3JhbnRlZCBvciBncmFudGVlIHJvbGUuICBUaGF0J3MgY2xlYXJs eSBhcHByb3ByaWF0ZSBmb3IgdGhlCmdyYW50ZWUsIHNpbmNlIHdlJ2xsIGRyb3AgaXRzIG90aGVy IHByaXZpbGVnZXMgdG9vLiAgSXQgZG9lc24ndApzZWVtIHRvbyBmYXIgb3V0IG9mIGxpbmUgZm9y IHRoZSBncmFudGVkIHJvbGUsIHNpbmNlIHdlJ3JlCnByZXN1bWFibHkgYWJvdXQgdG8gZHJvcCBp dCBhbmQgYmVzaWRlcyB3ZSdyZSByZW1vdmluZyBhbGwgcmVhc29ucwp3aHkgaXQnZCBtYXR0ZXIg dG8gYmUgYSBtZW1iZXIgb2YgaXQuICAoT25lIGNvdWxkIGFyZ3VlIHRoYXQgdGhpcwptYWtlcyBE cm9wUm9sZSdzIGNvZGUgdG8gYXV0by1kcm9wIHBnX2F1dGhfbWVtYmVycyBlbnRyaWVzCnVubmVj ZXNzYXJ5LCBidXQgSSBjaG9zZSB0byBsZWF2ZSBpdCBpbiBwbGFjZSBzaW5jZSBwZXJoYXBzIHNv bWUKcGVvcGxlJ3Mgd29ya2Zsb3dzIGV4cGVjdCB0aGF0IHRvIHdvcmsgd2l0aG91dCBhIERST1Ag T1dORUQgQlkuKQoKTm90ZSB0byBwYXRjaCByZWFkZXJzOiBDcmVhdGVSb2xlJ3MgZmlyc3QgQ29t bWFuZENvdW50ZXJJbmNyZW1lbnQKY2FsbCBpcyBub3cgdW5jb25kaXRpb25hbCwgYmVjYXVzZSB0 aGlzIGNoYW5nZSBjcmVhdGVzIGFub3RoZXIKY2FzZSBpbiB3aGljaCBpdCdzIG5lZWRlZCwgYW5k IGl0IHNlZW1lZCB0byBiZSBtb3JlIHRyb3VibGUgdGhhbgppdCdzIHdvcnRoIHRvIHByZXNlcnZl IHRoYXQgbWljcm8tb3B0aW1pemF0aW9uLgoKQXJndWFibHkgdGhpcyBpcyBhIGJ1ZyBmaXgsIGJ1 dCB0aGUgZmFjdCB0aGF0IGl0IGNoYW5nZXMgdGhlCmV4cGVjdGVkIGNvbnRlbnRzIG9mIHBnX3No ZGVwZW5kIHNlZW1zIGxpa2Ugbm90IGEgZ3JlYXQgdGhpbmcKdG8gZG8gaW4gdGhlIHN0YWJsZSBi cmFuY2hlcywgYW5kIHBlcmhhcHMgd2UgZG9uJ3Qgd2FudCB0aGUKY2hhbmdlIGluIERST1AgT1dO RUQgQlkgc2VtYW50aWNzIHRoZXJlIGVpdGhlci4gIE9uIHRoZSBvdGhlcgpoYW5kLCBJIG9wdGVk IG5vdCB0byBmb3JjZSBhIGNhdHZlcnNpb24gYnVtcCBpbiBIRUFELCBiZWNhdXNlCnRoZSBwcmVz ZW5jZSBvciBhYnNlbmNlIG9mIHRoZXNlIGVudHJpZXMgZG9lc24ndCBtYXR0ZXIgZm9yCm1vc3Qg cHVycG9zZXMuCgpSZXBvcnRlZC1ieTogVmlyZW5kZXIgU2luZ2xhIDx2aXJlbmRlci5jc2VAZ21h aWwuY29tPgpSZXZpZXdlZC1ieTogTGF1cmVueiBBbGJlIDxsYXVyZW56LmFsYmVAY3liZXJ0ZWMu YXQ+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FNNlpvOHdvYTYyWkZIdE1Lb3g2 YTRqYjhxUT13ODdSMkwwSzgzNDdpRS1qdVFMMkVBQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0t LS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3Bn L2NvbW1pdGRpZmYvOThmYzMxZDY0OTkxNjNhMGE3ODFhYTZmMTM1ODJhMDdmMDljZDdjNgoKTW9k aWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9jL3NyYy9zZ21sL3JlZi9kcm9wX293bmVkLnNn bWwgICAgICAgICB8ICAyICstCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3VzZXIuYyAgICAgICAgICAg ICAgfCAyMyArKysrKysrKysrKysrKysrKy0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVk L3ByaXZpbGVnZXMub3V0IHwgMzAgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrCnNyYy90 ZXN0L3JlZ3Jlc3Mvc3FsL3ByaXZpbGVnZXMuc3FsICAgICAgfCAxNSArKysrKysrKysrKysrKysK NCBmaWxlcyBjaGFuZ2VkLCA2MyBpbnNlcnRpb25zKCspLCA3IGRlbGV0aW9ucygtKQoK --===============5547504578730249547==--