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 1rUEEQ-009f6A-TB for pgsql-committers@arkaria.postgresql.org; Sun, 28 Jan 2024 23:06:31 +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 1rUEEQ-00AE3f-2b for pgsql-committers@arkaria.postgresql.org; Sun, 28 Jan 2024 23:06: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.94.2) (envelope-from ) id 1rUEEP-00AE3G-Rg for pgsql-committers@lists.postgresql.org; Sun, 28 Jan 2024 23:06:29 +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 1rUEEJ-004EB2-2H for pgsql-committers@lists.postgresql.org; Sun, 28 Jan 2024 23:06:29 +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 1rUEEG-00BjKM-JD for pgsql-committers@lists.postgresql.org; Sun, 28 Jan 2024 23:06:20 +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 1rUEEF-003b1a-EA for pgsql-committers@lists.postgresql.org; Sun, 28 Jan 2024 23:06:19 +0000 Content-Type: multipart/mixed; boundary="===============6152014810116736319==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix DROP ROLE when specifying duplicated roles X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 28 Jan 2024 23:06:19 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6152014810116736319== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IERST1AgUk9MRSB3aGVuIHNwZWNpZnlpbmcgZHVwbGljYXRlZCByb2xlcwoKVGhpcyBjb21t aXQgZml4ZXMgZmFpbHVyZXMgd2l0aCAidHVwbGUgYWxyZWFkeSB1cGRhdGVkIGJ5IHNlbGYiIHdo ZW4KbGlzdGluZyB0d2ljZSB0aGUgc2FtZSByb2xlIGFuZCBpbiBhIERST1AgUk9MRSBxdWVyeS4K ClRoaXMgaXMgYW4gb3ZlcnNpZ2h0IGluIDY1NjYxMzNjNWY1MiwgdGhhdCBoYXMgaW50cm9kdWNl ZCBhIHR3by1waGFzZQpsb2dpYyBpbiBEcm9wUm9sZSgpIHdoZXJlIGRlcGVuZGVuY2llcyBvZiBh bGwgdGhlIHJvbGVzIHRvIGRyb3AgYXJlCnJlbW92ZWQgaW4gYSBmaXJzdCBwaGFzZSwgd2l0aCB0 aGUgcm9sZXMgdGhlbXNlbHZlcyByZW1vdmVkIGZyb20KcGdfYXV0aGlkIGluIGEgc2Vjb25kIHBo YXNlLgoKVGhlIGNvZGUgaXMgc2ltcGxpZmllZCB0byBub3QgcmVseSBvbiBhIExpc3Qgb2YgT2Jq ZWN0QWRkcmVzcyBidWlsdCBpbgp0aGUgZmlyc3QgcGhhc2UgdXNlZCB0byByZW1vdmUgdGhlIHBn X2F1dGhpZCBlbnRyaWVzIGluIHRoZSBzZWNvbmQKcGhhc2UsIHN3aXRjaGluZyB0byBhIGxpc3Qg b2YgT0lEcy4gIER1cGxpY2F0ZWQgT0lEcyBjYW4gYmUgc2ltcGx5CmF2b2lkZWQgaW4gdGhlIGZp cnN0IHBoYXNlIHRoYW5rcyB0byB0aGF0LiAgVXNpbmcgT2JqZWN0QWRkcmVzcyB3YXMgbm90Cm5l Y2Vzc2FyeSBmb3IgdGhlIHJvbGVzIGFzIHRoZXkgYXJlIG5vdCB1c2VkIGZvciBhbnl0aGluZyBz cGVjaWZpYyB0bwpkZXBlbmRlbmN5LmMsIGJ1aWxkaW5nIGFsbCB0aGUgT2JqZWN0QWRkcmVzcyBp biB0aGUgTGlzdCB3aXRoCkF1dGhJZFJlbGF0aW9uSWQgYXMgY2xhc3MgSUQuCgpJbiAxNSBhbmQg b2xkZXIgdmVyc2lvbnMsIHdoZXJlIGEgc2luZ2xlIHBoYXNlIGlzIHVzZWQsIERST1AgUk9MRSB3 aXRoCmR1cGxpY2F0ZWQgcm9sZSBuYW1lcyB3b3VsZCBmYWlsIG9uICJyb2xlIFwiYmxhaFwiIGRv ZXMgbm90IGV4aXN0IiBmb3IKdGhlIHNlY29uZCBlbnRyeSBhZnRlciB0aGUgQ0NJKCkgZG9uZSBi eSB0aGUgZmlyc3QgZGVsZXRpb24uICBUaGlzIGlzCm5vdCByZWFsbHkgaW5jb3JyZWN0LCBidXQg aXQgZG9lcyBub3Qgc2VlbSB3b3J0aCBjaGFuZ2luZyBiYXNlZCBvbiBhCmxhY2sgb2YgY29tcGxh aW50cy4KClJlcG9ydGVkLWJ5OiBBbGV4YW5kZXIgTGFraGluClJldmlld2VkLWJ5OiBUZW5kZXIg V2FuZwpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE4MzEwLTFlYjIzM2M1OTA4MTg5 YzhAcG9zdGdyZXNxbC5vcmcKQmFja3BhdGNoLXRocm91Z2g6IDE2CgpCcmFuY2gKLS0tLS0tClJF TF8xNl9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9w Zy9jb21taXRkaWZmL2Y1N2E1ODBmZDI4MGZkMTA1N2Y5NTI2Y2E5OGQ2M2Y0ODA1ZmExN2IKCk1v ZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3VzZXIuYyAg ICAgICAgICAgICAgIHwgMTYgKysrKystLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL2NyZWF0ZV9yb2xlLm91dCB8ICAzICsrLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jcmVhdGVf cm9sZS5zcWwgICAgICB8ICAzICsrLQozIGZpbGVzIGNoYW5nZWQsIDkgaW5zZXJ0aW9ucygrKSwg MTMgZGVsZXRpb25zKC0pCgo= --===============6152014810116736319==--