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 1nPNQM-0006Hc-QX for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Mar 2022 11:45:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nPNQL-0006PU-ES for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Mar 2022 11:45:41 +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 1nPNQK-0006PL-Hm for pgsql-hackers@lists.postgresql.org; Wed, 02 Mar 2022 11:45:41 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nPNQH-0007gy-7V for pgsql-hackers@lists.postgresql.org; Wed, 02 Mar 2022 11:45:39 +0000 Received: by mail-wm1-x334.google.com with SMTP id y5so988990wmi.0 for ; Wed, 02 Mar 2022 03:45:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=message-id:date:mime-version:user-agent:subject:content-language:to :cc:references:from:in-reply-to; bh=Nw3YPBXNHYFUriaCEZlDJed/9mouwncZGa0GCXwh2EA=; b=eR92JHHx0XYwAuiB+bm+ex47+w/sTNs+unzE7EN392qgQTPuDA2xekXgdxIaji7kUo xh3d5If0Bm5DNyk1SP1O1Aw68ESchJ1A+orR1vn+OkT2YVpyLwgVmkQ8IDfCzPPQQHYB +1VH9CNa5XEWHPDdyaupW8/azowgd8ytuiEDhKMf6kVVuXXtzGCxpwrcdOOqj1cDGTHs fLnFnFStOx/y74Uma6j8VzdbmVEM5M15GsJXDIlGYa1zAIKXTMbPRign3xhkhtbIGMIS Gl+TNEoM7HqFhqn0wE103gBIaOlEjUhjXWS1z7+p+pI/s1FZeNJys48xWnDw3+110+f4 v7hg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:cc:references:from:in-reply-to; bh=Nw3YPBXNHYFUriaCEZlDJed/9mouwncZGa0GCXwh2EA=; b=PcmSu39dXTx4a6OFWEw9TRmsUgIYwpu3tyX2W2Utze2M1WbkoDJ43RR8QWdH9E/Xe1 jA/01LNJOJ37jizYrvAEvEdOOpKa2GPShNayt12d+qARjCPv8DduK0SKrc3JW5CSi9+k iXyNlV7v98FfetfZxcCW4fV3ZLYVs+W0J8VyaHA72Nr7AgJVyYsi0O+fb7e8Ee8VGhrn Mt8R2/ThzXYFW11kiYqoQzDGOUFHfL1Y5eGhCXTo8ExtOixXUuAXEEtJdCXYoX2UCiMj WQya1qAzhvPFTjZmEHQ6rWl7mx01Wu8XZusIxKhBWae5VWddNg1jjsLyYINVgRcNytxT gOBQ== X-Gm-Message-State: AOAM5328VYLbFtUQDcjUEAAFVanJkj6r9xSzzZdTFtdDeUDvuoMb3J2C ucoHidjRhh1Ml0KP3kLsZpGAd3midhimBltxiWI84W6T5z0AvHTiERkrdJY3spsBlIlY16NnrGF yUBsH7pPmMcv2IKrvRDldZtuZH410qSqjabkx9chT8cZFXKrWQO/9bCoQwBrcDESTb+wuODEL26 /yV4gsb79zjCLvVDji3CHBooOxZ67YQNrPIIoQbAAzmMmqi+LzvOUy X-Google-Smtp-Source: ABdhPJy2rF8CfOOhF+tI3Qo51q6XUb01WbAVebTBuXw5bc/lGAYpCHHk0UNgKCThOFUrf3Oilda/Xg== X-Received: by 2002:a05:600c:4e08:b0:381:9094:6b3c with SMTP id b8-20020a05600c4e0800b0038190946b3cmr5589456wmq.103.1646221534440; Wed, 02 Mar 2022 03:45:34 -0800 (PST) Received: from [10.137.0.18] (ip-86-49-251-241.net.upcbroadband.cz. [86.49.251.241]) by smtp.gmail.com with ESMTPSA id d18-20020adff2d2000000b001f025ea3a20sm3325515wrp.0.2022.03.02.03.45.32 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 02 Mar 2022 03:45:33 -0800 (PST) Content-Type: multipart/mixed; boundary="------------kzICbYZk4m6jNSy3WR4YU0UN" Message-ID: <6bdbd7fc-e81a-9a77-d963-24adeb95f29e@enterprisedb.com> Date: Wed, 2 Mar 2022 12:45:30 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.5.0 Subject: Re: row filtering for logical replication Content-Language: en-US To: Amit Kapila , Euler Taveira Cc: "houzj.fnst@fujitsu.com" , Peter Smith , Alvaro Herrera , Greg Nancarrow , vignesh C , Ajin Cherian , "tanghy.fnst@fujitsu.com" , Dilip Kumar , Rahila Syed , Peter Eisentraut , =?UTF-8?B?w5ZuZGVyIEthbGFjxLE=?= , japin , Michael Paquier , David Steele , Craig Ringer , Amit Langote , PostgreSQL Hackers References: <8da43807-06d8-44a5-a69a-fdea623622de@www.fastmail.com> From: Tomas Vondra In-Reply-To: X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------kzICbYZk4m6jNSy3WR4YU0UN Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi, While working on the column filtering patch, which touches about the same places, I noticed two minor gaps in testing: 1) The regression tests do perform multiple ALTER PUBLICATION commands, tweaking the row filter. But there are no checks the row filter was actually modified / stored in the catalog. It might be just thrown away and no one would notice. 2) There are no pg_dump tests. So attached are two trivial patched, addressing this. The first one adds a couple \dRp and \d commands, to show what the catalogs contain. The second one adds a simple pg_dump test. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --------------kzICbYZk4m6jNSy3WR4YU0UN Content-Type: text/x-patch; charset=UTF-8; name="0001-Verify-changing-WHERE-condition-for-a-publi-20220302.patch" Content-Disposition: attachment; filename*0="0001-Verify-changing-WHERE-condition-for-a-publi-20220302.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSBlNzgxZjg0MGUzODcwMWM2M2Q4YjU3ZmYzNmJkNTIwZjJjY2VkNmFkIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBUb21hcyBWb25kcmEgPHRvbWFzQDJuZHF1YWRyYW50 LmNvbT4KRGF0ZTogU2F0LCAyNiBGZWIgMjAyMiAxNzozMzowOSArMDEwMApTdWJqZWN0OiBb UEFUQ0ggMS8zXSBWZXJpZnkgY2hhbmdpbmcgV0hFUkUgY29uZGl0aW9uIGZvciBhIHB1Ymxp Y2F0aW9uCgpDb21taXQgNTJlNGYwY2Q0NyBhZGRlZCBzdXBwb3J0IGZvciByb3cgZmlsdGVy cyBpbiBsb2dpY2FsIHJlcGxpY2F0aW9uLAppbmNsdWRpbmcgcmVncmVzc2lvbiB0ZXN0cyB3 aXRoIG11bHRpcGxlIEFMVEVSIFBVQkxJQ0FUSU9OIGNvbW1hbmRzLAptb2RpZnlpbmcgdGhl IHJvdyBmaWx0ZXIuIEJ1dCB0aGUgdGVzdHMgbmV2ZXIgdmVyaWZpZWQgdGhhdCB0aGUgcm93 CmZpbHRlciB3YXMgYWN0dWFsbHkgdXBkYXRlZCBpbiB0aGUgY2F0YWxvZy4gVGhpcyBhZGRz IGEgY291cGxlIFxkIGFuZApcZFJwIGNvbW1hbmRzLCB0byB2ZXJpZnkgdGhlIGNhdGFsb2cg d2FzIHVwZGF0ZWQuCi0tLQogc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wdWJsaWNhdGlv bi5vdXQgfCA2NiArKysrKysrKysrKysrKysrKysrKysrKwogc3JjL3Rlc3QvcmVncmVzcy9z cWwvcHVibGljYXRpb24uc3FsICAgICAgfCAgOCArKysKIDIgZmlsZXMgY2hhbmdlZCwgNzQg aW5zZXJ0aW9ucygrKQoKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv cHVibGljYXRpb24ub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wdWJsaWNhdGlv bi5vdXQKaW5kZXggM2MzODJlNTIwZTQuLjIyN2NlNzU5NDg2IDEwMDY0NAotLS0gYS9zcmMv dGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0aW9uLm91dAorKysgYi9zcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0aW9uLm91dApAQCAtMzk1LDE1ICszOTUsODEgQEAg TElORSAxOiAuLi5JQ0FUSU9OIHRlc3RwdWI1IEFERCBUQUJMRSB0ZXN0cHViX3JmX3RibDEg V0hFUkUgKGIgPCAnMicgQ08uLi4KIERFVEFJTDogIFVzZXItZGVmaW5lZCBjb2xsYXRpb25z IGFyZSBub3QgYWxsb3dlZC4KIC0tIG9rIC0gTlVMTElGIGlzIGFsbG93ZWQKIEFMVEVSIFBV QkxJQ0FUSU9OIHRlc3RwdWI1IFNFVCBUQUJMRSB0ZXN0cHViX3JmX3RibDEgV0hFUkUgKE5V TExJRigxLDIpID0gYSk7CitcZCsgdGVzdHB1Yl9yZl90YmwxCisgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBUYWJsZSAicHVibGljLnRlc3RwdWJfcmZfdGJsMSIKKyBDb2x1bW4g fCAgVHlwZSAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwgU3RvcmFnZSAg fCBTdGF0cyB0YXJnZXQgfCBEZXNjcmlwdGlvbiAKKy0tLS0tLS0tKy0tLS0tLS0tLSstLS0t LS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0KKyBhICAgICAgfCBpbnRlZ2VyIHwgICAgICAgICAgIHwgICAgICAg ICAgfCAgICAgICAgIHwgcGxhaW4gICAgfCAgICAgICAgICAgICAgfCAKKyBiICAgICAgfCB0 ZXh0ICAgIHwgICAgICAgICAgIHwgICAgICAgICAgfCAgICAgICAgIHwgZXh0ZW5kZWQgfCAg ICAgICAgICAgICAgfCAKK1B1YmxpY2F0aW9uczoKKyAgICAidGVzdHB1YjUiIFdIRVJFIChO VUxMSUYoMSwgMikgPSBhKQorCitcZFJwKyB0ZXN0cHViNQorICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgUHVibGljYXRpb24gdGVzdHB1YjUKKyAgICAgICAgICBPd25l ciAgICAgICAgICAgfCBBbGwgdGFibGVzIHwgSW5zZXJ0cyB8IFVwZGF0ZXMgfCBEZWxldGVz IHwgVHJ1bmNhdGVzIHwgVmlhIHJvb3QgCistLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0r LS0tLS0tLS0tLQorIHJlZ3Jlc3NfcHVibGljYXRpb25fdXNlciB8IGYgICAgICAgICAgfCB0 ICAgICAgIHwgZiAgICAgICB8IGYgICAgICAgfCBmICAgICAgICAgfCBmCitUYWJsZXM6Cisg ICAgInB1YmxpYy50ZXN0cHViX3JmX3RibDEiIFdIRVJFIChOVUxMSUYoMSwgMikgPSBhKQor CiAtLSBvayAtIGJ1aWx0LWluIG9wZXJhdG9ycyBhcmUgYWxsb3dlZAogQUxURVIgUFVCTElD QVRJT04gdGVzdHB1YjUgU0VUIFRBQkxFIHRlc3RwdWJfcmZfdGJsMSBXSEVSRSAoYSBJUyBO VUxMKTsKK1xkKyB0ZXN0cHViX3JmX3RibDEKKyAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIFRhYmxlICJwdWJsaWMudGVzdHB1Yl9yZl90YmwxIgorIENvbHVtbiB8ICBUeXBlICAg fCBDb2xsYXRpb24gfCBOdWxsYWJsZSB8IERlZmF1bHQgfCBTdG9yYWdlICB8IFN0YXRzIHRh cmdldCB8IERlc2NyaXB0aW9uIAorLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0t LS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0t LS0tLQorIGEgICAgICB8IGludGVnZXIgfCAgICAgICAgICAgfCAgICAgICAgICB8ICAgICAg ICAgfCBwbGFpbiAgICB8ICAgICAgICAgICAgICB8IAorIGIgICAgICB8IHRleHQgICAgfCAg ICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfCBleHRlbmRlZCB8ICAgICAgICAgICAg ICB8IAorUHVibGljYXRpb25zOgorICAgICJ0ZXN0cHViNSIgV0hFUkUgKGEgSVMgTlVMTCkK KworXGRScCsgdGVzdHB1YjUKKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IFB1YmxpY2F0aW9uIHRlc3RwdWI1CisgICAgICAgICAgT3duZXIgICAgICAgICAgIHwgQWxs IHRhYmxlcyB8IEluc2VydHMgfCBVcGRhdGVzIHwgRGVsZXRlcyB8IFRydW5jYXRlcyB8IFZp YSByb290IAorLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0t LS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0KKyByZWdy ZXNzX3B1YmxpY2F0aW9uX3VzZXIgfCBmICAgICAgICAgIHwgdCAgICAgICB8IGYgICAgICAg fCBmICAgICAgIHwgZiAgICAgICAgIHwgZgorVGFibGVzOgorICAgICJwdWJsaWMudGVzdHB1 Yl9yZl90YmwxIiBXSEVSRSAoYSBJUyBOVUxMKQorCiBBTFRFUiBQVUJMSUNBVElPTiB0ZXN0 cHViNSBTRVQgVEFCTEUgdGVzdHB1Yl9yZl90YmwxIFdIRVJFICgoYSA+IDUpIElTIEZBTFNF KTsKIEFMVEVSIFBVQkxJQ0FUSU9OIHRlc3RwdWI1IFNFVCBUQUJMRSB0ZXN0cHViX3JmX3Ri bDEgV0hFUkUgKGEgSVMgRElTVElOQ1QgRlJPTSA1KTsKIEFMVEVSIFBVQkxJQ0FUSU9OIHRl c3RwdWI1IFNFVCBUQUJMRSB0ZXN0cHViX3JmX3RibDEgV0hFUkUgKChhLCBhICsgMSkgPCAo MiwgMykpOwogLS0gb2sgLSBidWlsdC1pbiB0eXBlIGNvZXJjaW9ucyBiZXR3ZWVuIHR3byBi aW5hcnkgY29tcGF0aWJsZSBkYXRhdHlwZXMgYXJlIGFsbG93ZWQKIEFMVEVSIFBVQkxJQ0FU SU9OIHRlc3RwdWI1IFNFVCBUQUJMRSB0ZXN0cHViX3JmX3RibDEgV0hFUkUgKGI6OnZhcmNo YXIgPCAnMicpOworXGQrIHRlc3RwdWJfcmZfdGJsMQorICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgVGFibGUgInB1YmxpYy50ZXN0cHViX3JmX3RibDEiCisgQ29sdW1uIHwgIFR5 cGUgICB8IENvbGxhdGlvbiB8IE51bGxhYmxlIHwgRGVmYXVsdCB8IFN0b3JhZ2UgIHwgU3Rh dHMgdGFyZ2V0IHwgRGVzY3JpcHRpb24gCistLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0t LS0rLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0tCisgYSAgICAgIHwgaW50ZWdlciB8ICAgICAgICAgICB8ICAgICAgICAgIHwg ICAgICAgICB8IHBsYWluICAgIHwgICAgICAgICAgICAgIHwgCisgYiAgICAgIHwgdGV4dCAg ICB8ICAgICAgICAgICB8ICAgICAgICAgIHwgICAgICAgICB8IGV4dGVuZGVkIHwgICAgICAg ICAgICAgIHwgCitQdWJsaWNhdGlvbnM6CisgICAgInRlc3RwdWI1IiBXSEVSRSAoKChiKTo6 Y2hhcmFjdGVyIHZhcnlpbmcpOjp0ZXh0IDwgJzInOjp0ZXh0KQorCitcZFJwKyB0ZXN0cHVi NQorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUHVibGljYXRpb24gdGVz dHB1YjUKKyAgICAgICAgICBPd25lciAgICAgICAgICAgfCBBbGwgdGFibGVzIHwgSW5zZXJ0 cyB8IFVwZGF0ZXMgfCBEZWxldGVzIHwgVHJ1bmNhdGVzIHwgVmlhIHJvb3QgCistLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLSst LS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLQorIHJlZ3Jlc3NfcHVibGljYXRpb25f dXNlciB8IGYgICAgICAgICAgfCB0ICAgICAgIHwgZiAgICAgICB8IGYgICAgICAgfCBmICAg ICAgICAgfCBmCitUYWJsZXM6CisgICAgInB1YmxpYy50ZXN0cHViX3JmX3RibDEiIFdIRVJF ICgoKGIpOjpjaGFyYWN0ZXIgdmFyeWluZyk6OnRleHQgPCAnMic6OnRleHQpCisKIC0tIG9r IC0gaW1tdXRhYmxlIGJ1aWx0LWluIGZ1bmN0aW9ucyBhcmUgYWxsb3dlZAogQUxURVIgUFVC TElDQVRJT04gdGVzdHB1YjUgU0VUIFRBQkxFIHRlc3RwdWJfcmZfdGJsNCBXSEVSRSAobGVu Z3RoKGcpIDwgNik7CitcZCsgdGVzdHB1Yl9yZl90YmwxCisgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBUYWJsZSAicHVibGljLnRlc3RwdWJfcmZfdGJsMSIKKyBDb2x1bW4gfCAg VHlwZSAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBEZWZhdWx0IHwgU3RvcmFnZSAgfCBT dGF0cyB0YXJnZXQgfCBEZXNjcmlwdGlvbiAKKy0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0t LS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0t LS0tLS0tLS0tLS0KKyBhICAgICAgfCBpbnRlZ2VyIHwgICAgICAgICAgIHwgICAgICAgICAg fCAgICAgICAgIHwgcGxhaW4gICAgfCAgICAgICAgICAgICAgfCAKKyBiICAgICAgfCB0ZXh0 ICAgIHwgICAgICAgICAgIHwgICAgICAgICAgfCAgICAgICAgIHwgZXh0ZW5kZWQgfCAgICAg ICAgICAgICAgfCAKKworXGRScCsgdGVzdHB1YjUKKyAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIFB1YmxpY2F0aW9uIHRlc3RwdWI1CisgICAgICAgICAgT3duZXIgICAg ICAgICAgIHwgQWxsIHRhYmxlcyB8IEluc2VydHMgfCBVcGRhdGVzIHwgRGVsZXRlcyB8IFRy dW5jYXRlcyB8IFZpYSByb290IAorLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0t LS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0t LS0tLS0KKyByZWdyZXNzX3B1YmxpY2F0aW9uX3VzZXIgfCBmICAgICAgICAgIHwgdCAgICAg ICB8IGYgICAgICAgfCBmICAgICAgIHwgZiAgICAgICAgIHwgZgorVGFibGVzOgorICAgICJw dWJsaWMudGVzdHB1Yl9yZl90Ymw0IiBXSEVSRSAobGVuZ3RoKGcpIDwgNikKKwogLS0gZmFp bCAtIHVzZXItZGVmaW5lZCB0eXBlcyBhcmUgbm90IGFsbG93ZWQKIENSRUFURSBUWVBFIHJm X2J1Z19zdGF0dXMgQVMgRU5VTSAoJ25ldycsICdvcGVuJywgJ2Nsb3NlZCcpOwogQ1JFQVRF IFRBQkxFIHJmX2J1ZyAoaWQgc2VyaWFsLCBkZXNjcmlwdGlvbiB0ZXh0LCBzdGF0dXMgcmZf YnVnX3N0YXR1cyk7CmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9wdWJsaWNh dGlvbi5zcWwgYi9zcmMvdGVzdC9yZWdyZXNzL3NxbC9wdWJsaWNhdGlvbi5zcWwKaW5kZXgg M2YwNGQzNDI2NGEuLmNkN2UwMTgyNzE2IDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNz L3NxbC9wdWJsaWNhdGlvbi5zcWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvcHVibGlj YXRpb24uc3FsCkBAIC0yMDMsMTUgKzIwMywyMyBAQCBDUkVBVEUgQ09MTEFUSU9OIHVzZXJf Y29sbGF0aW9uIEZST00gIkMiOwogQUxURVIgUFVCTElDQVRJT04gdGVzdHB1YjUgQUREIFRB QkxFIHRlc3RwdWJfcmZfdGJsMSBXSEVSRSAoYiA8ICcyJyBDT0xMQVRFIHVzZXJfY29sbGF0 aW9uKTsKIC0tIG9rIC0gTlVMTElGIGlzIGFsbG93ZWQKIEFMVEVSIFBVQkxJQ0FUSU9OIHRl c3RwdWI1IFNFVCBUQUJMRSB0ZXN0cHViX3JmX3RibDEgV0hFUkUgKE5VTExJRigxLDIpID0g YSk7CitcZCsgdGVzdHB1Yl9yZl90YmwxCitcZFJwKyB0ZXN0cHViNQogLS0gb2sgLSBidWls dC1pbiBvcGVyYXRvcnMgYXJlIGFsbG93ZWQKIEFMVEVSIFBVQkxJQ0FUSU9OIHRlc3RwdWI1 IFNFVCBUQUJMRSB0ZXN0cHViX3JmX3RibDEgV0hFUkUgKGEgSVMgTlVMTCk7CitcZCsgdGVz dHB1Yl9yZl90YmwxCitcZFJwKyB0ZXN0cHViNQogQUxURVIgUFVCTElDQVRJT04gdGVzdHB1 YjUgU0VUIFRBQkxFIHRlc3RwdWJfcmZfdGJsMSBXSEVSRSAoKGEgPiA1KSBJUyBGQUxTRSk7 CiBBTFRFUiBQVUJMSUNBVElPTiB0ZXN0cHViNSBTRVQgVEFCTEUgdGVzdHB1Yl9yZl90Ymwx IFdIRVJFIChhIElTIERJU1RJTkNUIEZST00gNSk7CiBBTFRFUiBQVUJMSUNBVElPTiB0ZXN0 cHViNSBTRVQgVEFCTEUgdGVzdHB1Yl9yZl90YmwxIFdIRVJFICgoYSwgYSArIDEpIDwgKDIs IDMpKTsKIC0tIG9rIC0gYnVpbHQtaW4gdHlwZSBjb2VyY2lvbnMgYmV0d2VlbiB0d28gYmlu YXJ5IGNvbXBhdGlibGUgZGF0YXR5cGVzIGFyZSBhbGxvd2VkCiBBTFRFUiBQVUJMSUNBVElP TiB0ZXN0cHViNSBTRVQgVEFCTEUgdGVzdHB1Yl9yZl90YmwxIFdIRVJFIChiOjp2YXJjaGFy IDwgJzInKTsKK1xkKyB0ZXN0cHViX3JmX3RibDEKK1xkUnArIHRlc3RwdWI1CiAtLSBvayAt IGltbXV0YWJsZSBidWlsdC1pbiBmdW5jdGlvbnMgYXJlIGFsbG93ZWQKIEFMVEVSIFBVQkxJ Q0FUSU9OIHRlc3RwdWI1IFNFVCBUQUJMRSB0ZXN0cHViX3JmX3RibDQgV0hFUkUgKGxlbmd0 aChnKSA8IDYpOworXGQrIHRlc3RwdWJfcmZfdGJsMQorXGRScCsgdGVzdHB1YjUKIC0tIGZh aWwgLSB1c2VyLWRlZmluZWQgdHlwZXMgYXJlIG5vdCBhbGxvd2VkCiBDUkVBVEUgVFlQRSBy Zl9idWdfc3RhdHVzIEFTIEVOVU0gKCduZXcnLCAnb3BlbicsICdjbG9zZWQnKTsKIENSRUFU RSBUQUJMRSByZl9idWcgKGlkIHNlcmlhbCwgZGVzY3JpcHRpb24gdGV4dCwgc3RhdHVzIHJm X2J1Z19zdGF0dXMpOwotLSAKMi4zNC4xCgo= --------------kzICbYZk4m6jNSy3WR4YU0UN Content-Type: text/x-patch; charset=UTF-8; name="0002-Test-publication-row-filters-in-pg_dump-tes-20220302.patch" Content-Disposition: attachment; filename*0="0002-Test-publication-row-filters-in-pg_dump-tes-20220302.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSA4ZWU2N2RkNTJhMWZjMDg4MzdhYTg1OTc5ZGZjMDg0MmNjOTY4MDEyIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBUb21hcyBWb25kcmEgPHRvbWFzLnZvbmRyYUBwb3N0 Z3Jlc3FsLm9yZz4KRGF0ZTogVHVlLCAxIE1hciAyMDIyIDE1OjI1OjU2ICswMTAwClN1Ympl Y3Q6IFtQQVRDSCAyLzNdIFRlc3QgcHVibGljYXRpb24gcm93IGZpbHRlcnMgaW4gcGdfZHVt cCB0ZXN0cwoKQ29tbWl0IDUyZTRmMGNkNDcgYWRkZWQgc3VwcG9ydCBmb3Igcm93IGZpbHRl cnMgd2hlbiByZXBsaWNhdGluZyB0YWJsZXMsCmJ1dCB0aGUgY29tbWl0IGFkZGVkIG5vIHBn X2R1bXAgdGVzdHMgZm9yIHRoaXMgZmVhdHVyZS4gU28gYWRkIGF0IGxlYXN0CmEgc2ltcGxl IHRlc3QuCi0tLQogc3JjL2Jpbi9wZ19kdW1wL3QvMDAyX3BnX2R1bXAucGwgfCA2ICsrKy0t LQogMSBmaWxlIGNoYW5nZWQsIDMgaW5zZXJ0aW9ucygrKSwgMyBkZWxldGlvbnMoLSkKCmRp ZmYgLS1naXQgYS9zcmMvYmluL3BnX2R1bXAvdC8wMDJfcGdfZHVtcC5wbCBiL3NyYy9iaW4v cGdfZHVtcC90LzAwMl9wZ19kdW1wLnBsCmluZGV4IGRkMDY1Yzc1OGZhLi5jM2JjZWY4YzBl YyAxMDA2NDQKLS0tIGEvc3JjL2Jpbi9wZ19kdW1wL3QvMDAyX3BnX2R1bXAucGwKKysrIGIv c3JjL2Jpbi9wZ19kdW1wL3QvMDAyX3BnX2R1bXAucGwKQEAgLTI0MDcsMTIgKzI0MDcsMTIg QEAgbXkgJXRlc3RzID0gKAogCQl9LAogCX0sCiAKLQknQUxURVIgUFVCTElDQVRJT04gcHVi MSBBREQgVEFCTEUgdGVzdF9zZWNvbmRfdGFibGUnID0+IHsKKwknQUxURVIgUFVCTElDQVRJ T04gcHViMSBBREQgVEFCTEUgdGVzdF9zZWNvbmRfdGFibGUgV0hFUkUgKGNvbDEgPSAxKScg PT4gewogCQljcmVhdGVfb3JkZXIgPT4gNTIsCiAJCWNyZWF0ZV9zcWwgPT4KLQkJICAnQUxU RVIgUFVCTElDQVRJT04gcHViMSBBREQgVEFCTEUgZHVtcF90ZXN0LnRlc3Rfc2Vjb25kX3Rh YmxlOycsCisJCSAgJ0FMVEVSIFBVQkxJQ0FUSU9OIHB1YjEgQUREIFRBQkxFIGR1bXBfdGVz dC50ZXN0X3NlY29uZF90YWJsZSBXSEVSRSAoY29sMSA9IDEpOycsCiAJCXJlZ2V4cCA9PiBx ci9eCi0JCQlcUUFMVEVSIFBVQkxJQ0FUSU9OIHB1YjEgQUREIFRBQkxFIE9OTFkgZHVtcF90 ZXN0LnRlc3Rfc2Vjb25kX3RhYmxlO1xFCisJCQlcUUFMVEVSIFBVQkxJQ0FUSU9OIHB1YjEg QUREIFRBQkxFIE9OTFkgZHVtcF90ZXN0LnRlc3Rfc2Vjb25kX3RhYmxlIFdIRVJFICgoY29s MSA9IDEpKTtcRQogCQkJL3htLAogCQlsaWtlID0+IHsgJWZ1bGxfcnVucywgc2VjdGlvbl9w b3N0X2RhdGEgPT4gMSwgfSwKIAkJdW5saWtlID0+IHsgZXhjbHVkZV9kdW1wX3Rlc3Rfc2No ZW1hID0+IDEsIH0sCi0tIAoyLjM0LjEKCg== --------------kzICbYZk4m6jNSy3WR4YU0UN--