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 1pJIKN-0007JF-TK for pgsql-committers@arkaria.postgresql.org; Sat, 21 Jan 2023 18:10:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pJIKM-0006sY-6Z for pgsql-committers@arkaria.postgresql.org; Sat, 21 Jan 2023 18:10:54 +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 1pJIKL-0006sP-UN for pgsql-committers@lists.postgresql.org; Sat, 21 Jan 2023 18:10:53 +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-0005cs-VP for pgsql-committers@lists.postgresql.org; Sat, 21 Jan 2023 18:10:52 +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-0001l5-3r 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-004oqs-Ja for pgsql-committers@lists.postgresql.org; Sat, 21 Jan 2023 18:10:48 +0000 Content-Type: multipart/mixed; boundary="===============7280463900395252747==" 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 --===============7280463900395252747== 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 cmcKCkJyYW5jaAotLS0tLS0KUkVMXzE0X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNzBlYzc1NmIwMWE0YzllNjJjMTg5YThk ODUzNDAxMzkzZDE4Y2I0YgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tl bmQvY2F0YWxvZy9pbmRleC5jICAgICAgICAgICAgICAgICAgICB8ICA1ICstCnNyYy9iYWNrZW5k L2NvbW1hbmRzL3RhYmxlY21kcy5jICAgICAgICAgICAgICAgfCA2NCArKysrKysrKystLS0tLS0t LS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3JlcGxpY2FfaWRlbnRpdHkub3V0 IHwgMzcgKysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3JlcGxpY2FfaWRlbnRp dHkuc3FsICAgICAgfCAyMCArKysrKysrKwo0IGZpbGVzIGNoYW5nZWQsIDgxIGluc2VydGlvbnMo KyksIDQ1IGRlbGV0aW9ucygtKQoK --===============7280463900395252747==--