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 1pJIKO-0007JM-RQ for pgsql-committers@arkaria.postgresql.org; Sat, 21 Jan 2023 18:10:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pJIKN-0007J1-Li for pgsql-committers@arkaria.postgresql.org; Sat, 21 Jan 2023 18:10:55 +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 1pJIKN-0006wu-8C for pgsql-committers@lists.postgresql.org; Sat, 21 Jan 2023 18:10:55 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pJIKI-0005cr-VY for pgsql-committers@lists.postgresql.org; Sat, 21 Jan 2023 18:10:54 +0000 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 1pJIKI-0001l3-3c for pgsql-committers@lists.postgresql.org; Sat, 21 Jan 2023 18:10:50 +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 1pJIKG-004oqo-GG for pgsql-committers@lists.postgresql.org; Sat, 21 Jan 2023 18:10:48 +0000 Content-Type: multipart/mixed; boundary="===============3633245275796151667==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Allow REPLICA IDENTITY to be set on an index that's not (yet) va X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 21 Jan 2023 18:10:48 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3633245275796151667== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgUkVQTElDQSBJREVOVElUWSB0byBiZSBzZXQgb24gYW4gaW5kZXggdGhhdCdzIG5vdCAo eWV0KSB2YWxpZC4KClRoZSBtb3RpdmF0aW9uIGZvciB0aGlzIGNoYW5nZSBpcyB0aGF0IHdoZW4g cGdfZHVtcCBkdW1wcyBhCnBhcnRpdGlvbmVkIGluZGV4IHRoYXQncyBtYXJrZWQgUkVQTElDQSBJ REVOVElUWSwgaXQgZ2VuZXJhdGVzIGEKY29tbWFuZCBzZXF1ZW5jZSB0aGF0IGFwcGxpZXMgUkVQ TElDQSBJREVOVElUWSBiZWZvcmUgdGhlIHBhcnRpdGlvbmVkCmluZGV4IGhhcyBiZWVuIG1hcmtl ZCB2YWxpZCwgY2F1c2luZyByZXN0b3JlIHRvIGZhaWwuICBXZSBjb3VsZApwZXJoYXBzIGNoYW5n ZSBwZ19kdW1wIHRvIG5vdCBkbyBpdCBsaWtlIHRoYXQsIGJ1dCB0aGF0IHdvdWxkIGJlCmRpZmZp Y3VsdCBhbmQgd291bGQgbm90IGZpeCBleGlzdGluZyBkdW1wIGZpbGVzIHdpdGggdGhlIHByb2Js ZW0uClRoZXJlIHNlZW1zIHRvIGJlIHZlcnkgbGl0dGxlIHJlYXNvbiBmb3IgdGhlIGJhY2tlbmQg dG8gZGlzYWxsb3cKdGhpcyBhbnl3YXkgLS0tIHRoZSBjb2RlIGlnbm9yZXMgaW5kaXNyZXBsaWRl bnQgd2hlbiB0aGUgaW5kZXgKaXNuJ3QgdmFsaWQgLS0tIHNvIGluc3RlYWQgbGV0J3MgZml4IGl0 IGJ5IGFsbG93aW5nIHRoZSBjYXNlLgoKQ29tbWl0IDk1MTFmYjM3YSBwcmV2aW91c2x5IGV4cHJl c3NlZCBhIGNvbmNlcm4gdGhhdCBhbGxvd2luZwppbmRpc3JlcGxpZGVudCB0byBiZSBzZXQgb24g aW52YWxpZCBpbmRleGVzIG1pZ2h0IGFsbG93IHVzIHRvCndpbmQgdXAgaW4gYSBzaXR1YXRpb24g d2hlcmUgYSB0YWJsZSBjb3VsZCBoYXZlIGluZGlzcmVwbGlkZW50CnNldCBvbiBtdWx0aXBsZSBp bmRleGVzLiAgSSdtIG5vdCBzdXJlIEkgZm9sbG93IHRoYXQgY29uY2VybgpleGFjdGx5LCBidXQg aW4gYW55IGNhc2UgdGhlIG9ubHkgd2F5IHRoYXQgY291bGQgaGFwcGVuIGlzIGJlY2F1c2UKcmVs YXRpb25fbWFya19yZXBsaWNhX2lkZW50aXR5IGlzIHRvbyB0cnVzdGluZyBhYm91dCB0aGUgZXhp c3Rpbmcgc2V0Cm9mIG1hcmtpbmdzIGJlaW5nIHZhbGlkLiAgTGV0J3MganVzdCByaXAgb3V0IGl0 cyBlYXJseS1leGl0IGNvZGUgcGF0aAood2hpY2ggc3VyZSBsb29rcyBsaWtlIHByZW1hdHVyZSBv cHRpbWl6YXRpb24gYW55d2F5OyB3aGF0IGFyZSB3ZQpkb2luZyBleHBlbmRpbmcgY29kZSB0byBt YWtlIHJlZHVuZGFudCBBTFRFUiBUQUJMRSAuLi4gUkVQTElDQQpJREVOVElUWSBjb21tYW5kcyBt YXJnaW5hbGx5IGZhc3RlciBhbmQgbm90LXJlZHVuZGFudCBvbmVzIG1hcmdpbmFsbHkKc2xvd2Vy PykgYW5kIGZpeCBpdCB0byBwb3NpdGl2ZWx5IGd1YXJhbnRlZSB0aGF0IG5vIG1vcmUgdGhhbiBv bmUKaW5kZXggaXMgbWFya2VkIGluZGlzcmVwbGlkZW50LgoKVGhlIHBnX2R1bXAgZmFpbHVyZSBj YW4gYmUgZGVtb25zdHJhdGVkIGluIGFsbCBzdXBwb3J0ZWQgYnJhbmNoZXMsCnNvIGJhY2stcGF0 Y2ggYWxsIHRoZSB3YXkuICBJIGNob3NlIHRvIGJhY2stcGF0Y2ggOTUxMWZiMzdhIGFzIHdlbGws Cmp1c3QgdG8ga2VlcCBpbmRpc3JlcGxpZGVudCBoYW5kbGluZyB0aGUgc2FtZSBpbiBhbGwgYnJh bmNoZXMuCgpQZXIgYnVnICMxNzc1NiBmcm9tIFNlcmdleSBCZWx5YXNob3YuCgpEaXNjdXNzaW9u OiBodHRwczovL3Bvc3Rnci5lcy9tLzE3NzU2LWRkNTBlOGUwYzhkZDRhNDBAcG9zdGdyZXNxbC5v cmcKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9z dGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9jOWY3ZjkyNjQ4NGQ2OWUyODA2ZTM1MzQzYWY3ZTQ3 MmZhZGZlZGU3CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jYXRh bG9nL2luZGV4LmMgICAgICAgICAgICAgICAgICAgIHwgIDUgKy0Kc3JjL2JhY2tlbmQvY29tbWFu ZHMvdGFibGVjbWRzLmMgICAgICAgICAgICAgICB8IDY0ICsrKysrKysrKy0tLS0tLS0tLS0tLS0t LS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcmVwbGljYV9pZGVudGl0eS5vdXQgfCAzNyAr KysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvcmVwbGljYV9pZGVudGl0eS5zcWwg ICAgICB8IDIwICsrKysrKysrCjQgZmlsZXMgY2hhbmdlZCwgODEgaW5zZXJ0aW9ucygrKSwgNDUg ZGVsZXRpb25zKC0pCgo= --===============3633245275796151667==--