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 1sJFjR-003nPf-Oq for pgsql-committers@arkaria.postgresql.org; Mon, 17 Jun 2024 17:01:25 +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 1sJFjP-001k62-J4 for pgsql-committers@arkaria.postgresql.org; Mon, 17 Jun 2024 17:01:24 +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 1sJFjB-001hZm-3h for pgsql-committers@lists.postgresql.org; Mon, 17 Jun 2024 17:01: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 1sJFj7-0029Q0-Dw for pgsql-committers@lists.postgresql.org; Mon, 17 Jun 2024 17:01:09 +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 1sJFj5-005g8X-6z for pgsql-committers@lists.postgresql.org; Mon, 17 Jun 2024 17:01:03 +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 1sJFj3-001uaA-Kt for pgsql-committers@lists.postgresql.org; Mon, 17 Jun 2024 17:01:02 +0000 Content-Type: multipart/mixed; boundary="===============5288407774058267527==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve tracking of role dependencies of pg_init_privs entries. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 17 Jun 2024 17:01:02 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5288407774058267527== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSB0cmFja2luZyBvZiByb2xlIGRlcGVuZGVuY2llcyBvZiBwZ19pbml0X3ByaXZzIGVu dHJpZXMuCgpDb21taXQgNTM0Mjg3NDAzIGludmVudGVkIFNIQVJFRF9ERVBFTkRFTkNZX0lOSVRB Q0wgZW50cmllcyBpbgpwZ19zaGRlcGVuZCwgYnV0IGluc3RhbGxlZCB0aGVtIG9ubHkgZm9yIG5v bi1vd25lciByb2xlcyBtZW50aW9uZWQKaW4gYSBwZ19pbml0X3ByaXZzIGVudHJ5LiAgVGhpcyB0 dXJucyBvdXQgdG8gYmUgdGhlIHdyb25nIHRoaW5nLApiZWNhdXNlIHRoZXJlIGlzIG5vdGhpbmcg dG8gY3VlIFJFQVNTSUdOIE9XTkVEIHRvIGdvIGFuZCB1cGRhdGUKcGdfaW5pdF9wcml2cyBlbnRy aWVzIHdoZW4gdGhlIG9iamVjdCdzIG93bmVyc2hpcCBpcyByZWFzc2lnbmVkLgpUaGF0IGxlYWRz IHRvIGxlYXZpbmcgZGFuZ2xpbmcgZW50cmllcyBpbiBwZ19pbml0X3ByaXZzLCBhcwpyZXBvcnRl ZCBieSBIYW5udSBLcm9zaW5nLiAgSW5zdGVhZCwgaW5zdGFsbCBJTklUQUNMIGVudHJpZXMgZm9y CmFsbCByb2xlcyBtZW50aW9uZWQgaW4gcGdfaW5pdF9wcml2cyBlbnRyaWVzIChleGNlcHQgcGlu bmVkIHJvbGVzKSwKYW5kIGNoYW5nZSBBTFRFUiBPV05FUiB0byBub3QgdG91Y2ggdGhlbSwganVz dCBhcyBpdCBkb2Vzbid0CnRvdWNoIHBnX2luaXRfcHJpdnMgZW50cmllcy4KClJFQVNTSUdOIE9X TkVEIHdpbGwgbm93IHN1YnN0aXR1dGUgdGhlIG5ldyBvd25lciBPSUQgZm9yIHRoZSBvbGQKaW4g cGdfaW5pdF9wcml2cyBlbnRyaWVzLiAgVGhpcyBmZWVscyBsaWtlIHBlcmhhcHMgbm90IHF1aXRl IHRoZQpyaWdodCB0aGluZywgc2luY2UgcGdfaW5pdF9wcml2cyBvdWdodCB0byBiZSBhIGhpc3Rv cmljYWwgcmVjb3JkCm9mIHRoZSBzdGF0ZSBvZiBhZmZhaXJzIGp1c3QgYWZ0ZXIgQ1JFQVRFIEVY VEVOU0lPTi4gIEhvd2V2ZXIsCml0J3MgaGFyZCB0byBzZWUgd2hhdCBlbHNlIHRvIGRvLCBpZiB3 ZSBkb24ndCB3YW50IHRvIGRpc2FsbG93CmRyb3BwaW5nIHRoZSBvYmplY3QncyBvcmlnaW5hbCBv d25lci4gIEluIGFueSBjYXNlIHRoaXMgaXMKYmV0dGVyIHRoYW4gdGhlIHByZXZpb3VzIGRvLW5v dGhpbmcgYmVoYXZpb3IsIGFuZCB3ZSdyZSB1bmxpa2VseQp0byBjb21lIHVwIHdpdGggYSBzdXBl cmlvciBzb2x1dGlvbiBpbiB0aW1lIGZvciB2MTcuCgpXaGlsZSBoZXJlLCB0aWdodGVuIHVwIHNv bWUgY29kaW5nIHJ1bGVzIGFib3V0IGhvdyBBQ0xzIGluCnBnX2luaXRfcHJpdnMgc2hvdWxkIG5l dmVyIGJlIG51bGwgb3IgZW1wdHkuICBUaGVyZSdzIG5vdCBhbnkKb2J2aW91cyByZWFzb24gdG8g YWxsb3cgdGhhdCwgYW5kIHBlcmhhcHMgYXNzZXJ0aW5nIHRoYXQgaXQncwpub3Qgc28gd2lsbCBj YXRjaCBzb21lIGJ1Z3MuICAoV2Ugd2VyZSBwcmV2aW91c2x5IGluY29uc2lzdGVudApvbiB0aGUg cG9pbnQsIHdpdGggc29tZSBjb2RlIHBhdGhzIHRha2luZyBjYXJlIG5vdCB0byBzdG9yZQplbXB0 eSBBQ0xzIGFuZCBvdGhlcnMgbm90LikKClRoaXMgbGVhdmVzIHJlY29yZEV4dGVuc2lvbkluaXRQ cml2V29ya2VyIG5vdCBkb2luZyBhbnl0aGluZwp3aXRoIGl0cyBvd25lcklkIGFyZ3VtZW50LCBi dXQgd2UnbGwgZGVhbCB3aXRoIHRoYXQgc2VwYXJhdGVseS4KCmNhdHZlcnNpb24gYnVtcCBmb3Jj ZWQgYmVjYXVzZSBvZiBjaGFuZ2Ugb2YgZXhwZWN0ZWQgY29udGVudHMKb2YgcGdfc2hkZXBlbmQg d2hlbiBwZ19pbml0X3ByaXZzIGVudHJpZXMgZXhpc3QuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bv c3Rnci5lcy9tL0NBTVQwUlFTVmd2NDhHNUdBclV2T1Zob3R0V3FaTHJ2QzV3QnpCYTRIclVkWGU5 VlJYd0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0t LQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzM1ZGQ0MGQzNGNiZGY1 YWEzZTBmNWIzNDkzYzMzZDAwYWJiMjY0NTYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0t CmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAz IC0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9hY2xjaGsuYyAgICAgICAgICAgICAgICAgICAgICAgfCAx MzAgKysrKysrKystCnNyYy9iYWNrZW5kL2NhdGFsb2cvcGdfc2hkZXBlbmQuYyAgICAgICAgICAg ICAgICAgIHwgMjQ5ICsrKysrKysrKysrLS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9hY2wu YyAgICAgICAgICAgICAgICAgICAgICAgIHwgICA2ICsKc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2 ZXJzaW9uLmggICAgICAgICAgICAgICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9k ZXBlbmRlbmN5LmggICAgICAgICAgICAgICAgICAgfCAgIDkgKy0Kc3JjL2luY2x1ZGUvdXRpbHMv YWNsLmggICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDIgKwouLi4vbW9kdWxlcy90ZXN0 X3BnX2R1bXAvZXhwZWN0ZWQvdGVzdF9wZ19kdW1wLm91dCB8IDMwNSArKysrKysrKysrKysrKysr KysrKysKc3JjL3Rlc3QvbW9kdWxlcy90ZXN0X3BnX2R1bXAvc3FsL3Rlc3RfcGdfZHVtcC5zcWwg fCAgNzEgKysrKysKOSBmaWxlcyBjaGFuZ2VkLCA2NjYgaW5zZXJ0aW9ucygrKSwgMTExIGRlbGV0 aW9ucygtKQoK --===============5288407774058267527==--