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 1s1aOF-00DJKB-9T for pgsql-committers@arkaria.postgresql.org; Mon, 29 Apr 2024 23:26:31 +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 1s1aOC-002aas-CU for pgsql-committers@arkaria.postgresql.org; Mon, 29 Apr 2024 23:26:29 +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 1s1aOC-002aaj-47 for pgsql-committers@lists.postgresql.org; Mon, 29 Apr 2024 23:26:29 +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.94.2) (envelope-from ) id 1s1aOA-000g8m-80 for pgsql-committers@lists.postgresql.org; Mon, 29 Apr 2024 23:26:27 +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 1s1aO8-002Axh-Mb for pgsql-committers@lists.postgresql.org; Mon, 29 Apr 2024 23:26:25 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s1aO7-000hDA-Km for pgsql-committers@lists.postgresql.org; Mon, 29 Apr 2024 23:26:24 +0000 Content-Type: multipart/mixed; boundary="===============6181560099800107563==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix failure to track role dependencies of pg_init_privs entries. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Apr 2024 23:26:24 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6181560099800107563== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGZhaWx1cmUgdG8gdHJhY2sgcm9sZSBkZXBlbmRlbmNpZXMgb2YgcGdfaW5pdF9wcml2cyBl bnRyaWVzLgoKSWYgYW4gQUNMIHJlY29yZGVkIGluIHBnX2luaXRfcHJpdnMgbWVudGlvbnMgYSBu b24tcGlubmVkIHJvbGUsCnRoYXQgcmVmZXJlbmNlIG11c3QgYWxzbyBiZSBub3RlZCBpbiBwZ19z aGRlcGVuZCBzbyB0aGF0IHdlIGtub3cKdGhhdCB0aGUgcm9sZSBjYW4ndCBnbyBhd2F5IHdpdGhv dXQgcmVtb3ZpbmcgdGhlIEFDTCByZWZlcmVuY2UuCk90aGVyd2lzZSwgRFJPUCBST0xFIGNvdWxk IHN1Y2NlZWQgYW5kIGxlYXZlIGRhbmdsaW5nIGVudHJpZXMKYmVoaW5kLCB3aGljaCBpcyB3aGF0 J3MgY2F1c2luZyB0aGUgcmVjZW50IHVwZ3JhZGUtY2hlY2sgZmFpbHVyZXMKb24gYnVpbGRmYXJt IG1lbWJlciBjb3BwZXJoZWFkLgoKVGhpcyBoYXMgYmVlbiB3cm9uZyBzaW5jZSBwZ19pbml0X3By aXZzIHdhcyBpbnRyb2R1Y2VkLCBidXQgaXQncwplc2NhcGVkIG5vdGljZSBiZWNhdXNlIHR5cGlj YWwgcGdfaW5pdF9wcml2cyBlbnRyaWVzIHdvdWxkIG9ubHkKbWVudGlvbiB0aGUgYm9vdHN0cmFw IHN1cGVydXNlciAocGlubmVkKSBvciBhdCB3b3JzdCB0aGUgb3duZXIKb2YgdGhlIGV4dGVuc2lv biAod2hvIGNhbid0IGdvIGF3YXkgYmVmb3JlIHRoZSBleHRlbnNpb24gZG9lcykuCgpXZSBsYWNr IGV2ZW4gYSByZXByZXNlbnRhdGlvbiBvZiBzdWNoIGEgcm9sZSByZWZlcmVuY2UgZm9yCnBnX3No ZGVwZW5kLiAgTXkgZmlyc3QgdGhvdWdodCBmb3IgYSBzb2x1dGlvbiB3YXMgZW50cmllcyBsaXN0 aW5nCnBnX2luaXRfcHJpdnMgaW4gY2xhc3NpZCwgYnV0IHRoYXQgZG9lc24ndCB3b3JrIGJlY2F1 c2UgdGhlbiB0aGVyZSdzCm5vcGxhY2UgdG8gcHV0IHRoZSBncmFudGVkLW9uIG9iamVjdCdzIGNs YXNzaWQuICBSYXRoZXIgdGhhbiBhZGRpbmcKYSBuZXcgY29sdW1uIHRvIHBnX3NoZGVwZW5kLCBs ZXQncyBhZGQgYSBuZXcgZGVwdHlwZSBjb2RlClNIQVJFRF9ERVBFTkRFTkNZX0lOSVRBQ0wuICBN dWNoIG9mIHRoZSBhc3NvY2lhdGVkIGJvaWxlcnBsYXRlCmNvZGUgY2FuIGJlIGNyaWJiZWQgZnJv bSBjb2RlIGZvciBTSEFSRURfREVQRU5ERU5DWV9BQ0wuCgpBIGxvdCBvZiB0aGUgYnVsayBvZiB0 aGlzIHBhdGNoIGp1c3Qgc3RlbXMgZnJvbSB0aGUgbmV3IG5lZWQgdG8gcGFzcwp0aGUgb2JqZWN0 J3Mgb3duZXIgSUQgdG8gcmVjb3JkRXh0ZW5zaW9uSW5pdFByaXYsIHNvIHRoYXQgd2UgY2FuCmNv bnN1bHQgaXQgd2hpbGUgdXBkYXRpbmcgcGdfc2hkZXBlbmQuICBXaGlsZSBtYW55IGNhbGxlcnMg aGF2ZSB0aGF0CmF0IGhhbmQgYWxyZWFkeSwgYSBmZXcgcGxhY2VzIG5vdyBuZWVkIHRvIGZldGNo IHRoZSBvd25lciBJRCBvZiBhbgphcmJpdHJhcnkgcHJpdmlsZWdlLWJlYXJpbmcgb2JqZWN0LiAg Rm9yIHRoYXQsIHdlIGFzc3VtZSB0aGF0IHRoZXJlCmlzIGEgY2F0Y2FjaGUgb24gdGhlIHJlbGV2 YW50IGNhdGFsb2cncyBPSUQgY29sdW1uLCB3aGljaCBpcyBhbgphc3N1bXB0aW9uIGFscmVhZHkg bWFkZSBpbiBFeGVjR3JhbnRfY29tbW9uIHNvIGl0IHNlZW1zIG9rYXkgaGVyZS4KCldlIGRvIG5l ZWQgYW4gZW50aXJlbHkgbmV3IHJvdXRpbmUgUmVtb3ZlUm9sZUZyb21Jbml0UHJpdiB0byBwZXJm b3JtCmNsZWFudXAgb2YgcGdfaW5pdF9wcml2cyBBQ0xzIGR1cmluZyBEUk9QIE9XTkVEIEJZLiAg SXQncyBhbmFsb2dvdXMKdG8gUmVtb3ZlUm9sZUZyb21PYmplY3RBQ0wsIGJ1dCB3ZSBjYW4ndCBz aGFyZSBsb2dpYyBiZWNhdXNlIHRoYXQKZnVuY3Rpb24gb3BlcmF0ZXMgYnkgYnVpbGRpbmcgYSBj b21tYW5kIHBhcnNldHJlZSBhbmQgaW52b2tpbmcKZXhpc3RpbmcgR1JBTlQvUkVWT0tFIGluZnJh c3RydWN0dXJlLiAgVGhlcmUgaXMgb2YgY291cnNlIG5vIFNRTApjb21tYW5kIHRoYXQgd291bGQg dXBkYXRlIHBnX2luaXRfcHJpdnMgZW50cmllcyB3aGVuIHdlJ3JlIG5vdCBpbgpwcm9jZXNzIG9m IGNyZWF0aW5nIHRoZWlyIGV4dGVuc2lvbiwgc28gd2UgbmVlZCBhIHJvdXRpbmUgdGhhdCBjYW4K ZG8gdGhlIHVwZGF0ZXMgZGlyZWN0bHkuCgpjYXR2ZXJzaW9uIGJ1bXAgYmVjYXVzZSB0aGlzIGNo YW5nZXMgdGhlIGV4cGVjdGVkIGNvbnRlbnRzIG9mCnBnX3NoZGVwZW5kLiAgRm9yIHRoZSBzYW1l IHJlYXNvbiwgdGhlcmUncyBubyBob3BlIG9mIGJhY2stcGF0Y2hpbmcKdGhpcywgZXZlbiB0aG91 Z2ggaXQgZml4ZXMgYSBsb25nc3RhbmRpbmcgYnVnLiAgRm9ydHVuYXRlbHksIHRoZQpjYXNlIHdo ZXJlIGl0J3MgYSBwcm9ibGVtIHNlZW1zIHRvIGJlIG5lYXIgbm9uZXhpc3RlbnQgaW4gdGhlIGZp ZWxkLgpJZiBpdCB3ZXJlbid0IGZvciB0aGUgYnVpbGRmYXJtIGJyZWFrYWdlLCBJJ2QgaGF2ZSBi ZWVuIGNvbnRlbnQgdG8KbGVhdmUgdGhpcyBmb3IgdjE4LgoKUGF0Y2ggYnkgbWU7IHRoYW5rcyB0 byBEYW5pZWwgR3VzdGFmc3NvbiBmb3IgcmV2aWV3IGFuZCBkaXNjdXNzaW9uLgoKRGlzY3Vzc2lv bjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xNzQ1NTM1LjE3MTIzNTg2NTlAc3NzLnBnaC5wYS51cwoK QnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jl c3FsLm9yZy9wZy9jb21taXRkaWZmLzUzNDI4NzQwMzkxNGNjOTc2MGRiOThmNzMyMGFjNGU5MmY1 ZDQxNmUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jYXRhbG9n cy5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgIHwgIDE0ICsrCnNyYy9iYWNrZW5kL2NhdGFs b2cvYWNsY2hrLmMgICAgICAgICAgICAgICAgICAgICAgIHwgMjYyICsrKysrKysrKysrKysrKysr KystLQpzcmMvYmFja2VuZC9jYXRhbG9nL3BnX3NoZGVwZW5kLmMgICAgICAgICAgICAgICAgICB8 ICA1NiArKysrLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNpb24uaCAgICAgICAgICAgICAg ICAgICB8ICAgMiArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2RlcGVuZGVuY3kuaCAgICAgICAgICAg ICAgICAgICB8ICAxNiArLQpzcmMvaW5jbHVkZS91dGlscy9hY2wuaCAgICAgICAgICAgICAgICAg ICAgICAgICAgICB8ICAgMiArCi4uLi9tb2R1bGVzL3Rlc3RfcGdfZHVtcC9leHBlY3RlZC90ZXN0 X3BnX2R1bXAub3V0IHwgMTgzICsrKysrKysrKysrKysrCnNyYy90ZXN0L21vZHVsZXMvdGVzdF9w Z19kdW1wL3NxbC90ZXN0X3BnX2R1bXAuc3FsIHwgIDM3ICsrKwo4IGZpbGVzIGNoYW5nZWQsIDU0 OSBpbnNlcnRpb25zKCspLCAyMyBkZWxldGlvbnMoLSkKCg== --===============6181560099800107563==--