Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oOjHU-0000RQ-8a for pgsql-committers@arkaria.postgresql.org; Thu, 18 Aug 2022 17:26:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oOjHS-0000YK-Th for pgsql-committers@arkaria.postgresql.org; Thu, 18 Aug 2022 17:26:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oOjHS-0000YB-Lg for pgsql-committers@lists.postgresql.org; Thu, 18 Aug 2022 17:26:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oOjHQ-0002Ay-Bo for pgsql-committers@lists.postgresql.org; Thu, 18 Aug 2022 17:26:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=C6Dva5eJURpV4n8MP+9cE7YMLzXw9xCqDLHOMVPK4Ec=; b=h1v57gYKexLlaTBR1/vaFXDOCL JRCSxpDQYdSH6ePjiMvfLA/S5Wv6QLDChfYDzTyUkaB9V84onrq77G+BQJ743Yf5z/9K5hPuLoD4v pYLsiRPkEpJMJn3LS3W9bPK7YhosIb+pGshlyuoFc1ZBmpuTjTTUj+KRnSCB17uxx5UrWhXbApuEg J2C0mkenU4SJTHuxHxZH9dkUBCVUdLEL2NsS2Owp0sTE7tfNpY8SUEil4nvl/pGImxa3XvVNdMPJN BOJCPsFGBq4Vzdf3mK8KFDV4DxfdPBC2cLYlUaB1uUL9IIDstPtGBhl+buzwyr/s0e+odRePu/j6C WJxFbuXA==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oOjHQ-0006Ff-0H for pgsql-committers@lists.postgresql.org; Thu, 18 Aug 2022 17:26:04 +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 1oOjHN-00092c-RO for pgsql-committers@lists.postgresql.org; Thu, 18 Aug 2022 17:26:02 +0000 Content-Type: multipart/mixed; boundary="===============7218599493111364836==" MIME-Version: 1.0 From: Robert Haas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Ensure that pg_auth_members.grantor is always valid. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 18 Aug 2022 17:26:02 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7218599493111364836== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RW5zdXJlIHRoYXQgcGdfYXV0aF9tZW1iZXJzLmdyYW50b3IgaXMgYWx3YXlzIHZhbGlkLgoKUHJl dmlvdXNseSwgIkdSQU5UIGZvbyBUTyBiYXIiIG9yICJHUkFOVCBmb28gVE8gYmFyIEdSQU5URUQg QlkgYmF6Igp3b3VsZCByZWNvcmQgdGhlIE9JRCBvZiB0aGUgZ3JhbnRvciBpbiBwZ19hdXRoX21l bWJlcnMuZ3JhbnRvciwgYnV0CnRoYXQgcm9sZSBjb3VsZCBsYXRlciBiZSBkcm9wcGVkIHdpdGhv dXQgbW9kaWZ5aW5nIG9yIHJlbW92aW5nIHRoZQpwZ19hdXRoX21lbWJlcnMgcmVjb3JkLiBUaGF0 J3Mgbm90IGdyZWF0LCBiZWNhdXNlIHdlIHR5cGljYWxseSB0cnkKdG8gYXZvaWQgZGFuZ2xpbmcg cmVmZXJlbmNlcyBpbiBjYXRhbG9nIGRhdGEuCgpOb3csIGEgcm9sZSBncmFudCBkZXBlbmRzIG9u IHRoZSBncmFudG9yLCBhbmQgdGhlIGdyYW50b3IgY2FuJ3QgYmUKZHJvcHBlZCB3aXRob3V0IHJl bW92aW5nIHRoZSBncmFudCBvciBjaGFuZ2luZyB0aGUgZ3JhbnRvci4gICJEUk9QCk9XTkVEIEJZ IiB3aWxsIHJlbW92ZSB0aGUgZ3JhbnQsIGp1c3QgYXMgaXQgZG9lcyBmb3Igb3RoZXIga2luZHMg b2YKcHJpdmlsZWdlcy4gIlJFQVNTSUdOIE9XTkVEIEJZIiB3aWxsIG5vdCwgYWdhaW4ganVzdCBs aWtlIHdoYXQgd2UgZG8KaW4gb3RoZXIgY2FzZXMgaW52b2x2aW5nIHByaXZpbGVnZXMuCgpwZ19h dXRoX21lbWJlcnMgbm93IGhhcyBhbiBPSUQgY29sdW1uLCBiZWNhdXNlIHRoYXQgaXMgbmVlZGVk IGluIG9yZGVyCmZvciBkZXBlbmRlbmNpZXMgdG8gd29yay4gSXQgYWxzbyBub3cgaGFzIGFuIGlu ZGV4IG9uIHRoZSBncmFudG9yCmNvbHVtbiwgYmVjYXVzZSBvdGhlcndpc2UgZHJvcHBpbmcgYSBy b2xlIHdvdWxkIHJlcXVpcmUgYSBzZXF1ZW50aWFsCnNjYW4gb2YgdGhlIGVudGlyZSB0YWJsZSB0 byBzZWUgd2hldGhlciB0aGUgcm9sZSdzIE9JRCBpcyBpbiB1c2UgYXMKYSBncmFudG9yLiBUaGF0 IHByb2JhYmx5IHdvdWxkbid0IGJlIHRvbyBsYXJnZSBhIHByb2JsZW0gaW4gcHJhY3RpY2UsCmJ1 dCBpdCBzZWVtcyBiZXR0ZXIgdG8gaGF2ZSBhbiBpbmRleCBqdXN0IGluIGNhc2UuCgpBIGZvbGxv dy1vbiBwYXRjaCBpcyBwbGFubmVkIHdpdGggdGhlIGdvYWwgb2YgbW9yZSB0aG9yb3VnaGx5CnJh dGlvbmFsaXppbmcgdGhlIGJlaGF2aW9yIG9mIHJvbGUgZ3JhbnRzLiBUaGlzIHBhdGNoIGlzIGp1 c3QgdHJ5aW5nCnRvIGRvIGVub3VnaCB0byBtYWtlIHN1cmUgdGhhdCB0aGUgZGF0YSB3ZSBzdG9y ZSBpbiB0aGUgY2F0YWxvZ3MgaXMgYXQKc29tZSBiYXNpYyBsZXZlbCB2YWxpZC4KClBhdGNoIGJ5 IG1lLCByZXZpZXdlZCBieSBTdGVwaGVuIEZyb3N0CgpEaXNjdXNzaW9uOiBodHRwOi8vcG9zdGdy LmVzL20vQ0ErVGdtb2FGci1SWmVRK1dvUTVuS1B2OTdvVDkrYURnS19hNStxV0hTZ2JEc01wMVZn QG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0 dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNjU2NjEzM2M1ZjUyNzcxMTk4 YWNhMDdlZDE4Zjg0NTE5ZmFjMWJlNwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9j L3NyYy9zZ21sL2NhdGFsb2dzLnNnbWwgICAgICAgICAgICAgICAgfCAgIDkgKysKc3JjL2JhY2tl bmQvY2F0YWxvZy9jYXRhbG9nLmMgICAgICAgICAgICAgfCAgIDIgKwpzcmMvYmFja2VuZC9jYXRh bG9nL2RlcGVuZGVuY3kuYyAgICAgICAgICB8ICAxNCArKy0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9v YmplY3RhZGRyZXNzLmMgICAgICAgfCAxMDggKysrKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQv Y2F0YWxvZy9wZ19zaGRlcGVuZC5jICAgICAgICAgfCAgNDcgKysrKystLS0Kc3JjL2JhY2tlbmQv Y2F0YWxvZy9zeXN0ZW1fdmlld3Muc3FsICAgICAgfCAgIDIgKy0Kc3JjL2JhY2tlbmQvY29tbWFu ZHMvYWx0ZXIuYyAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9jb21tYW5kcy9ldmVu dF90cmlnZ2VyLmMgICAgICB8ICAgMSArCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5j ICAgICAgICAgIHwgICAxICsKc3JjL2JhY2tlbmQvY29tbWFuZHMvdXNlci5jICAgICAgICAgICAg ICAgfCAxOTIgKysrKysrKysrKysrKysrKysrKysrKystLS0tLS0tCnNyYy9pbmNsdWRlL2NhdGFs b2cvZGVwZW5kZW5jeS5oICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19h dXRoX21lbWJlcnMuaCAgICAgfCAgIDUgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jcmVh dGVfcm9sZS5vdXQgfCAgMTYgKystCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcHJpdmlsZWdl cy5vdXQgIHwgIDMyICsrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NyZWF0ZV9yb2xlLnNxbCAg ICAgIHwgICA3ICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3ByaXZpbGVnZXMuc3FsICAgICAgIHwg IDI3ICsrKysrCjE2IGZpbGVzIGNoYW5nZWQsIDM5NyBpbnNlcnRpb25zKCspLCA2OCBkZWxldGlv bnMoLSkKCg== --===============7218599493111364836==--