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 1qRHEZ-0018ik-BL for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Aug 2023 19:10:11 +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 1qRHEW-007Iqd-He for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Aug 2023 19:10:08 +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 1qRHEV-007IqT-Ng for pgsql-bugs@lists.postgresql.org; Wed, 02 Aug 2023 19:10:08 +0000 Received: from mail-pl1-x62c.google.com ([2607:f8b0:4864:20::62c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qRHEO-000BKv-LS for pgsql-bugs@postgresql.org; Wed, 02 Aug 2023 19:10:06 +0000 Received: by mail-pl1-x62c.google.com with SMTP id d9443c01a7336-1bbdc05a93bso1688045ad.0 for ; Wed, 02 Aug 2023 12:10:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20221208.gappssmtp.com; s=20221208; t=1691003400; x=1691608200; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=ESe1e3AY36Erdt5ahktX9Mm+UdogCBlORKT5nSiUqTM=; b=SPJ9VRgNk/pTGMJCgf80lDKPR4z8ogpjnTaFE4pvoDGtHY5CBDUVw0irqDYLae8stl yn8Q375AraeNw2+vYaBiKA1JsdGqxwYS1vi0rS/KCkIQPYjXYxw2hcQZo6cqSReeFoMZ bVurgnzJAynxskluuRcAkaEUrjECtCk8XyTo0slJmnwM6YL+FDHO/6ufEfFxB8P5lsFS DWNc1H8iiaKN4oe2r+ZWOoleRA9vFFKNwe7PArRFnknvKYYloNRZ3CtFY2rpOcH1qq0R hJiNYrPkQy0cO8uZs1jTq20u4tOjVTpro+XUTWE7sHu1w5igszVIqDMU5Yldj1jJCV7e +Urw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1691003400; x=1691608200; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=ESe1e3AY36Erdt5ahktX9Mm+UdogCBlORKT5nSiUqTM=; b=C/H6k9CBZRfgPmBAGSUkWonW1h14383ZmOjyGAFGCxWPMnc3x+nsokLubU/K4H3iLA OtbD5O0s8MD/vSGF01548x8kSZ1VPVHbidyntAzqb2aKB6rFkdLPBsBQ3HVRAVVk8eKv YcvHduMAeN9iiwmMkvGyIhPFASMtV4C27+UHukDuWFYKmuYyAmaKvia84Uy+5JRXBzpX 5ceYWtKnzGzY28n4vLAYYggvMwzPjOQ/kpJ26EOc0QzHiXyDf7njFNzNifxXaDgJVGxQ 6H4HNplDp6NQojXReQuw+YS9xQqF1Sv02sId4tt7IOs0kvL3Fdw1TNcoxCDkJitiPDdv j4+A== X-Gm-Message-State: AOJu0YzFfDG3MtOiHKOADqYE8EwFXtS19kjNm3qi3B9qmm3jY0qZEvxy XzkdwH5RX8s+puOIHvWr3wTccg== X-Google-Smtp-Source: AGHT+IE02HFC+ml51vKpy4Ul7Fr8u5pC/tITpXEh63xTZqSsEpsTt6aLbEu5KGFbFck1pYwAJikBkQ== X-Received: by 2002:a17:903:2344:b0:1bc:3504:de2f with SMTP id c4-20020a170903234400b001bc3504de2fmr1978879plh.32.1691003399528; Wed, 02 Aug 2023 12:09:59 -0700 (PDT) Received: from [172.24.1.43] ([12.126.244.130]) by smtp.gmail.com with ESMTPSA id t14-20020a1709028c8e00b001b8062c1db3sm12782452plo.82.2023.08.02.12.09.58 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 02 Aug 2023 12:09:58 -0700 (PDT) Message-ID: <628b8fcc7b99bb06717a569cc91fb6436e499139.camel@j-davis.com> Subject: Re: search_path not recomputed when role name changes From: Jeff Davis To: Michael Paquier , Nathan Bossart Cc: pgsql-bugs@postgresql.org Date: Wed, 02 Aug 2023 12:09:58 -0700 In-Reply-To: References: <186761d32c0255debbdf50b6310b581b9c973e6c.camel@j-davis.com> <20230730040802.GA284134@nathanxps13> Content-Type: multipart/mixed; boundary="=-VHrlE0QlR92waPAIPfIm" User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-VHrlE0QlR92waPAIPfIm Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, 2023-07-30 at 14:58 +0900, Michael Paquier wrote: > Is that something that should have an isolation test? Good idea, attached. Is there any logical ordering or grouping in the isolation_schedule? I just added it at the end. Regards, Jeff Davis --=-VHrlE0QlR92waPAIPfIm Content-Disposition: attachment; filename="v2-0001-Recalculate-search_path-after-ALTER-ROLE.patch" Content-Type: text/x-patch; name="v2-0001-Recalculate-search_path-after-ALTER-ROLE.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSA3YzcxZjBhMzkwZDU3NTcxMGEyZDJmNDU4ZjBhMzMzYjViYWQxMzk5IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKZWZmIERhdmlzIDxqZWZmQGotZGF2aXMuY29tPgpEYXRlOiBX ZWQsIDIgQXVnIDIwMjMgMTE6NTE6NTAgLTA3MDAKU3ViamVjdDogW1BBVENIIHYyXSBSZWNhbGN1 bGF0ZSBzZWFyY2hfcGF0aCBhZnRlciBBTFRFUiBST0xFLgoKUmVuYW1pbmcgYSByb2xlIGNhbiBh ZmZlY3QgdGhlIG1lYW5pbmcgb2YgdGhlIHNwZWNpYWwgc3RyaW5nICR1c2VyLCBzbwptdXN0IGNh dXNlIHNlYXJjaF9wYXRoIHRvIGJlIHJlY2FsY3VsYXRlZC4KCkRpc2N1c3Npb246IGh0dHBzOi8v cG9zdGdyLmVzL20vMTg2NzYxZDMyYzAyNTVkZWJiZGY1MGI2MzEwYjU4MWI5Yzk3M2U2Yy5jYW1l bEBqLWRhdmlzLmNvbQotLS0KIHNyYy9iYWNrZW5kL2NhdGFsb2cvbmFtZXNwYWNlLmMgICAgICAg ICAgICAgICB8ICA2ICstCiAuLi4vaXNvbGF0aW9uL2V4cGVjdGVkL3NlYXJjaC1wYXRoLWludmFs Lm91dCAgfCA5NyArKysrKysrKysrKysrKysrKysrCiBzcmMvdGVzdC9pc29sYXRpb24vaXNvbGF0 aW9uX3NjaGVkdWxlICAgICAgICAgfCAgMSArCiAuLi4vaXNvbGF0aW9uL3NwZWNzL3NlYXJjaC1w YXRoLWludmFsLnNwZWMgICAgfCA1OSArKysrKysrKysrKwogNCBmaWxlcyBjaGFuZ2VkLCAxNjIg aW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQogY3JlYXRlIG1vZGUgMTAwNjQ0IHNyYy90ZXN0 L2lzb2xhdGlvbi9leHBlY3RlZC9zZWFyY2gtcGF0aC1pbnZhbC5vdXQKIGNyZWF0ZSBtb2RlIDEw MDY0NCBzcmMvdGVzdC9pc29sYXRpb24vc3BlY3Mvc2VhcmNoLXBhdGgtaW52YWwuc3BlYwoKZGlm ZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NhdGFsb2cvbmFtZXNwYWNlLmMgYi9zcmMvYmFja2VuZC9j YXRhbG9nL25hbWVzcGFjZS5jCmluZGV4IDFmNzZiNWQ3ZjcuLjBjNjc5ZmJmOTQgMTAwNjQ0Ci0t LSBhL3NyYy9iYWNrZW5kL2NhdGFsb2cvbmFtZXNwYWNlLmMKKysrIGIvc3JjL2JhY2tlbmQvY2F0 YWxvZy9uYW1lc3BhY2UuYwpAQCAtNDE3NSwxMSArNDE3NSwxNSBAQCBJbml0aWFsaXplU2VhcmNo UGF0aCh2b2lkKQogCXsKIAkJLyoKIAkJICogSW4gbm9ybWFsIG1vZGUsIGFycmFuZ2UgZm9yIGEg Y2FsbGJhY2sgb24gYW55IHN5c2NhY2hlIGludmFsaWRhdGlvbgotCQkgKiBvZiBwZ19uYW1lc3Bh Y2Ugcm93cy4KKwkJICogb2YgcGdfbmFtZXNwYWNlIG9yIHBnX2F1dGhpZCByb3dzLiAoQ2hhbmdp bmcgYSByb2xlIG5hbWUgbWF5IGFmZmVjdAorCQkgKiB0aGUgbWVhbmluZyBvZiB0aGUgc3BlY2lh bCBzdHJpbmcgJHVzZXIuKQogCQkgKi8KIAkJQ2FjaGVSZWdpc3RlclN5c2NhY2hlQ2FsbGJhY2so TkFNRVNQQUNFT0lELAogCQkJCQkJCQkJICBOYW1lc3BhY2VDYWxsYmFjaywKIAkJCQkJCQkJCSAg KERhdHVtKSAwKTsKKwkJQ2FjaGVSZWdpc3RlclN5c2NhY2hlQ2FsbGJhY2soQVVUSE9JRCwKKwkJ CQkJCQkJCSAgTmFtZXNwYWNlQ2FsbGJhY2ssCisJCQkJCQkJCQkgIChEYXR1bSkgMCk7CiAJCS8q IEZvcmNlIHNlYXJjaCBwYXRoIHRvIGJlIHJlY29tcHV0ZWQgb24gbmV4dCB1c2UgKi8KIAkJYmFz ZVNlYXJjaFBhdGhWYWxpZCA9IGZhbHNlOwogCX0KZGlmZiAtLWdpdCBhL3NyYy90ZXN0L2lzb2xh dGlvbi9leHBlY3RlZC9zZWFyY2gtcGF0aC1pbnZhbC5vdXQgYi9zcmMvdGVzdC9pc29sYXRpb24v ZXhwZWN0ZWQvc2VhcmNoLXBhdGgtaW52YWwub3V0Cm5ldyBmaWxlIG1vZGUgMTAwNjQ0CmluZGV4 IDAwMDAwMDAwMDAuLmUwMTczYWZkYjIKLS0tIC9kZXYvbnVsbAorKysgYi9zcmMvdGVzdC9pc29s YXRpb24vZXhwZWN0ZWQvc2VhcmNoLXBhdGgtaW52YWwub3V0CkBAIC0wLDAgKzEsOTcgQEAKK1Bh cnNlZCB0ZXN0IHNwZWMgd2l0aCAzIHNlc3Npb25zCisKK3N0YXJ0aW5nIHBlcm11dGF0aW9uOiBz MWEgczJhIHMxYSBzMmIKK3N0ZXAgczFhOiAKKyAgICBTRUxFQ1QgQ1VSUkVOVF9VU0VSOworICAg IFNIT1cgc2VhcmNoX3BhdGg7CisgICAgU0VMRUNUIHQgRlJPTSB4OworCitjdXJyZW50X3VzZXIg ICAgCistLS0tLS0tLS0tLS0tLS0tCityZWdyZXNzX3NwX3VzZXIxCisoMSByb3cpCisKK3NlYXJj aF9wYXRoICAgICAgICAgICAgICAgCistLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQorIiR1c2Vy IiwgcmVncmVzc19zcF9wdWJsaWMKKygxIHJvdykKKwordCAgICAgICAgICAgICAgICAgICAgICAg ICAKKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCitkYXRhIGluIHJlZ3Jlc3Nfc3BfdXNlcjEu eAorKDEgcm93KQorCitzdGVwIHMyYTogCisgICAgQUxURVIgUk9MRSByZWdyZXNzX3NwX3VzZXIx IFJFTkFNRSBUTyByZWdyZXNzX3NwX3VzZXIyOworCitzdGVwIHMxYTogCisgICAgU0VMRUNUIENV UlJFTlRfVVNFUjsKKyAgICBTSE9XIHNlYXJjaF9wYXRoOworICAgIFNFTEVDVCB0IEZST00geDsK KworY3VycmVudF91c2VyICAgIAorLS0tLS0tLS0tLS0tLS0tLQorcmVncmVzc19zcF91c2VyMgor KDEgcm93KQorCitzZWFyY2hfcGF0aCAgICAgICAgICAgICAgIAorLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0KKyIkdXNlciIsIHJlZ3Jlc3Nfc3BfcHVibGljCisoMSByb3cpCisKK3QgICAgICAg ICAgICAgICAgICAgICAgICAgIAorLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCitkYXRhIGlu IHJlZ3Jlc3Nfc3BfcHVibGljLngKKygxIHJvdykKKworc3RlcCBzMmI6IAorICAgIEFMVEVSIFJP TEUgcmVncmVzc19zcF91c2VyMiBSRU5BTUUgVE8gcmVncmVzc19zcF91c2VyMTsKKworCitzdGFy dGluZyBwZXJtdXRhdGlvbjogczFhIHMzYSBzMWEgczNiCitzdGVwIHMxYTogCisgICAgU0VMRUNU IENVUlJFTlRfVVNFUjsKKyAgICBTSE9XIHNlYXJjaF9wYXRoOworICAgIFNFTEVDVCB0IEZST00g eDsKKworY3VycmVudF91c2VyICAgIAorLS0tLS0tLS0tLS0tLS0tLQorcmVncmVzc19zcF91c2Vy MQorKDEgcm93KQorCitzZWFyY2hfcGF0aCAgICAgICAgICAgICAgIAorLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0KKyIkdXNlciIsIHJlZ3Jlc3Nfc3BfcHVibGljCisoMSByb3cpCisKK3QgICAg ICAgICAgICAgICAgICAgICAgICAgCistLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQorZGF0YSBp biByZWdyZXNzX3NwX3VzZXIxLngKKygxIHJvdykKKworc3RlcCBzM2E6IAorICAgIEFMVEVSIFND SEVNQSByZWdyZXNzX3NwX3VzZXIxIFJFTkFNRSBUTyByZWdyZXNzX3NwX3VzZXIyOworCitzdGVw IHMxYTogCisgICAgU0VMRUNUIENVUlJFTlRfVVNFUjsKKyAgICBTSE9XIHNlYXJjaF9wYXRoOwor ICAgIFNFTEVDVCB0IEZST00geDsKKworY3VycmVudF91c2VyICAgIAorLS0tLS0tLS0tLS0tLS0t LQorcmVncmVzc19zcF91c2VyMQorKDEgcm93KQorCitzZWFyY2hfcGF0aCAgICAgICAgICAgICAg IAorLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KKyIkdXNlciIsIHJlZ3Jlc3Nfc3BfcHVibGlj CisoMSByb3cpCisKK3QgICAgICAgICAgICAgICAgICAgICAgICAgIAorLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tCitkYXRhIGluIHJlZ3Jlc3Nfc3BfcHVibGljLngKKygxIHJvdykKKworc3Rl cCBzM2I6IAorICAgIEFMVEVSIFNDSEVNQSByZWdyZXNzX3NwX3VzZXIyIFJFTkFNRSBUTyByZWdy ZXNzX3NwX3VzZXIxOworCmRpZmYgLS1naXQgYS9zcmMvdGVzdC9pc29sYXRpb24vaXNvbGF0aW9u X3NjaGVkdWxlIGIvc3JjL3Rlc3QvaXNvbGF0aW9uL2lzb2xhdGlvbl9zY2hlZHVsZQppbmRleCA0 ZmM1NmFlOTljLi5lYWI5ZjIyNDNlIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9pc29sYXRpb24vaXNv bGF0aW9uX3NjaGVkdWxlCisrKyBiL3NyYy90ZXN0L2lzb2xhdGlvbi9pc29sYXRpb25fc2NoZWR1 bGUKQEAgLTExMCwzICsxMTAsNCBAQCB0ZXN0OiBzZXJpYWxpemFibGUtcGFyYWxsZWwKIHRlc3Q6 IHNlcmlhbGl6YWJsZS1wYXJhbGxlbC0yCiB0ZXN0OiBzZXJpYWxpemFibGUtcGFyYWxsZWwtMwog dGVzdDogbWF0dmlldy13cml0ZS1za2V3Cit0ZXN0OiBzZWFyY2gtcGF0aC1pbnZhbApcIE5vIG5l d2xpbmUgYXQgZW5kIG9mIGZpbGUKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L2lzb2xhdGlvbi9zcGVj cy9zZWFyY2gtcGF0aC1pbnZhbC5zcGVjIGIvc3JjL3Rlc3QvaXNvbGF0aW9uL3NwZWNzL3NlYXJj aC1wYXRoLWludmFsLnNwZWMKbmV3IGZpbGUgbW9kZSAxMDA2NDQKaW5kZXggMDAwMDAwMDAwMC4u MDhiMWJiYTJmYwotLS0gL2Rldi9udWxsCisrKyBiL3NyYy90ZXN0L2lzb2xhdGlvbi9zcGVjcy9z ZWFyY2gtcGF0aC1pbnZhbC5zcGVjCkBAIC0wLDAgKzEsNTkgQEAKKyMgVGVzdCBzZWFyY2hfcGF0 aCBpbnZhbGlkYXRpb24uCisKK3NldHVwCit7CisgICAgQ1JFQVRFIFVTRVIgcmVncmVzc19zcF91 c2VyMTsKKyAgICBDUkVBVEUgU0NIRU1BIHJlZ3Jlc3Nfc3BfdXNlcjEgQVVUSE9SSVpBVElPTiBy ZWdyZXNzX3NwX3VzZXIxOworICAgIENSRUFURSBTQ0hFTUEgcmVncmVzc19zcF9wdWJsaWM7Cisg ICAgR1JBTlQgQUxMIFBSSVZJTEVHRVMgT04gU0NIRU1BIHJlZ3Jlc3Nfc3BfcHVibGljIFRPIHJl Z3Jlc3Nfc3BfdXNlcjE7Cit9CisKK3RlYXJkb3duCit7CisgICAgRFJPUCBTQ0hFTUEgcmVncmVz c19zcF9wdWJsaWMgQ0FTQ0FERTsKKyAgICBEUk9QIFNDSEVNQSByZWdyZXNzX3NwX3VzZXIxIENB U0NBREU7CisgICAgRFJPUCBVU0VSIHJlZ3Jlc3Nfc3BfdXNlcjE7Cit9CisKK3Nlc3Npb24gczEK K3NldHVwCit7CisgICAgU0VUIHNlYXJjaF9wYXRoID0gIiR1c2VyIiwgcmVncmVzc19zcF9wdWJs aWM7CisgICAgU0VUIFNFU1NJT04gQVVUSE9SSVpBVElPTiByZWdyZXNzX3NwX3VzZXIxOworICAg IENSRUFURSBUQUJMRSByZWdyZXNzX3NwX3VzZXIxLngodCkgQVMgU0VMRUNUICdkYXRhIGluIHJl Z3Jlc3Nfc3BfdXNlcjEueCc7CisgICAgQ1JFQVRFIFRBQkxFIHJlZ3Jlc3Nfc3BfcHVibGljLngo dCkgQVMgU0VMRUNUICdkYXRhIGluIHJlZ3Jlc3Nfc3BfcHVibGljLngnOworfQorc3RlcCBzMWEK K3sKKyAgICBTRUxFQ1QgQ1VSUkVOVF9VU0VSOworICAgIFNIT1cgc2VhcmNoX3BhdGg7CisgICAg U0VMRUNUIHQgRlJPTSB4OworfQorCitzZXNzaW9uIHMyCitzdGVwIHMyYQoreworICAgIEFMVEVS IFJPTEUgcmVncmVzc19zcF91c2VyMSBSRU5BTUUgVE8gcmVncmVzc19zcF91c2VyMjsKK30KK3N0 ZXAgczJiCit7CisgICAgQUxURVIgUk9MRSByZWdyZXNzX3NwX3VzZXIyIFJFTkFNRSBUTyByZWdy ZXNzX3NwX3VzZXIxOworfQorCitzZXNzaW9uIHMzCitzdGVwIHMzYQoreworICAgIEFMVEVSIFND SEVNQSByZWdyZXNzX3NwX3VzZXIxIFJFTkFNRSBUTyByZWdyZXNzX3NwX3VzZXIyOworfQorc3Rl cCBzM2IKK3sKKyAgICBBTFRFUiBTQ0hFTUEgcmVncmVzc19zcF91c2VyMiBSRU5BTUUgVE8gcmVn cmVzc19zcF91c2VyMTsKK30KKworIyBzMSdzIHNlYXJjaF9wYXRoIGlzIGludmFsaWRhdGVkIGJ5 IHJvbGUgbmFtZSBjaGFuZ2UgaW4gczJhLCBhbmQKKyMgZmFsbHMgYmFjayB0byByZWdyZXNzX3Nw X3B1YmxpYy54CitwZXJtdXRhdGlvbiBzMWEgczJhIHMxYSBzMmIKKworIyBzMSdzIHNlYXJjaF9w YXRoIGlzIGludmFsaWRhdGVkIGJ5IHNjaGVtYSBuYW1lIGNoYW5nZSBpbiBzMmIsIGFuZAorIyBm YWxscyBiYWNrIHRvIHJlZ3Jlc3Nfc3BfcHVibGljLngKK3Blcm11dGF0aW9uIHMxYSBzM2EgczFh IHMzYgotLSAKMi4zNC4xCgo= --=-VHrlE0QlR92waPAIPfIm--