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 1rUEEO-009f5B-8v for pgsql-committers@arkaria.postgresql.org; Sun, 28 Jan 2024 23:06:28 +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 1rUEEK-00ADfZ-Hb for pgsql-committers@arkaria.postgresql.org; Sun, 28 Jan 2024 23:06:24 +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.94.2) (envelope-from ) id 1rUEEK-00ADfR-A5 for pgsql-committers@lists.postgresql.org; Sun, 28 Jan 2024 23:06:24 +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.94.2) (envelope-from ) id 1rUEEH-003rnn-67 for pgsql-committers@lists.postgresql.org; Sun, 28 Jan 2024 23:06:22 +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-00BjKL-K9 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-003b1Z-Db for pgsql-committers@lists.postgresql.org; Sun, 28 Jan 2024 23:06:19 +0000 Content-Type: multipart/mixed; boundary="===============6871422982525736220==" 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 --===============6871422982525736220== 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 YzhAcG9zdGdyZXNxbC5vcmcKQmFja3BhdGNoLXRocm91Z2g6IDE2CgpCcmFuY2gKLS0tLS0tCm1h c3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1p dGRpZmYvNTBiNzk3ZGM5OWVjM2JmOTdlYTVkMDk1NWEzYjQyZDM1NmMxNTIyZAoKTW9kaWZpZWQg RmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvdXNlci5jICAgICAgICAg ICAgICAgfCAxNiArKysrKy0tLS0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY3Jl YXRlX3JvbGUub3V0IHwgIDMgKystCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NyZWF0ZV9yb2xlLnNx bCAgICAgIHwgIDMgKystCjMgZmlsZXMgY2hhbmdlZCwgOSBpbnNlcnRpb25zKCspLCAxMyBkZWxl dGlvbnMoLSkKCg== --===============6871422982525736220==--