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 1vx5vf-00F82V-2b for pgsql-committers@arkaria.postgresql.org; Mon, 02 Mar 2026 16:15:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vx5ve-001lNl-0v for pgsql-committers@arkaria.postgresql.org; Mon, 02 Mar 2026 16:15:30 +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.96) (envelope-from ) id 1vx5ve-001lNQ-0E for pgsql-committers@lists.postgresql.org; Mon, 02 Mar 2026 16:15:30 +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.98.2) (envelope-from ) id 1vx5vZ-000000002W9-1Nse for pgsql-committers@lists.postgresql.org; Mon, 02 Mar 2026 16:15:30 +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 1vx5vY-005tWm-0J for pgsql-committers@lists.postgresql.org; Mon, 02 Mar 2026 16:15:24 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vx5vX-0021EV-01 for pgsql-committers@lists.postgresql.org; Mon, 02 Mar 2026 16:15:23 +0000 Content-Type: multipart/mixed; boundary="===============7361791678897756909==" 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:23 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7361791678897756909== 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 bC5nbWFpbC5jb20KQmFja3BhdGNoLXRocm91Z2g6IDE2CgpCcmFuY2gKLS0tLS0tClJFTF8xOF9T VEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21t aXRkaWZmL2IwOTE1OGNjNzc2YzQ4ZTU1MTExM2UxYTU3OWMxYzk4MmQ5NjhjMmYKCk1vZGlmaWVk IEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iaW4vcGdfZHVtcC9wZ19kdW1wYWxsLmMgfCA0OSAr KysrKysrKysrKysrKysrKysrKysrKysrKystLS0tLS0tLS0tLS0tLS0tLQoxIGZpbGUgY2hhbmdl ZCwgMzAgaW5zZXJ0aW9ucygrKSwgMTkgZGVsZXRpb25zKC0pCgo= --===============7361791678897756909==--