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.96) (envelope-from ) id 1woqPH-001HhQ-2T for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Jul 2026 22:36:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1woqPG-002xsK-0y for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Jul 2026 22:36:14 +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.96) (envelope-from ) id 1woqPF-002xsA-2U for pgsql-hackers@lists.postgresql.org; Tue, 28 Jul 2026 22:36:14 +0000 Received: from mail-oo1-xc31.google.com ([2607:f8b0:4864:20::c31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1woqPD-00000000oGx-10Im for pgsql-hackers@postgresql.org; Tue, 28 Jul 2026 22:36:12 +0000 Received: by mail-oo1-xc31.google.com with SMTP id 006d021491bc7-6aca0f482e5so243900eaf.2 for ; Tue, 28 Jul 2026 15:36:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20251104.gappssmtp.com; s=20251104; t=1785278170; x=1785882970; darn=postgresql.org; h=mime-version:user-agent:content-type:references:in-reply-to:date:cc :to:from:subject:message-id:from:to:cc:subject:date:message-id :reply-to:content-type; bh=jbr2DAR7KnxHTXvF29izY/pBXb1R4CB4HYi6YT0bl1M=; b=cQV5hdwZiUkRY1GQtfYFuI0MKa+haHsY6GzjhDHjp4vlb0kssizMyf0g0ApiALWV9m g+EycjMLreXj6Kw9qbnbd2sQeBnqb83RxcGx8uewMz2Wx7bevo5XLTCI0Cx+r6resGTV Ul9k3/ihMLKYhsf7pr4BM2ZUQmg7aT27oq9oD6i5L3beChTMgNvsodK1StGlQ8maefiW 4eU8EmctUfWTCash56P+wMLrAPwOYgUMyYln8tIMllihCeCAib6bykWauzA1wIhO5Jd/ RT/Dkrc2EyWTb7lTPiLOQEvpaiFzLL/PY/x689nPJqgQ4J6PI+a66s4d6sVTz+jUz/qH ewrA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1785278170; x=1785882970; h=mime-version:user-agent:content-type:references:in-reply-to:date:cc :to:from:subject:message-id:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to:content-type; bh=jbr2DAR7KnxHTXvF29izY/pBXb1R4CB4HYi6YT0bl1M=; b=fOkXwdcCpnc27LjIaiGwDWPVS8I3i6OoW/lYcuVE5F8QlZqGYewejcjrVibEbU+SEt 0Kk+o/Wb1IJblqqzh8wNd+tUG13UqsjKPs+rRgQq9Cxjnqj/r0QGVOOusljvEwP53a9V o9DZiWGllBGa1gEMnTeR+AhZKppnl4msDbSp1lzAQK5bbE6YcZ5NGwOlvs0KbZhYSXYm 59oXTjHRW11K5Tp4++Drs0sLaqYOPQOLL7UoxkPD3VRh5/Xw5ohIf6iB3GQoL/e6uUlA sPM/yjCIc6Em0zLhzR9aPtwhgC9WF/bPM8a0fnw0v+NriNH9Hcz5wOnM1jtOEvmV/m1V 3Gxg== X-Gm-Message-State: AOJu0Yxuar5ka18fTS0Sn3aw114uV2EMSlfc4QUrJHIjRudAngjXwpa0 1UY8Q38Sw6DH/tkFLJGdhS4IeiBSU4Mf+uDQXowgWRlYs00HZXY1bD/IzzstrPdHKw== X-Gm-Gg: AR+sD12ZH+egSXuKq6cglHURNarWL04TQLkyDF/KdYKiShgQUXPQwUPbKKczZjzy1kJ CaupsvHfgOGYHfUJTGZ3+D86koFC4qAMhU/jpdhGXYKJK7cFOlcR3n0mVs+nm7LW20XnNDfxBCq +bg1pygebbxhRneH0aAvPRK4DGDZtRYsR8PCgyA9tqGDwzN9lxxPsi9VXvq7YASd7aLJEdZYp4y ksP0TB2+8AFn43u1qujaPV5+z09jIfkGIAETvhBVh+5m9nMcOiQ3QloW8u1Y3MzdW748ICfN4Z2 4RMj59XK+UggEPU1x1v5hLV05vBpMHAb6zQt4txGFKUHL7rY9LeYS3fkKMVfwvSGbgYqzZ9FmSd 0NNIiPDEX4s9vgNG0rLNQ97JnjSRCATup+wIR/zTGuvwLmYcL98o9vE7xJlwNrki+v+iLWHpmAZ xyIw== X-Received: by 2002:a05:6820:1a09:b0:6a3:dc6d:458e with SMTP id 006d021491bc7-6ac96cdf449mr2199669eaf.56.1785278169794; Tue, 28 Jul 2026 15:36:09 -0700 (PDT) Received: from [10.10.245.176] ([12.63.242.123]) by smtp.gmail.com with ESMTPSA id 586e51a60fabf-458863c7305sm935422fac.1.2026.07.28.15.36.08 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 28 Jul 2026 15:36:09 -0700 (PDT) Message-ID: <2487ddcd737d4fc8e408e87aa9ad4365eed3bbb3.camel@j-davis.com> Subject: Re: CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc. From: Jeff Davis To: Noah Misch Cc: pgsql-hackers@postgresql.org, Robert Haas Date: Tue, 28 Jul 2026 15:36:08 -0700 In-Reply-To: <20260710195902.4f.noahmisch@microsoft.com> References: <20260710195902.4f.noahmisch@microsoft.com> Content-Type: multipart/mixed; boundary="=-x4soz5mqg2Mu8DyBvxzI" User-Agent: Evolution 3.52.3-0ubuntu1.1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-x4soz5mqg2Mu8DyBvxzI Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, 2026-07-10 at 12:59 -0700, Noah Misch wrote: > An Opus 4.8 review of commit 8185bb5 found two pg_dump+restore > failure > scenarios, visible in the attached test patch.=C2=A0 (The patch also test= s > a > REASSIGN OWNED finding, for which I started a distinct thread > postgr.es/m/flat/20260710192533.4f.noahmisch@microsoft.com). >=20 > Opus also emitted the attached report about these findings and > others.=C2=A0 I > didn't examine the others closely.=C2=A0 Finding-19, about invalidation > callbacks, > stood out as perhaps most exciting if true. Partial patch series: 0001: Finding 10 preexisting issue: Add missing lock release for=C2=A0 DROP OWNED BY (backport to 16) 0002: Finding 10 & 15: Improve & document DROP SERVER CASCADE 0003: Finding 3: Reject use_scram_passthrough for subscription connections. Robert, can you take a look at 0001, which fixes an issue introduced in 6566133c5f? I don't think it's major but it can retain the lock for longer. Regards, Jeff Davis --=-x4soz5mqg2Mu8DyBvxzI Content-Disposition: attachment; filename*0=v2-0001-Fix-lock-release-for-role-membership-grants-in-DR.pat; filename*1=ch Content-Type: text/x-patch; name="v2-0001-Fix-lock-release-for-role-membership-grants-in-DR.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSA0MjhkOGM3YzQxODA2ZGVlYjEzNTdhNmU5NWU4ZjlhMjY4N2RiZDU2IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKZWZmIERhdmlzIDxqZWZmQGotZGF2aXMuY29tPgpEYXRlOiBU dWUsIDI4IEp1bCAyMDI2IDE0OjUwOjQ1IC0wNzAwClN1YmplY3Q6IFtQQVRDSCB2MiAxLzNdIEZp eCBsb2NrIHJlbGVhc2UgZm9yIHJvbGUgbWVtYmVyc2hpcCBncmFudHMgaW4gRFJPUAogT1dORUQg QlkuCgpBZGQgUmVsZWFzZURlbGV0aW9uTG9jaygpIHRvIG1hdGNoIEFjcXVpcmVEZWxldGlvbkxv Y2soKS4gSW50cm9kdWNlZApieSBjb21taXQgNjU2NjEzM2M1ZjUuCgpEaXNjdXNzaW9uOiBodHRw czovL3Bvc3Rnci5lcy9tLzIwMjYwNzEwMTk1OTAyLjRmLm5vYWhtaXNjaEBtaWNyb3NvZnQuY29t CkJhY2twYXRjaC10aHJvdWdoOiAxNgotLS0KIHNyYy9iYWNrZW5kL2NhdGFsb2cvZGVwZW5kZW5j eS5jIHwgMyArKysKIDEgZmlsZSBjaGFuZ2VkLCAzIGluc2VydGlvbnMoKykKCmRpZmYgLS1naXQg YS9zcmMvYmFja2VuZC9jYXRhbG9nL2RlcGVuZGVuY3kuYyBiL3NyYy9iYWNrZW5kL2NhdGFsb2cv ZGVwZW5kZW5jeS5jCmluZGV4IGM1NDc3NGIzMjc1Li41MmNkMmNhZjlkNCAxMDA2NDQKLS0tIGEv c3JjL2JhY2tlbmQvY2F0YWxvZy9kZXBlbmRlbmN5LmMKKysrIGIvc3JjL2JhY2tlbmQvY2F0YWxv Zy9kZXBlbmRlbmN5LmMKQEAgLTE2MDAsNiArMTYwMCw5IEBAIFJlbGVhc2VEZWxldGlvbkxvY2so Y29uc3QgT2JqZWN0QWRkcmVzcyAqb2JqZWN0KQogewogCWlmIChvYmplY3QtPmNsYXNzSWQgPT0g UmVsYXRpb25SZWxhdGlvbklkKQogCQlVbmxvY2tSZWxhdGlvbk9pZChvYmplY3QtPm9iamVjdElk LCBBY2Nlc3NFeGNsdXNpdmVMb2NrKTsKKwllbHNlIGlmIChvYmplY3QtPmNsYXNzSWQgPT0gQXV0 aE1lbVJlbGF0aW9uSWQpCisJCVVubG9ja1NoYXJlZE9iamVjdChvYmplY3QtPmNsYXNzSWQsIG9i amVjdC0+b2JqZWN0SWQsIDAsCisJCQkJCQkgICBBY2Nlc3NFeGNsdXNpdmVMb2NrKTsKIAllbHNl CiAJCS8qIGFzc3VtZSB3ZSBzaG91bGQgbG9jayB0aGUgd2hvbGUgb2JqZWN0IG5vdCBhIHN1Yi1v YmplY3QgKi8KIAkJVW5sb2NrRGF0YWJhc2VPYmplY3Qob2JqZWN0LT5jbGFzc0lkLCBvYmplY3Qt Pm9iamVjdElkLCAwLAotLSAKMi40My4wCgo= --=-x4soz5mqg2Mu8DyBvxzI Content-Disposition: attachment; filename*0=v2-0002-Improve-DROP-SERVER-handling-of-dependent-subscri.pat; filename*1=ch Content-Type: text/x-patch; name="v2-0002-Improve-DROP-SERVER-handling-of-dependent-subscri.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSBmNDBhNmMyNTZjNzA5MDE0YjFmYmU3NjcwZjY4MDYxODAwZDUwNGNlIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKZWZmIERhdmlzIDxqZWZmQGotZGF2aXMuY29tPgpEYXRlOiBU dWUsIDI4IEp1bCAyMDI2IDE0OjQ4OjEyIC0wNzAwClN1YmplY3Q6IFtQQVRDSCB2MiAyLzNdIElt cHJvdmUgRFJPUCBTRVJWRVIgaGFuZGxpbmcgb2YgZGVwZW5kZW50CiBzdWJzY3JpcHRpb25zLgoK QWNxdWlyZSBhIGxvY2sgb24gdGhlIHN1YnNjcmlwdGlvbiB0byBhdm9pZCB1bm5lY2Vzc2FyeSBl cnJvcnMuIEFsc28KaXNzdWUgYSBISU5UIGFuZCBkb2N1bWVudCB0aGUgcmVzdHJpY3Rpb24gdGhh dCBDQVNDQURFIHdvbid0IGNhc2NhZGUKdG8gdGhlIHN1YnNjcmlwdGlvbiBvYmplY3QuCgpSZXBv cnRlZC1ieTogTm9haCBNaXNjaCA8bm9haEBsZWFkYm9hdC5jb20+CkRpc2N1c3Npb246IGh0dHBz Oi8vcG9zdGdyLmVzL20vMjAyNjA3MTAxOTU5MDIuNGYubm9haG1pc2NoQG1pY3Jvc29mdC5jb20K QmFja3BhdGNoLXRocm91Z2g6IDE5Ci0tLQogZG9jL3NyYy9zZ21sL3JlZi9kcm9wX3NlcnZlci5z Z21sICAgICAgICAgIHwgIDQgKysrKwogc3JjL2JhY2tlbmQvY2F0YWxvZy9kZXBlbmRlbmN5LmMg ICAgICAgICAgIHwgMjggKysrKysrKysrKysrLS0tLS0tLS0tLQogc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9zdWJzY3JpcHRpb24ub3V0IHwgIDQgKysrKwogc3JjL3Rlc3QvcmVncmVzcy9zcWwv c3Vic2NyaXB0aW9uLnNxbCAgICAgIHwgIDIgKysKIDQgZmlsZXMgY2hhbmdlZCwgMjUgaW5zZXJ0 aW9ucygrKSwgMTMgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL3JlZi9k cm9wX3NlcnZlci5zZ21sIGIvZG9jL3NyYy9zZ21sL3JlZi9kcm9wX3NlcnZlci5zZ21sCmluZGV4 IGY4M2E2NjFiM2ViLi41ZmEwYjc2M2YzNiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3JlZi9k cm9wX3NlcnZlci5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9yZWYvZHJvcF9zZXJ2ZXIuc2dtbApA QCAtNjYsNiArNjYsMTAgQEAgRFJPUCBTRVJWRVIgWyBJRiBFWElTVFMgXSA8cmVwbGFjZWFibGUg Y2xhc3M9InBhcmFtZXRlciI+bmFtZTwvcmVwbGFjZWFibGU+IFssIC4KICAgICAgIHVzZXIgbWFw cGluZ3MpLAogICAgICAgYW5kIGluIHR1cm4gYWxsIG9iamVjdHMgdGhhdCBkZXBlbmQgb24gdGhv c2Ugb2JqZWN0cwogICAgICAgKHNlZSA8eHJlZiBsaW5rZW5kPSJkZGwtZGVwZW5kIi8+KS4KKyAg ICAgIEhvd2V2ZXIsIGEgc3Vic2NyaXB0aW9uIHRoYXQgdXNlcyB0aGUgc2VydmVyIGlzIG5ldmVy IGRyb3BwZWQKKyAgICAgIGF1dG9tYXRpY2FsbHk7IGl0IG11c3QgYmUgZHJvcHBlZCB3aXRoCisg ICAgICA8bGluayBsaW5rZW5kPSJzcWwtZHJvcHN1YnNjcmlwdGlvbiI+PGNvbW1hbmQ+RFJPUCBT VUJTQ1JJUFRJT048L2NvbW1hbmQ+PC9saW5rPgorICAgICAgYmVmb3JlIHRoZSBzZXJ2ZXIgY2Fu IGJlIGRyb3BwZWQuCiAgICAgIDwvcGFyYT4KICAgICA8L2xpc3RpdGVtPgogICAgPC92YXJsaXN0 ZW50cnk+CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC9jYXRhbG9nL2RlcGVuZGVuY3kuYyBiL3Ny Yy9iYWNrZW5kL2NhdGFsb2cvZGVwZW5kZW5jeS5jCmluZGV4IDUyY2QyY2FmOWQ0Li5iODA5NDlh NWVlYiAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvY2F0YWxvZy9kZXBlbmRlbmN5LmMKKysrIGIv c3JjL2JhY2tlbmQvY2F0YWxvZy9kZXBlbmRlbmN5LmMKQEAgLTkwMCwxNyArOTAwLDYgQEAgZmlu ZERlcGVuZGVudE9iamVjdHMoY29uc3QgT2JqZWN0QWRkcmVzcyAqb2JqZWN0LAogCQkJb2JqZWN0 LT5vYmplY3RTdWJJZCA9PSAwKQogCQkJY29udGludWU7CiAKLQkJLyoKLQkJICogQ2hlY2sgdGhh dCB0aGUgZGVwZW5kZW50IG9iamVjdCBpcyBub3QgaW4gYSBzaGFyZWQgY2F0YWxvZywgd2hpY2gK LQkJICogaXMgbm90IHN1cHBvcnRlZCBieSBkb0RlbGV0aW9uKCkuCi0JCSAqLwotCQlpZiAoSXNT aGFyZWRSZWxhdGlvbihvdGhlck9iamVjdC5jbGFzc0lkKSkKLQkJCWVyZXBvcnQoRVJST1IsCi0J CQkJCShlcnJjb2RlKEVSUkNPREVfREVQRU5ERU5UX09CSkVDVFNfU1RJTExfRVhJU1QpLAotCQkJ CQkgZXJybXNnKCJjYW5ub3QgZHJvcCAlcyBiZWNhdXNlICVzIGRlcGVuZHMgb24gaXQiLAotCQkJ CQkJCWdldE9iamVjdERlc2NyaXB0aW9uKG9iamVjdCwgZmFsc2UpLAotCQkJCQkJCWdldE9iamVj dERlc2NyaXB0aW9uKCZvdGhlck9iamVjdCwgZmFsc2UpKSkpOwotCiAJCS8qCiAJCSAqIE11c3Qg bG9jayB0aGUgZGVwZW5kZW50IG9iamVjdCBiZWZvcmUgcmVjdXJzaW5nIHRvIGl0LgogCQkgKi8K QEAgLTkzMSw2ICs5MjAsMTkgQEAgZmluZERlcGVuZGVudE9iamVjdHMoY29uc3QgT2JqZWN0QWRk cmVzcyAqb2JqZWN0LAogCQkJY29udGludWU7CiAJCX0KIAorCQkvKgorCQkgKiBDaGVjayB0aGF0 IHRoZSBkZXBlbmRlbnQgb2JqZWN0IGlzIG5vdCBpbiBhIHNoYXJlZCBjYXRhbG9nLCB3aGljaAor CQkgKiBpcyBub3Qgc3VwcG9ydGVkIGJ5IGRvRGVsZXRpb24oKS4KKwkJICovCisJCWlmIChJc1No YXJlZFJlbGF0aW9uKG90aGVyT2JqZWN0LmNsYXNzSWQpKQorCQkJZXJlcG9ydChFUlJPUiwKKwkJ CQkJKGVycmNvZGUoRVJSQ09ERV9ERVBFTkRFTlRfT0JKRUNUU19TVElMTF9FWElTVCksCisJCQkJ CSBlcnJtc2coImNhbm5vdCBkcm9wICVzIGJlY2F1c2UgJXMgZGVwZW5kcyBvbiBpdCIsCisJCQkJ CQkJZ2V0T2JqZWN0RGVzY3JpcHRpb24ob2JqZWN0LCBmYWxzZSksCisJCQkJCQkJZ2V0T2JqZWN0 RGVzY3JpcHRpb24oJm90aGVyT2JqZWN0LCBmYWxzZSkpLAorCQkJCQkgZXJyaGludCgiRHJvcCAl cyBmaXJzdC4iLAorCQkJCQkJCSBnZXRPYmplY3REZXNjcmlwdGlvbigmb3RoZXJPYmplY3QsIGZh bHNlKSkpKTsKKwogCQkvKgogCQkgKiBXZSBkbyBuZWVkIHRvIGRlbGV0ZSBpdCwgc28gaWRlbnRp Znkgb2JqZmxhZ3MgdG8gYmUgcGFzc2VkIGRvd24sCiAJCSAqIHdoaWNoIGRlcGVuZCBvbiB0aGUg ZGVwZW5kZW5jeSB0eXBlLgpAQCAtMTU3OSw3ICsxNTgxLDcgQEAgQWNxdWlyZURlbGV0aW9uTG9j ayhjb25zdCBPYmplY3RBZGRyZXNzICpvYmplY3QsIGludCBmbGFncykKIAkJZWxzZQogCQkJTG9j a1JlbGF0aW9uT2lkKG9iamVjdC0+b2JqZWN0SWQsIEFjY2Vzc0V4Y2x1c2l2ZUxvY2spOwogCX0K LQllbHNlIGlmIChvYmplY3QtPmNsYXNzSWQgPT0gQXV0aE1lbVJlbGF0aW9uSWQpCisJZWxzZSBp ZiAoSXNTaGFyZWRSZWxhdGlvbihvYmplY3QtPmNsYXNzSWQpKQogCQlMb2NrU2hhcmVkT2JqZWN0 KG9iamVjdC0+Y2xhc3NJZCwgb2JqZWN0LT5vYmplY3RJZCwgMCwKIAkJCQkJCSBBY2Nlc3NFeGNs dXNpdmVMb2NrKTsKIAllbHNlCkBAIC0xNjAwLDcgKzE2MDIsNyBAQCBSZWxlYXNlRGVsZXRpb25M b2NrKGNvbnN0IE9iamVjdEFkZHJlc3MgKm9iamVjdCkKIHsKIAlpZiAob2JqZWN0LT5jbGFzc0lk ID09IFJlbGF0aW9uUmVsYXRpb25JZCkKIAkJVW5sb2NrUmVsYXRpb25PaWQob2JqZWN0LT5vYmpl Y3RJZCwgQWNjZXNzRXhjbHVzaXZlTG9jayk7Ci0JZWxzZSBpZiAob2JqZWN0LT5jbGFzc0lkID09 IEF1dGhNZW1SZWxhdGlvbklkKQorCWVsc2UgaWYgKElzU2hhcmVkUmVsYXRpb24ob2JqZWN0LT5j bGFzc0lkKSkKIAkJVW5sb2NrU2hhcmVkT2JqZWN0KG9iamVjdC0+Y2xhc3NJZCwgb2JqZWN0LT5v YmplY3RJZCwgMCwKIAkJCQkJCSAgIEFjY2Vzc0V4Y2x1c2l2ZUxvY2spOwogCWVsc2UKZGlmZiAt LWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3Vic2NyaXB0aW9uLm91dCBiL3NyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3Vic2NyaXB0aW9uLm91dAppbmRleCAxYmI3ODVmNGY5Zi4u MjU5ZGI3NDczMzQgMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3Vic2Ny aXB0aW9uLm91dAorKysgYi9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N1YnNjcmlwdGlvbi5v dXQKQEAgLTIwNSw2ICsyMDUsMTAgQEAgQUxURVIgRk9SRUlHTiBEQVRBIFdSQVBQRVIgdGVzdF9m ZHcgQ09OTkVDVElPTiB0ZXN0X2Zkd19jb25uZWN0aW9uOwogV0FSTklORzogIGNoYW5naW5nIHRo ZSBmb3JlaWduLWRhdGEgd3JhcHBlciBjb25uZWN0aW9uIGZ1bmN0aW9uIGNhbiBjYXVzZSB0aGUg b3B0aW9ucyBmb3IgZGVwZW5kZW50IG9iamVjdHMgdG8gYmVjb21lIGludmFsaWQKIERST1AgVVNF UiBNQVBQSU5HIEZPUiByZWdyZXNzX3N1YnNjcmlwdGlvbl91c2VyMiBTRVJWRVIgdGVzdF9zZXJ2 ZXI7CiBSRVZPS0UgVVNBR0UgT04gRk9SRUlHTiBTRVJWRVIgdGVzdF9zZXJ2ZXIgRlJPTSByZWdy ZXNzX3N1YnNjcmlwdGlvbl91c2VyMjsKKy0tIGZhaWwsIHN1YnNjcmlwdGlvbiBkZXBlbmRzIG9u IHRoZSBzZXJ2ZXIgYW5kIGNhbm5vdCBiZSBkcm9wcGVkIGJ5IENBU0NBREUKK0RST1AgU0VSVkVS IHRlc3Rfc2VydmVyIENBU0NBREU7CitFUlJPUjogIGNhbm5vdCBkcm9wIHNlcnZlciB0ZXN0X3Nl cnZlciBiZWNhdXNlIHN1YnNjcmlwdGlvbiByZWdyZXNzX3Rlc3RzdWI2IGRlcGVuZHMgb24gaXQK K0hJTlQ6ICBEcm9wIHN1YnNjcmlwdGlvbiByZWdyZXNzX3Rlc3RzdWI2IGZpcnN0LgogUkVWT0tF IFVTQUdFIE9OIEZPUkVJR04gU0VSVkVSIHRlc3Rfc2VydmVyIEZST00gcmVncmVzc19zdWJzY3Jp cHRpb25fdXNlcjM7CiBTRVQgU0VTU0lPTiBBVVRIT1JJWkFUSU9OIHJlZ3Jlc3Nfc3Vic2NyaXB0 aW9uX3VzZXIzOwogLS0gb2ssIGxhY2tzIFVTQUdFIG9uIHRlc3Rfc2VydmVyLCBidXQgcmVwbGFj aW5nIGNvbm5lY3Rpb24gYW55d2F5CmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9z dWJzY3JpcHRpb24uc3FsIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3Vic2NyaXB0aW9uLnNxbApp bmRleCBmMTk3NDBmZGZiOC4uNzcxOGM3NDI5NzQgMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jl c3Mvc3FsL3N1YnNjcmlwdGlvbi5zcWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3Vic2Ny aXB0aW9uLnNxbApAQCAtMTUwLDYgKzE1MCw4IEBAIEFMVEVSIFNVQlNDUklQVElPTiByZWdyZXNz X3Rlc3RzdWI2IE9XTkVSIFRPIHJlZ3Jlc3Nfc3Vic2NyaXB0aW9uX3VzZXIyOwogQUxURVIgRk9S RUlHTiBEQVRBIFdSQVBQRVIgdGVzdF9mZHcgQ09OTkVDVElPTiB0ZXN0X2Zkd19jb25uZWN0aW9u OwogRFJPUCBVU0VSIE1BUFBJTkcgRk9SIHJlZ3Jlc3Nfc3Vic2NyaXB0aW9uX3VzZXIyIFNFUlZF UiB0ZXN0X3NlcnZlcjsKIFJFVk9LRSBVU0FHRSBPTiBGT1JFSUdOIFNFUlZFUiB0ZXN0X3NlcnZl ciBGUk9NIHJlZ3Jlc3Nfc3Vic2NyaXB0aW9uX3VzZXIyOworLS0gZmFpbCwgc3Vic2NyaXB0aW9u IGRlcGVuZHMgb24gdGhlIHNlcnZlciBhbmQgY2Fubm90IGJlIGRyb3BwZWQgYnkgQ0FTQ0FERQor RFJPUCBTRVJWRVIgdGVzdF9zZXJ2ZXIgQ0FTQ0FERTsKIAogUkVWT0tFIFVTQUdFIE9OIEZPUkVJ R04gU0VSVkVSIHRlc3Rfc2VydmVyIEZST00gcmVncmVzc19zdWJzY3JpcHRpb25fdXNlcjM7CiBT RVQgU0VTU0lPTiBBVVRIT1JJWkFUSU9OIHJlZ3Jlc3Nfc3Vic2NyaXB0aW9uX3VzZXIzOwotLSAK Mi40My4wCgo= --=-x4soz5mqg2Mu8DyBvxzI Content-Disposition: attachment; filename*0=v2-0003-postgres_fdw-reject-use_scram_passthrough-for-sub.pat; filename*1=ch Content-Type: text/x-patch; name="v2-0003-postgres_fdw-reject-use_scram_passthrough-for-sub.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSA5NmJjNGU4M2I0MGZlYWY3NDc4NzEwODFhNDgzNTA5OTFiZDViNWYzIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKZWZmIERhdmlzIDxqZWZmQGotZGF2aXMuY29tPgpEYXRlOiBU dWUsIDI4IEp1bCAyMDI2IDEzOjUwOjI5IC0wNzAwClN1YmplY3Q6IFtQQVRDSCB2MiAzLzNdIHBv c3RncmVzX2ZkdzogcmVqZWN0IHVzZV9zY3JhbV9wYXNzdGhyb3VnaCBmb3IKIHN1YnNjcmlwdGlv bnMuCgpUaGUgc3Vic2NyaXB0aW9uIGlzIGluaXRpYXRlZCBmcm9tIGEgbG9pY2FsIHJlcGxpY2F0 aW9uIHdvcmtlciwgc28KU0NSQU0gcGFzcy10aHJvdWdoIHdvbid0IHdvcmsuCgpSZXNvbHZlcyBm aW5kaW5nIDMgaW4gcmVwb3J0LgoKUmVwb3J0ZWQtYnk6IE5vYWggTWlzY2ggPG5vYWhAbGVhZGJv YXQuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzIwMjYwNzEwMTk1OTAyLjRm Lm5vYWhtaXNjaEBtaWNyb3NvZnQuY29tCkJhY2twYXRjaC10aHJvdWdoOiAxOQotLS0KIGNvbnRy aWIvcG9zdGdyZXNfZmR3L2Nvbm5lY3Rpb24uYyAgICAgICAgICB8IDEyICsrKysrKysrKysrKwog Y29udHJpYi9wb3N0Z3Jlc19mZHcvdC8wMTBfc3Vic2NyaXB0aW9uLnBsIHwgMTQgKysrKysrKysr KysrKy0KIGRvYy9zcmMvc2dtbC9wb3N0Z3Jlcy1mZHcuc2dtbCAgICAgICAgICAgICB8ICA3ICsr KysrKysKIDMgZmlsZXMgY2hhbmdlZCwgMzIgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoK ZGlmZiAtLWdpdCBhL2NvbnRyaWIvcG9zdGdyZXNfZmR3L2Nvbm5lY3Rpb24uYyBiL2NvbnRyaWIv cG9zdGdyZXNfZmR3L2Nvbm5lY3Rpb24uYwppbmRleCBhYWIyMTY5NTk3OS4uMDk0ZWFjMmYzNDMg MTAwNjQ0Ci0tLSBhL2NvbnRyaWIvcG9zdGdyZXNfZmR3L2Nvbm5lY3Rpb24uYworKysgYi9jb250 cmliL3Bvc3RncmVzX2Zkdy9jb25uZWN0aW9uLmMKQEAgLTI0NzksNiArMjQ3OSwxOCBAQCBwb3N0 Z3Jlc19mZHdfY29ubmVjdGlvbihQR19GVU5DVElPTl9BUkdTKQogCWNoYXIJICAgKmFwcG5hbWU7 CiAJY2hhcgkgICAqc2VwID0gIiI7CiAKKwkvKgorCSAqIFNDUkFNIHBhc3MtdGhyb3VnaCBjYW5u b3Qgd29yayBmb3Igc3Vic2NyaXB0aW9ucyBiZWNhdXNlIHRoZSBjb25uZWN0aW9uCisJICogaGFw cGVucyBpbiBhIHdvcmtlciBwcm9jZXNzLgorCSAqLworCWlmIChVc2VTY3JhbVBhc3N0aHJvdWdo KHNlcnZlciwgdXNlcikpCisJCWVyZXBvcnQoRVJST1IsCisJCQkJKGVycmNvZGUoRVJSQ09ERV9G RUFUVVJFX05PVF9TVVBQT1JURUQpLAorCQkJCSBlcnJtc2coIlNDUkFNIHBhc3MtdGhyb3VnaCBh dXRoZW50aWNhdGlvbiBpcyBub3Qgc3VwcG9ydGVkIGZvciBzdWJzY3JpcHRpb24gY29ubmVjdGlv bnMiKSwKKwkJCQkgZXJyZGV0YWlsKCJUaGUgZm9yZWlnbiBzZXJ2ZXIgb3IgdXNlciBtYXBwaW5n IGZvciB1c2VyIFwiJXNcIiBoYXMgXCJ1c2Vfc2NyYW1fcGFzc3Rocm91Z2hcIiBlbmFibGVkLiIs CisJCQkJCQkgICBHZXRVc2VyTmFtZUZyb21JZCh1c2VyaWQsIGZhbHNlKSksCisJCQkJIGVycmhp bnQoIlN0b3JlIGEgcGFzc3dvcmQgaW4gdGhlIHVzZXIgbWFwcGluZyBpbnN0ZWFkLiIpKSk7CisK IAljb25zdHJ1Y3RfY29ubmVjdGlvbl9wYXJhbXMoc2VydmVyLCB1c2VyLCAma2V5d29yZHMsICZ2 YWx1ZXMsICZhcHBuYW1lKTsKIAogCWluaXRTdHJpbmdJbmZvKCZzdHIpOwpkaWZmIC0tZ2l0IGEv Y29udHJpYi9wb3N0Z3Jlc19mZHcvdC8wMTBfc3Vic2NyaXB0aW9uLnBsIGIvY29udHJpYi9wb3N0 Z3Jlc19mZHcvdC8wMTBfc3Vic2NyaXB0aW9uLnBsCmluZGV4IGMzNGIzZDE1YjhkLi41M2YxZWE3 M2VjZSAxMDA2NDQKLS0tIGEvY29udHJpYi9wb3N0Z3Jlc19mZHcvdC8wMTBfc3Vic2NyaXB0aW9u LnBsCisrKyBiL2NvbnRyaWIvcG9zdGdyZXNfZmR3L3QvMDEwX3N1YnNjcmlwdGlvbi5wbApAQCAt NDEsNyArNDEsMTkgQEAgJG5vZGVfc3Vic2NyaWJlci0+c2FmZV9wc3FsKCdwb3N0Z3JlcycsCiAp OwogCiAkbm9kZV9zdWJzY3JpYmVyLT5zYWZlX3BzcWwoJ3Bvc3RncmVzJywKLQkiQ1JFQVRFIFVT RVIgTUFQUElORyBGT1IgUFVCTElDIFNFUlZFUiB0YXBfc2VydmVyIik7CisJIkNSRUFURSBVU0VS IE1BUFBJTkcgRk9SIFBVQkxJQyBTRVJWRVIgdGFwX3NlcnZlciBPUFRJT05TICh1c2Vfc2NyYW1f cGFzc3Rocm91Z2ggJ3RydWUnKSIpOworCitteSAoJHJldCwgJHN0ZG91dCwgJHN0ZGVycikgPSAk bm9kZV9zdWJzY3JpYmVyLT5wc3FsKCdwb3N0Z3JlcycsCisJIkNSRUFURSBTVUJTQ1JJUFRJT04g dGFwX3N1YiBTRVJWRVIgdGFwX3NlcnZlciBQVUJMSUNBVElPTiB0YXBfcHViIFdJVEggKHBhc3N3 b3JkX3JlcXVpcmVkPWZhbHNlKSIpOworaXNudCgkcmV0LCAwLAorCSdDUkVBVEUgU1VCU0NSSVBU SU9OIHN1Y2NlZWRzIHdpdGggdXNlX3NjcmFtX3Bhc3N0aHJvdWdoJyk7CitsaWtlKAorCSRzdGRl cnIsCisJcXIvRVJST1IuKlNDUkFNIHBhc3MtdGhyb3VnaCBhdXRoZW50aWNhdGlvbiBpcyBub3Qg c3VwcG9ydGVkIGZvciBzdWJzY3JpcHRpb24gY29ubmVjdGlvbnMvLAorCSdDUkVBVEUgU1VCU0NS SVBUSU9OIGdpdmVzIGNvcnJlY3QgY29ubmVjdGlvbiBlcnJvcicpOworCiskbm9kZV9zdWJzY3Jp YmVyLT5zYWZlX3BzcWwoJ3Bvc3RncmVzJywKKwkiQUxURVIgVVNFUiBNQVBQSU5HIEZPUiBQVUJM SUMgU0VSVkVSIHRhcF9zZXJ2ZXIgT1BUSU9OUyAoRFJPUCB1c2Vfc2NyYW1fcGFzc3Rocm91Z2gp Iik7CiAKICRub2RlX3N1YnNjcmliZXItPnNhZmVfcHNxbCgncG9zdGdyZXMnLAogCSJDUkVBVEUg U1VCU0NSSVBUSU9OIHRhcF9zdWIgU0VSVkVSIHRhcF9zZXJ2ZXIgUFVCTElDQVRJT04gdGFwX3B1 YiBXSVRIIChwYXNzd29yZF9yZXF1aXJlZD1mYWxzZSkiCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3Nn bWwvcG9zdGdyZXMtZmR3LnNnbWwgYi9kb2Mvc3JjL3NnbWwvcG9zdGdyZXMtZmR3LnNnbWwKaW5k ZXggYjllMWIwNDQ2M2UuLjhiMDY2OWY2NzJkIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcG9z dGdyZXMtZmR3LnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3Bvc3RncmVzLWZkdy5zZ21sCkBAIC04 NjEsNiArODYxLDEzIEBAIE9QVElPTlMgKEFERCBwYXNzd29yZF9yZXF1aXJlZCAnZmFsc2UnKTsK ICAgICAgICAgICAgVGhpcyBpcyBhIHRlY2huaWNhbCByZXF1aXJlbWVudCBvZiB0aGUgU0NSQU0g cHJvdG9jb2wuCiAgICAgICAgICAgPC9wYXJhPgogICAgICAgICAgPC9saXN0aXRlbT4KKworICAg ICAgICAgPGxpc3RpdGVtPgorICAgICAgICAgIDxwYXJhPgorICAgICAgICAgICBUaGUgZm9yZWln biBzZXJ2ZXIgbXVzdCBub3QgYmUgdXNlZCBmb3Igc3Vic2NyaXB0aW9uIGNvbm5lY3Rpb25zCisg ICAgICAgICAgIChzZWUgPHhyZWYgbGlua2VuZD0icG9zdGdyZXMtZmR3LXNlcnZlci1zdWJzY3Jp cHRpb24iLz4pLgorICAgICAgICAgIDwvcGFyYT4KKyAgICAgICAgIDwvbGlzdGl0ZW0+CiAgICAg ICAgIDwvaXRlbWl6ZWRsaXN0PgogICAgICAgIDwvcGFyYT4KICAgICAgIDwvbGlzdGl0ZW0+Ci0t IAoyLjQzLjAKCg== --=-x4soz5mqg2Mu8DyBvxzI--