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 1ltzBH-000202-VB for pgsql-bugs@arkaria.postgresql.org; Thu, 17 Jun 2021 21:04: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 1ltzBG-0008Js-LF for pgsql-bugs@arkaria.postgresql.org; Thu, 17 Jun 2021 21:04: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 1ltyiH-0005fd-L0 for pgsql-bugs@lists.postgresql.org; Thu, 17 Jun 2021 20:34:09 +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 1ltyiC-0006fA-Vt for pgsql-bugs@lists.postgresql.org; Thu, 17 Jun 2021 20:34:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=3H6DYMiCDJogYbrW4AIf4PlIz6c4qNiXTWopw22+5bw=; b=ZTMeWQHKrJK9Jwdc2nj78DETJ7 A2pun51sBmYUK0Hza8726yfikn2qAPEOsulxQFOnuEpQZ3aYcHmMXv6BTRbAG2L0SgA8DVgRHJwxY qiJV61HB08F9U+DUKx1YNjj38NkO9YLHsWlBvjTi86IfACs9s1HWRRAQSxUXGlIFKfqPnV0xzAjHn TfcKDB8RXWcBirWE9+vAMtF45zZXxo14tFIxTET6bv1KzQ1eMfOnuqpGR8fIfcYgPcyP4WBt+mt1b oG77x8UusI2ZGeNSL/CtjtuXpMD4Ckc94Mpl9woRHiQBDWqHTrWPZB638d1FtZQ4a+X+qvG4dD7Oj mJmthpsQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltyiC-0007Cu-Fn for pgsql-bugs@lists.postgresql.org; Thu, 17 Jun 2021 20:34:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltyiA-00035V-Er for pgsql-bugs@lists.postgresql.org; Thu, 17 Jun 2021 20:34:02 +0000 Content-Type: multipart/mixed; boundary="===============8904915192124644864==" MIME-Version: 1.0 Subject: BUG #17062: Assert failed in RemoveRoleFromObjectPolicy() on DROP OWNED policy applied to duplicate role To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 17 Jun 2021 20:33:46 +0000 Message-ID: <17062-11f471ae3199ca23@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8904915192124644864== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzA2MgpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTRiZXRhMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNApEZXNjcmlwdGlvbjog ICAgICAgIAoKV2hlbiBleGVjdXRpbmcgdGhlIGZvbGxvd2luZyBxdWVyeToNCkNSRUFURSBVU0VS IHJvbGUxOw0KQ1JFQVRFIFRBQkxFIHQxKGlkIGludCk7DQpDUkVBVEUgUE9MSUNZIHAxIE9OIHQx IFRPIHJvbGUxLHJvbGUxIFVTSU5HICh0cnVlKTsNCkRST1AgT1dORUQgQlkgcm9sZTE7DQoNClRo ZSBzZXJ2ZXIgaGFsdHMgd2l0aCB0aGUgZmFpbGVkIGFzc2VydGlvbjoNCkNvcmUgd2FzIGdlbmVy YXRlZCBieSBgcG9zdGdyZXM6IGxhdyByZWdyZXNzaW9uIFtsb2NhbF0gRFJPUCBPV05FRCAgICAg ICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgJy4NClByb2dyYW0gdGVybWluYXRlZCB3aXRo IHNpZ25hbCBTSUdBQlJULCBBYm9ydGVkLg0KIzAgIF9fR0lfcmFpc2UgKHNpZz1zaWdAZW50cnk9 NikgYXQgLi4vc3lzZGVwcy91bml4L3N5c3YvbGludXgvcmFpc2UuYzo1MA0KNTAgICAgICAuLi9z eXNkZXBzL3VuaXgvc3lzdi9saW51eC9yYWlzZS5jOiBObyBzdWNoIGZpbGUgb3IgZGlyZWN0b3J5 Lg0KKGdkYikgYnQNCiMwICBfX0dJX3JhaXNlIChzaWc9c2lnQGVudHJ5PTYpIGF0IC4uL3N5c2Rl cHMvdW5peC9zeXN2L2xpbnV4L3JhaXNlLmM6NTANCiMxICAweDAwMDA3ZjA5YjlmMzE4NTkgaW4g X19HSV9hYm9ydCAoKSBhdCBhYm9ydC5jOjc5DQojMiAgMHgwMDAwNTYwYmZhNTkyMzRhIGluIEV4 Y2VwdGlvbmFsQ29uZGl0aW9uCihjb25kaXRpb25OYW1lPWNvbmRpdGlvbk5hbWVAZW50cnk9MHg1 NjBiZmE2Y2FmOTYgImogPT0gbnVtX3JvbGVzIiwgDQogICAgZXJyb3JUeXBlPWVycm9yVHlwZUBl bnRyeT0weDU2MGJmYTVmMTAwYiAiRmFpbGVkQXNzZXJ0aW9uIiwKZmlsZU5hbWU9MHg3ZmZkYzg0 ZjUwMjAgIisjWVwzNzJcdlYiLCANCiAgICBmaWxlTmFtZUBlbnRyeT0weDU2MGJmYTZjYWYyMSAi cG9saWN5LmMiLApsaW5lTnVtYmVyPWxpbmVOdW1iZXJAZW50cnk9NTkzKSBhdCBhc3NlcnQuYzo2 OQ0KIzMgIDB4MDAwMDU2MGJmYTIzYzgzZiBpbiBSZW1vdmVSb2xlRnJvbU9iamVjdFBvbGljeQoo cm9sZWlkPXJvbGVpZEBlbnRyeT0xNjM4NSwgY2xhc3NpZD08b3B0aW1pemVkIG91dD4sIA0KICAg IHBvbGljeV9pZD0xNjM4OSkgYXQgcG9saWN5LmM6NTkzDQojNCAgMHgwMDAwNTYwYmZhMWE0M2Vj IGluIHNoZGVwRHJvcE93bmVkCihyb2xlaWRzPXJvbGVpZHNAZW50cnk9MHg1NjBiZmIzZDk4Nzgs IGJlaGF2aW9yPURST1BfUkVTVFJJQ1QpDQogICAgYXQgcGdfc2hkZXBlbmQuYzoxNDIwDQojNSAg MHgwMDAwNTYwYmZhMjg0OWNmIGluIERyb3BPd25lZE9iamVjdHMgKHN0bXQ9c3RtdEBlbnRyeT0w eDU2MGJmYjNiODEzOCkKYXQgdXNlci5jOjEzOTANCiM2ICAweDAwMDA1NjBiZmE0NWU1OTEgaW4g UHJvY2Vzc1V0aWxpdHlTbG93Cihwc3RhdGU9cHN0YXRlQGVudHJ5PTB4NTYwYmZiM2Q5NzYwLCBw c3RtdD1wc3RtdEBlbnRyeT0weDU2MGJmYjNiODQ0OCwgDQogICAgcXVlcnlTdHJpbmc9cXVlcnlT dHJpbmdAZW50cnk9MHg1NjBiZmIzYjc2OTAgIkRST1AgT1dORUQgQlkgcm9sZTE7IiwgDQogICAg Y29udGV4dD1jb250ZXh0QGVudHJ5PVBST0NFU1NfVVRJTElUWV9UT1BMRVZFTCwgcGFyYW1zPXBh cmFtc0BlbnRyeT0weDAsCnF1ZXJ5RW52PXF1ZXJ5RW52QGVudHJ5PTB4MCwgDQogICAgZGVzdD0w eDU2MGJmYjNiODUxOCwgcWM9MHg3ZmZkYzg0ZjViYjApIGF0IHV0aWxpdHkuYzoxNzYxDQojNyAg MHgwMDAwNTYwYmZhNDVkMmYwIGluIHN0YW5kYXJkX1Byb2Nlc3NVdGlsaXR5IChwc3RtdD0weDU2 MGJmYjNiODQ0OCwgDQogICAgcXVlcnlTdHJpbmc9MHg1NjBiZmIzYjc2OTAgIkRST1AgT1dORUQg Qlkgcm9sZTE7IiwKY29udGV4dD1QUk9DRVNTX1VUSUxJVFlfVE9QTEVWRUwsIHBhcmFtcz0weDAs IHF1ZXJ5RW52PTB4MCwgDQogICAgZGVzdD0weDU2MGJmYjNiODUxOCwgcWM9MHg3ZmZkYzg0ZjVi YjApIGF0IHV0aWxpdHkuYzoxMDM0DQojOCAgMHgwMDAwNTYwYmZhNDVkM2NmIGluIFByb2Nlc3NV dGlsaXR5IChwc3RtdD1wc3RtdEBlbnRyeT0weDU2MGJmYjNiODQ0OCwKcXVlcnlTdHJpbmc9PG9w dGltaXplZCBvdXQ+LCANCiAgICBjb250ZXh0PWNvbnRleHRAZW50cnk9UFJPQ0VTU19VVElMSVRZ X1RPUExFVkVMLCBwYXJhbXM9PG9wdGltaXplZCBvdXQ+LApxdWVyeUVudj08b3B0aW1pemVkIG91 dD4sIA0KICAgIGRlc3Q9ZGVzdEBlbnRyeT0weDU2MGJmYjNiODUxOCwgcWM9MHg3ZmZkYzg0ZjVi YjApIGF0IHV0aWxpdHkuYzo1MjUNCiM5ICAweDAwMDA1NjBiZmE0NWE5MWMgaW4gUG9ydGFsUnVu VXRpbGl0eQoocG9ydGFsPXBvcnRhbEBlbnRyeT0weDU2MGJmYjQyNWY3MCwgcHN0bXQ9cHN0bXRA ZW50cnk9MHg1NjBiZmIzYjg0NDgsIA0KICAgIGlzVG9wTGV2ZWw9aXNUb3BMZXZlbEBlbnRyeT10 cnVlLApzZXRIb2xkU25hcHNob3Q9c2V0SG9sZFNuYXBzaG90QGVudHJ5PWZhbHNlLCBkZXN0PWRl c3RAZW50cnk9MHg1NjBiZmIzYjg1MTgsCg0KICAgIHFjPXFjQGVudHJ5PTB4N2ZmZGM4NGY1YmIw KSBhdCBwcXVlcnkuYzoxMTQ3DQojMTAgMHgwMDAwNTYwYmZhNDVhYzFiIGluIFBvcnRhbFJ1bk11 bHRpCihwb3J0YWw9cG9ydGFsQGVudHJ5PTB4NTYwYmZiNDI1ZjcwLCBpc1RvcExldmVsPWlzVG9w TGV2ZWxAZW50cnk9dHJ1ZSwgDQogICAgc2V0SG9sZFNuYXBzaG90PXNldEhvbGRTbmFwc2hvdEBl bnRyeT1mYWxzZSwKZGVzdD1kZXN0QGVudHJ5PTB4NTYwYmZiM2I4NTE4LCBhbHRkZXN0PWFsdGRl c3RAZW50cnk9MHg1NjBiZmIzYjg1MTgsIA0KICAgIHFjPXFjQGVudHJ5PTB4N2ZmZGM4NGY1YmIw KSBhdCBwcXVlcnkuYzoxMzAzDQojMTEgMHgwMDAwNTYwYmZhNDViMDRmIGluIFBvcnRhbFJ1biAo cG9ydGFsPXBvcnRhbEBlbnRyeT0weDU2MGJmYjQyNWY3MCwKY291bnQ9Y291bnRAZW50cnk9OTIy MzM3MjAzNjg1NDc3NTgwNywgDQogICAgaXNUb3BMZXZlbD1pc1RvcExldmVsQGVudHJ5PXRydWUs IHJ1bl9vbmNlPXJ1bl9vbmNlQGVudHJ5PXRydWUsCmRlc3Q9ZGVzdEBlbnRyeT0weDU2MGJmYjNi ODUxOCwgDQogICAgYWx0ZGVzdD1hbHRkZXN0QGVudHJ5PTB4NTYwYmZiM2I4NTE4LCBxYz0weDdm ZmRjODRmNWJiMCkgYXQKcHF1ZXJ5LmM6Nzg2DQojMTIgMHgwMDAwNTYwYmZhNDU3MmE1IGluIGV4 ZWNfc2ltcGxlX3F1ZXJ5CihxdWVyeV9zdHJpbmc9cXVlcnlfc3RyaW5nQGVudHJ5PTB4NTYwYmZi M2I3NjkwICJEUk9QIE9XTkVEIEJZIHJvbGUxOyIpDQogICAgYXQgcG9zdGdyZXMuYzoxMjE0DQoj MTMgMHgwMDAwNTYwYmZhNDU5Mjc3IGluIFBvc3RncmVzTWFpbiAoYXJnYz1hcmdjQGVudHJ5PTEs CmFyZ3Y9YXJndkBlbnRyeT0weDdmZmRjODRmNWRhMCwgZGJuYW1lPTxvcHRpbWl6ZWQgb3V0Piwg DQogICAgdXNlcm5hbWU9PG9wdGltaXplZCBvdXQ+KSBhdCBwb3N0Z3Jlcy5jOjQ0ODYNCiMxNCAw eDAwMDA1NjBiZmEzYjQxYjQgaW4gQmFja2VuZFJ1biAocG9ydD1wb3J0QGVudHJ5PTB4NTYwYmZi M2RhYWUwKSBhdApwb3N0bWFzdGVyLmM6NDUwNw0KIzE1IDB4MDAwMDU2MGJmYTNiNzNjOSBpbiBC YWNrZW5kU3RhcnR1cCAocG9ydD1wb3J0QGVudHJ5PTB4NTYwYmZiM2RhYWUwKSBhdApwb3N0bWFz dGVyLmM6NDIyOQ0KIzE2IDB4MDAwMDU2MGJmYTNiNzYxMCBpbiBTZXJ2ZXJMb29wICgpIGF0IHBv c3RtYXN0ZXIuYzoxNzQ1DQojMTcgMHgwMDAwNTYwYmZhM2I4YjVkIGluIFBvc3RtYXN0ZXJNYWlu IChhcmdjPTMsIGFyZ3Y9PG9wdGltaXplZCBvdXQ+KSBhdApwb3N0bWFzdGVyLmM6MTQxNw0KIzE4 IDB4MDAwMDU2MGJmYTJmOTdhNCBpbiBtYWluIChhcmdjPTMsIGFyZ3Y9MHg1NjBiZmIzYjE5NTAp IGF0IG1haW4uYzoyMDkNCg0KV2l0aG91dCBhc3NlcnRzIGl0IGVtaXRzOiAgRVJST1I6ICB0dXBs ZSBhbHJlYWR5IHVwZGF0ZWQgYnkgc2VsZgoK --===============8904915192124644864==--