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 1pcHyd-0001kc-2P for pgsql-committers@arkaria.postgresql.org; Wed, 15 Mar 2023 03:38:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pcHyb-0003Kp-PX for pgsql-committers@arkaria.postgresql.org; Wed, 15 Mar 2023 03:38:57 +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 1pcHyb-0003Kg-He for pgsql-committers@lists.postgresql.org; Wed, 15 Mar 2023 03:38:57 +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 1pcHyY-0004TB-Oi for pgsql-committers@lists.postgresql.org; Wed, 15 Mar 2023 03:38:57 +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=une4sYnH9me+SeOyQQYjAYTxztUEyLWh64ro6tw+yqA=; b=zFmB8S61nev27xnk06s8n0lChg 2lfC0jFHH//UyzORcnd+zJV8IXRU7BRDUHxt+DjQFkXU/lG4OwBkPCU0pMqxx0iveroZRFsIgRM4C fhGZHzdJn9CUKMC1o7Wt4mJFyqO10w3JV805SHRHRKGH7hJ1eEgvuKD50wMRs/RdE/r1NCGPdwMWg nERodWErK3XWHMmD+lCgaDOURoQI22kxRdPiWcjtXi0lINhb4IcRjaskbfhZBOf/8L7OHFxjwz9UT uonIOfGBOcF913/F82EWCJUaItWQt3cSlQocdMgzzAql6atJtn+XorJNfFe4bDNa0AlZRts6oXHKr UPDjCINA==; 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 1pcHyX-000539-CW for pgsql-committers@lists.postgresql.org; Wed, 15 Mar 2023 03:38:53 +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 1pcHyW-003bGX-2z for pgsql-committers@lists.postgresql.org; Wed, 15 Mar 2023 03:38:52 +0000 Content-Type: multipart/mixed; boundary="===============2439814281015978456==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: Allow the use of indexes other than PK and REPLICA IDENTITY on t X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 15 Mar 2023 03:38:52 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2439814281015978456== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgdGhlIHVzZSBvZiBpbmRleGVzIG90aGVyIHRoYW4gUEsgYW5kIFJFUExJQ0EgSURFTlRJ VFkgb24gdGhlIHN1YnNjcmliZXIuCgpVc2luZyBSRVBMSUNBIElERU5USVRZIEZVTEwgb24gdGhl IHB1Ymxpc2hlciBjYW4gbGVhZCB0byBhIGZ1bGwgdGFibGUgc2NhbgpwZXIgdHVwbGUgY2hhbmdl IG9uIHRoZSBzdWJzY3JpcHRpb24gd2hlbiBSRVBMSUNBIElERU5USVRZIG9yIFBLIGluZGV4IGlz Cm5vdCBhdmFpbGFibGUuIFRoaXMgbWFrZXMgUkVQTElDQSBJREVOVElUWSBGVUxMIGltcHJhY3Rp Y2FsIHRvIHVzZSBhcGFydApmcm9tIHNvbWUgc21hbGwgbnVtYmVyIG9mIHVzZSBjYXNlcy4KClRo aXMgcGF0Y2ggYWxsb3dzIHVzaW5nIGluZGV4ZXMgb3RoZXIgdGhhbiBQUklNQVJZIEtFWSBvciBS RVBMSUNBCklERU5USVRZIG9uIHRoZSBzdWJzY3JpYmVyIGR1cmluZyBhcHBseSBvZiB1cGRhdGUv ZGVsZXRlLiBUaGUgaW5kZXggdGhhdApjYW4gYmUgdXNlZCBtdXN0IGJlIGEgYnRyZWUgaW5kZXgs IG5vdCBhIHBhcnRpYWwgaW5kZXgsIGFuZCBpdCBtdXN0IGhhdmUKYXQgbGVhc3Qgb25lIGNvbHVt biByZWZlcmVuY2UgKGkuZS4gY2Fubm90IGNvbnNpc3Qgb2Ygb25seSBleHByZXNzaW9ucykuCldl IGNhbiB1cGxpZnQgdGhlc2UgcmVzdHJpY3Rpb25zIGluIHRoZSBmdXR1cmUuIFRoZXJlIGlzIG5v IHNtYXJ0Cm1lY2hhbmlzbSB0byBwaWNrIHRoZSBpbmRleC4gSWYgdGhlcmUgaXMgbW9yZSB0aGFu IG9uZSBpbmRleCB0aGF0CnNhdGlzZmllcyB0aGVzZSByZXF1aXJlbWVudHMsIHdlIGp1c3QgcGlj ayB0aGUgZmlyc3Qgb25lLiBXZSBkaXNjdXNzZWQKdXNpbmcgc29tZSBvZiB0aGUgb3B0aW1pemVy J3MgbG93LWxldmVsIEFQSXMgZm9yIHRoaXMgYnV0IHJ1bGVkIGl0IG91dAphcyB0aGF0IGNhbiBi ZSBhIG1haW50ZW5hbmNlIGJ1cmRlbiBpbiB0aGUgbG9uZyBydW4uCgpUaGlzIHBhdGNoIGltcHJv dmVzIHRoZSBwZXJmb3JtYW5jZSBpbiB0aGUgdmFzdCBtYWpvcml0eSBvZiBjYXNlcyBhbmQgdGhl CmltcHJvdmVtZW50IGlzIHByb3BvcnRpb25hbCB0byB0aGUgYW1vdW50IG9mIGRhdGEgaW4gdGhl IHRhYmxlLiBIb3dldmVyLAp0aGVyZSBjb3VsZCBiZSBzb21lIHJlZ3Jlc3Npb24gaW4gYSBzbWFs bCBudW1iZXIgb2YgY2FzZXMgd2hlcmUgdGhlIGluZGV4ZXMKaGF2ZSBhIGxvdCBvZiBkdXBsaWNh dGUgYW5kIGRlYWQgcm93cy4gSXQgd2FzIGRpc2N1c3NlZCB0aGF0IHRob3NlIGFyZQptb3N0bHkg aW1wcmFjdGljYWwgY2FzZXMgYnV0IHdlIGNhbiBwcm92aWRlIGEgdGFibGUgb3Igc3Vic2NyaXB0 aW9uIGxldmVsCm9wdGlvbiB0byBkaXNhYmxlIHRoaXMgZmVhdHVyZSBpZiByZXF1aXJlZC4KCkF1 dGhvcjogT25kZXIgS2FsYWNpLCBBbWl0IEthcGlsYQpSZXZpZXdlZC1ieTogUGV0ZXIgU21pdGgs IFNoaSB5dSwgSG91IFpoaWppZSwgVmlnbmVzaCBDLCBLdXJvZGEgSGF5YXRvLCBBbWl0IEthcGls YQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBQ2F3RWhWTHFtQUF5UFhkSEVQdjFz c1UyYz1kcU9uaWlHejdHNzNIZnlTNytuR1Y0d0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0t LQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9j b21taXRkaWZmLzg5ZTQ2ZGE1ZTUxMWE2OTcwZTI2YTAyMGYyNjVjOWZiNGI3MmIxZDIKCk1vZGlm aWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9sb2dpY2FsLXJlcGxpY2F0aW9u LnNnbWwgICAgICB8ICAgOSArLQpzcmMvYmFja2VuZC9leGVjdXRvci9leGVjUmVwbGljYXRpb24u YyAgICAgfCAxMTIgKysrKysrKysrKy0tLS0tCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2lj YWwvcmVsYXRpb24uYyB8IDIxMiArKysrKysrKysrKysrKysrKysrKysrKysrKysrLQpzcmMvYmFj a2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL3dvcmtlci5jICAgfCAgNTYgKysrKy0tLS0Kc3JjL2lu Y2x1ZGUvcmVwbGljYXRpb24vbG9naWNhbHJlbGF0aW9uLmggIHwgICA0ICsKc3JjL3Rlc3Qvc3Vi c2NyaXB0aW9uL21lc29uLmJ1aWxkICAgICAgICAgIHwgICAxICsKNiBmaWxlcyBjaGFuZ2VkLCAz MjUgaW5zZXJ0aW9ucygrKSwgNjkgZGVsZXRpb25zKC0pCgo= --===============2439814281015978456==--