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 1nMLK3-00075X-1f for pgsql-committers@arkaria.postgresql.org; Tue, 22 Feb 2022 02:54:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nMLK1-0002og-Om for pgsql-committers@arkaria.postgresql.org; Tue, 22 Feb 2022 02:54:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nMLK1-0002oX-B0 for pgsql-committers@lists.postgresql.org; Tue, 22 Feb 2022 02:54:37 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nMLJy-0005fj-77 for pgsql-committers@lists.postgresql.org; Tue, 22 Feb 2022 02:54:37 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=LTSiBXjiL3QC+SYBr/aMmM6Ma/KmN2VBYpDzHvkt4v0=; b=mF2ywC8F7faKEFSDuroH40GxiM nbSj3GfeVCVqA3jH3heF+ppDnj8Eh/otBaDDMqx7boqAwZTZADmSt/E02v05MycXQ1/UUvUXrc/Nz +QWvBdq5PsK68WGDAsoFtzPT3pwEqUcBHsX+pkoT8cpm0V5kbRrYEieTNl7Sdpmyu+L+DnUMwWStK GEpoUKzDo9F06YPUVq8pOYGJExoJkwUhEjg8pTw2SG3QrWC/v/5I0hLtf8Cvo07i3SSeFhEkLTxkA 0d/T623GL9eX/XXuxp+CjQfjBzNQchvKr/swXj8v1jWPKL4CVeVzr1ErMjb1Zjbw/XESLyY0fBCSA ns2sx2Ow==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nMLJw-0004rB-TL for pgsql-committers@lists.postgresql.org; Tue, 22 Feb 2022 02:54:32 +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 1nMLJw-0004bf-Vg for pgsql-committers@lists.postgresql.org; Tue, 22 Feb 2022 02:54:32 +0000 Content-Type: multipart/mixed; boundary="===============4188805537616253193==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: Allow specifying row filters for logical replication of tables. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 22 Feb 2022 02:54:32 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4188805537616253193== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgc3BlY2lmeWluZyByb3cgZmlsdGVycyBmb3IgbG9naWNhbCByZXBsaWNhdGlvbiBvZiB0 YWJsZXMuCgpUaGlzIGZlYXR1cmUgYWRkcyByb3cgZmlsdGVyaW5nIGZvciBwdWJsaWNhdGlvbiB0 YWJsZXMuIFdoZW4gYSBwdWJsaWNhdGlvbgppcyBkZWZpbmVkIG9yIG1vZGlmaWVkLCBhbiBvcHRp b25hbCBXSEVSRSBjbGF1c2UgY2FuIGJlIHNwZWNpZmllZC4gUm93cwp0aGF0IGRvbid0IHNhdGlz ZnkgdGhpcyBXSEVSRSBjbGF1c2Ugd2lsbCBiZSBmaWx0ZXJlZCBvdXQuIFRoaXMgYWxsb3dzIGEK c2V0IG9mIHRhYmxlcyB0byBiZSBwYXJ0aWFsbHkgcmVwbGljYXRlZC4gVGhlIHJvdyBmaWx0ZXIg aXMgcGVyIHRhYmxlLiBBCm5ldyByb3cgZmlsdGVyIGNhbiBiZSBhZGRlZCBzaW1wbHkgYnkgc3Bl Y2lmeWluZyBhIFdIRVJFIGNsYXVzZSBhZnRlciB0aGUKdGFibGUgbmFtZS4gVGhlIFdIRVJFIGNs YXVzZSBtdXN0IGJlIGVuY2xvc2VkIGJ5IHBhcmVudGhlc2VzLgoKVGhlIHJvdyBmaWx0ZXIgV0hF UkUgY2xhdXNlIGZvciBhIHRhYmxlIGFkZGVkIHRvIGEgcHVibGljYXRpb24gdGhhdApwdWJsaXNo ZXMgVVBEQVRFIGFuZC9vciBERUxFVEUgb3BlcmF0aW9ucyBtdXN0IGNvbnRhaW4gb25seSBjb2x1 bW5zIHRoYXQKYXJlIGNvdmVyZWQgYnkgUkVQTElDQSBJREVOVElUWS4gVGhlIHJvdyBmaWx0ZXIg V0hFUkUgY2xhdXNlIGZvciBhIHRhYmxlCmFkZGVkIHRvIGEgcHVibGljYXRpb24gdGhhdCBwdWJs aXNoZXMgSU5TRVJUIGNhbiB1c2UgYW55IGNvbHVtbi4gSWYgdGhlCnJvdyBmaWx0ZXIgZXZhbHVh dGVzIHRvIE5VTEwsIGl0IGlzIHJlZ2FyZGVkIGFzICJmYWxzZSIuIFRoZSBXSEVSRSBjbGF1c2UK b25seSBhbGxvd3Mgc2ltcGxlIGV4cHJlc3Npb25zIHRoYXQgZG9uJ3QgaGF2ZSB1c2VyLWRlZmlu ZWQgZnVuY3Rpb25zLAp1c2VyLWRlZmluZWQgb3BlcmF0b3JzLCB1c2VyLWRlZmluZWQgdHlwZXMs IHVzZXItZGVmaW5lZCBjb2xsYXRpb25zLApub24taW1tdXRhYmxlIGJ1aWx0LWluIGZ1bmN0aW9u cywgb3IgcmVmZXJlbmNlcyB0byBzeXN0ZW0gY29sdW1ucy4gVGhlc2UKcmVzdHJpY3Rpb25zIGNv dWxkIGJlIGFkZHJlc3NlZCBpbiB0aGUgZnV0dXJlLgoKSWYgeW91IGNob29zZSB0byBkbyB0aGUg aW5pdGlhbCB0YWJsZSBzeW5jaHJvbml6YXRpb24sIG9ubHkgZGF0YSB0aGF0CnNhdGlzZmllcyB0 aGUgcm93IGZpbHRlcnMgaXMgY29waWVkIHRvIHRoZSBzdWJzY3JpYmVyLiBJZiB0aGUgc3Vic2Ny aXB0aW9uCmhhcyBzZXZlcmFsIHB1YmxpY2F0aW9ucyBpbiB3aGljaCBhIHRhYmxlIGhhcyBiZWVu IHB1Ymxpc2hlZCB3aXRoCmRpZmZlcmVudCBXSEVSRSBjbGF1c2VzLCByb3dzIHRoYXQgc2F0aXNm eSBBTlkgb2YgdGhlIGV4cHJlc3Npb25zIHdpbGwgYmUKY29waWVkLiBJZiBhIHN1YnNjcmliZXIg aXMgYSBwcmUtMTUgdmVyc2lvbiwgdGhlIGluaXRpYWwgdGFibGUKc3luY2hyb25pemF0aW9uIHdv bid0IHVzZSByb3cgZmlsdGVycyBldmVuIGlmIHRoZXkgYXJlIGRlZmluZWQgaW4gdGhlCnB1Ymxp c2hlci4KClRoZSByb3cgZmlsdGVycyBhcmUgYXBwbGllZCBiZWZvcmUgcHVibGlzaGluZyB0aGUg Y2hhbmdlcy4gSWYgdGhlCnN1YnNjcmlwdGlvbiBoYXMgc2V2ZXJhbCBwdWJsaWNhdGlvbnMgaW4g d2hpY2ggdGhlIHNhbWUgdGFibGUgaGFzIGJlZW4KcHVibGlzaGVkIHdpdGggZGlmZmVyZW50IGZp bHRlcnMgKGZvciB0aGUgc2FtZSBwdWJsaXNoIG9wZXJhdGlvbiksIHRob3NlCmV4cHJlc3Npb25z IGdldCBPUidlZCB0b2dldGhlciBzbyB0aGF0IHJvd3Mgc2F0aXNmeWluZyBhbnkgb2YgdGhlCmV4 cHJlc3Npb25zIHdpbGwgYmUgcmVwbGljYXRlZC4KClRoaXMgbWVhbnMgYWxsIHRoZSBvdGhlciBm aWx0ZXJzIGJlY29tZSByZWR1bmRhbnQgaWYgKGEpIG9uZSBvZiB0aGUKcHVibGljYXRpb25zIGhh dmUgbm8gZmlsdGVyIGF0IGFsbCwgKGIpIG9uZSBvZiB0aGUgcHVibGljYXRpb25zIHdhcwpjcmVh dGVkIHVzaW5nIEZPUiBBTEwgVEFCTEVTLCAoYykgb25lIG9mIHRoZSBwdWJsaWNhdGlvbnMgd2Fz IGNyZWF0ZWQKdXNpbmcgRk9SIEFMTCBUQUJMRVMgSU4gU0NIRU1BIGFuZCB0aGUgdGFibGUgYmVs b25ncyB0byB0aGF0IHNhbWUgc2NoZW1hLgoKSWYgeW91ciBwdWJsaWNhdGlvbiBjb250YWlucyBh IHBhcnRpdGlvbmVkIHRhYmxlLCB0aGUgcHVibGljYXRpb24KcGFyYW1ldGVyIHB1Ymxpc2hfdmlh X3BhcnRpdGlvbl9yb290IGRldGVybWluZXMgaWYgaXQgdXNlcyB0aGUgcGFydGl0aW9uJ3MKcm93 IGZpbHRlciAoaWYgdGhlIHBhcmFtZXRlciBpcyBmYWxzZSwgdGhlIGRlZmF1bHQpIG9yIHRoZSBy b290CnBhcnRpdGlvbmVkIHRhYmxlJ3Mgcm93IGZpbHRlci4KClBzcWwgY29tbWFuZHMgXGRScCsg YW5kIFxkIDx0YWJsZS1uYW1lPiB3aWxsIGRpc3BsYXkgYW55IHJvdyBmaWx0ZXJzLgoKQXV0aG9y OiBIb3UgWmhpamllLCBFdWxlciBUYXZlaXJhLCBQZXRlciBTbWl0aCwgQWppbiBDaGVyaWFuClJl dmlld2VkLWJ5OiBHcmVnIE5hbmNhcnJvdywgSGFpeWluZyBUYW5nLCBBbWl0IEthcGlsYSwgVG9t YXMgVm9uZHJhLCBEaWxpcCBLdW1hciwgVmlnbmVzaCBDLCBBbHZhcm8gSGVycmVyYSwgQW5kcmVz IEZyZXVuZCwgV2VpIFdhbmcKRGlzY3Vzc2lvbjogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcv bWVzc2FnZS1pZC9mbGF0L0NBSEUzd2dnYjcxNVglMkJtS19EaXRMWEYyNUIlM0RqRTZ4eU5DSDRZ T3dNODYwSlI3SGFyR1ElNDBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRl dGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzUy ZTRmMGNkNDcyZDM5ZDA3NzMyYjk5NTU5OTg5ZWEzYjYxNWJlNzgKCk1vZGlmaWVkIEZpbGVzCi0t LS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAgICAgICAgICAgICAg fCAgIDkgKwpkb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX3B1YmxpY2F0aW9uLnNnbWwgICAgIHwgIDEy ICstCmRvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfc3Vic2NyaXB0aW9uLnNnbWwgICAgfCAgIDcgKy0K ZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfcHVibGljYXRpb24uc2dtbCAgICB8ICAzOCArLQpkb2Mv c3JjL3NnbWwvcmVmL2NyZWF0ZV9zdWJzY3JpcHRpb24uc2dtbCAgIHwgIDI3ICstCnNyYy9iYWNr ZW5kL2NhdGFsb2cvcGdfcHVibGljYXRpb24uYyAgICAgICAgfCAgNTkgKy0Kc3JjL2JhY2tlbmQv Y29tbWFuZHMvcHVibGljYXRpb25jbWRzLmMgICAgICB8IDU4MyArKysrKysrKysrKysrKysrKyst CnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNSZXBsaWNhdGlvbi5jICAgICAgfCAgMzkgKy0Kc3Jj L2JhY2tlbmQvbm9kZXMvY29weWZ1bmNzLmMgICAgICAgICAgICAgICB8ICAgMSArCnNyYy9iYWNr ZW5kL25vZGVzL2VxdWFsZnVuY3MuYyAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9w YXJzZXIvZ3JhbS55ICAgICAgICAgICAgICAgICAgIHwgIDM4ICstCnNyYy9iYWNrZW5kL3JlcGxp Y2F0aW9uL2xvZ2ljYWwvcHJvdG8uYyAgICAgfCAgMzYgKy0Kc3JjL2JhY2tlbmQvcmVwbGljYXRp b24vbG9naWNhbC90YWJsZXN5bmMuYyB8IDE0MiArKysrLQpzcmMvYmFja2VuZC9yZXBsaWNhdGlv bi9wZ291dHB1dC9wZ291dHB1dC5jIHwgODMzICsrKysrKysrKysrKysrKysrKysrKysrKy0tLS0K c3JjL2JhY2tlbmQvdXRpbHMvY2FjaGUvcmVsY2FjaGUuYyAgICAgICAgICB8ICA5OCArKystCnNy Yy9iaW4vcGdfZHVtcC9wZ19kdW1wLmMgICAgICAgICAgICAgICAgICAgfCAgMzAgKy0Kc3JjL2Jp bi9wZ19kdW1wL3BnX2R1bXAuaCAgICAgICAgICAgICAgICAgICB8ICAgMSArCnNyYy9iaW4vcHNx bC9kZXNjcmliZS5jICAgICAgICAgICAgICAgICAgICAgfCAgMjYgKy0Kc3JjL2Jpbi9wc3FsL3Rh Yi1jb21wbGV0ZS5jICAgICAgICAgICAgICAgICB8ICAyOSArLQpzcmMvaW5jbHVkZS9jYXRhbG9n L2NhdHZlcnNpb24uaCAgICAgICAgICAgIHwgICAyICstCnNyYy9pbmNsdWRlL2NhdGFsb2cvcGdf cHVibGljYXRpb24uaCAgICAgICAgfCAgMTggKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19wdWJs aWNhdGlvbl9yZWwuaCAgICB8ICAgNiArCnNyYy9pbmNsdWRlL2NvbW1hbmRzL3B1YmxpY2F0aW9u Y21kcy5oICAgICAgfCAgIDIgKwpzcmMvaW5jbHVkZS9ub2Rlcy9wYXJzZW5vZGVzLmggICAgICAg ICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvcmVwbGljYXRpb24vbG9naWNhbHByb3RvLmggICAg ICB8ICAxMSArLQpzcmMvaW5jbHVkZS9yZXBsaWNhdGlvbi9wZ291dHB1dC5oICAgICAgICAgIHwg ICAxICsKc3JjL2luY2x1ZGUvcmVwbGljYXRpb24vcmVvcmRlcmJ1ZmZlci5oICAgICB8ICAgNiAr LQpzcmMvaW5jbHVkZS91dGlscy9yZWwuaCAgICAgICAgICAgICAgICAgICAgIHwgICAyICstCnNy Yy9pbmNsdWRlL3V0aWxzL3JlbGNhY2hlLmggICAgICAgICAgICAgICAgfCAgIDUgKy0Kc3JjL3Rl c3QvcmVncmVzcy9leHBlY3RlZC9wdWJsaWNhdGlvbi5vdXQgICB8IDM1MiArKysrKysrKysrKysK c3JjL3Rlc3QvcmVncmVzcy9zcWwvcHVibGljYXRpb24uc3FsICAgICAgICB8IDIzNiArKysrKysr KwpzcmMvdGVzdC9zdWJzY3JpcHRpb24vdC8wMjhfcm93X2ZpbHRlci5wbCAgIHwgNjk1ICsrKysr KysrKysrKysrKysrKysrKysrCnNyYy90b29scy9wZ2luZGVudC90eXBlZGVmcy5saXN0ICAgICAg ICAgICAgfCAgIDMgKwozMyBmaWxlcyBjaGFuZ2VkLCAzMTEzIGluc2VydGlvbnMoKyksIDIzNiBk ZWxldGlvbnMoLSkKCg== --===============4188805537616253193==--