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.96) (envelope-from ) id 1vx5va-00F7xL-32 for pgsql-committers@arkaria.postgresql.org; Mon, 02 Mar 2026 16:15:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vx5vZ-001kcl-10 for pgsql-committers@arkaria.postgresql.org; Mon, 02 Mar 2026 16:15:25 +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.96) (envelope-from ) id 1vx5vZ-001kcc-0M for pgsql-committers@lists.postgresql.org; Mon, 02 Mar 2026 16:15:25 +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.98.2) (envelope-from ) id 1vx5vX-000000002aY-2J9b for pgsql-committers@lists.postgresql.org; Mon, 02 Mar 2026 16:15:24 +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.96) (envelope-from ) id 1vx5vX-005tWl-0y for pgsql-committers@lists.postgresql.org; Mon, 02 Mar 2026 16:15:23 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vx5vW-0021ET-3B for pgsql-committers@lists.postgresql.org; Mon, 02 Mar 2026 16:15:22 +0000 Content-Type: multipart/mixed; boundary="===============0875414703876107266==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: In pg_dumpall, don't skip role GRANTs with dangling grantor OIDs X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 02 Mar 2026 16:15:22 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0875414703876107266== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW4gcGdfZHVtcGFsbCwgZG9uJ3Qgc2tpcCByb2xlIEdSQU5UcyB3aXRoIGRhbmdsaW5nIGdyYW50 b3IgT0lEcy4KCkluIGNvbW1pdHMgMjlkNzViMjViIGV0IGFsLCBJIG1hZGUgcGdfZHVtcGFsbCdz IGR1bXBSb2xlTWVtYmVyc2hpcApsb2dpYyB0cmVhdCBhIGRhbmdsaW5nIGdyYW50b3IgT0lEIHRo ZSBzYW1lIGFzIGRhbmdsaW5nIHJvbGUgYW5kCm1lbWJlciBPSURzOiBwcmludCBhIHdhcm5pbmcg YW5kIHNraXAgZW1pdHRpbmcgdGhlIEdSQU5ULiAgVGhpcyB3YXNuJ3QKdGVycmlibHkgd2VsbCB0 aG91Z2h0IG91dDsgaW5zdGVhZCwgd2Ugc2hvdWxkIGhhbmRsZSB0aGUgY2FzZSBieQplbWl0dGlu ZyB0aGUgR1JBTlQgd2l0aG91dCB0aGUgR1JBTlRFRCBCWSBjbGF1c2UuICBXaGVuIHRoZSBzb3Vy Y2UKZGF0YWJhc2UgaXMgcHJlLXYxNiwgc3VjaCBjYXNlcyBhcmUgc29tZXdoYXQgZXhwZWN0ZWQg YmVjYXVzZSB0aG9zZQp2ZXJzaW9ucyBkaWRuJ3QgcHJldmVudCBkcm9wcGluZyB0aGUgZ3JhbnRv ciByb2xlOyBzbyBkb24ndCBldmVuCnByaW50IGEgd2FybmluZyB0aGF0IHdlIGRpZCB0aGlzLiAg KFRoaXMgY2hhbmdlIHRoZXJlZm9yZSByZXN0b3JlcwpwZ19kdW1wYWxsJ3MgcHJlLXYxNiBiZWhh dmlvciBmb3IgdGhlc2UgY2FzZXMuKSAgVGhlIGNhc2UgaXMgbm90CmV4cGVjdGVkIGluID49IHYx Niwgc28gdGhlbiB3ZSBkbyBwcmludCBhIHdhcm5pbmcsIGJ1dCBzb2xkaWVyaW5nIG9uCndpdGgg bm8gR1JBTlRFRCBCWSBjbGF1c2Ugc3RpbGwgc2VlbXMgbGlrZSBhIHJlYXNvbmFibGUgc3RyYXRl Z3kuCgpQZXIgY29tcGxhaW50IGZyb20gUm9iZXJ0IEhhYXMgdGhhdCB3ZSB3ZXJlIG5vdyBkcm9w cGluZyBHUkFOVHMKYWx0b2dldGhlciBpbiBlYXNpbHktcmVhY2hhYmxlIHNjZW5hcmlvcy4KClJl cG9ydGVkLWJ5OiBSb2JlcnQgSGFhcyA8cm9iZXJ0bWhhYXNAZ21haWwuY29tPgpBdXRob3I6IFRv bSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51cz4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMv bS9DQStUZ21vYXVvaVc0eWREaGRyc2VnK0RENEt3aGE9K1RTWnAxOEJySmVIS3gzbzFGZHdAbWFp bC5nbWFpbC5jb20KQmFja3BhdGNoLXRocm91Z2g6IDE2CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv NzRiNDQzOGE3MGI5YTJlYTY1NDUwMWNlMDYxYWU3ZGVhMWU2YTJlYQoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXBhbGwuYyB8IDQ5ICsrKysrKysr KysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tLS0tLS0tCjEgZmlsZSBjaGFuZ2VkLCAzMCBp bnNlcnRpb25zKCspLCAxOSBkZWxldGlvbnMoLSkKCg== --===============0875414703876107266==--