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 1pAHGz-0004r4-RW for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Dec 2022 21:14:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pAHGx-00018B-3D for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Dec 2022 21:14:07 +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 1pAHGw-000182-JP for pgsql-hackers@lists.postgresql.org; Tue, 27 Dec 2022 21:14:06 +0000 Received: from sender4-op-o11.zoho.com ([136.143.188.11]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pAHGu-0001pe-26 for pgsql-hackers@lists.postgresql.org; Tue, 27 Dec 2022 21:14:05 +0000 Delivered-To: cary.huang@highgo.ca ARC-Seal: i=1; a=rsa-sha256; t=1672175637; cv=none; d=zohomail.com; s=zohoarc; b=YbLBgM7aw94NLIu6pM90mVmpXBl4uU5MQzmPZSRB+taJ/UsfG8oo0b38oSc3XcymkxWu8K+2i37hP9uxqdrAEMfLvvfxTuMu4363OnlDfr8T5qJWiOByNZ0FXK1EsnIk+iHxYuhTGK/npi0nkLlEKchBDQTXaz2a1VqhgQFTt3A= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zohomail.com; s=zohoarc; t=1672175637; h=Content-Type:Content-Transfer-Encoding:Cc:Date:From:In-Reply-To:MIME-Version:Message-ID:References:Subject:To; bh=2D1bh4uAyAxesJU8d//ZCcAW/f/nsOOCUNIWjPkxqNI=; b=F8vWhyh4nl1793Tqo1zOpM1oQohXUBRWZbgcGjQPmXEe9WSgNKS73rJXTzx/MHP8E0kMl8Tnbp+EORzfkEmS0ZYF0qaNr3OZaEmT8Gzkzo2n0fIJRDlvfThpl2gnexs68llQWJpC2RQYd9H0n7nQmJ64rT1bNRXMuLXlMm+TTjQ= ARC-Authentication-Results: i=1; mx.zohomail.com; dkim=pass header.i=highgo.ca; spf=pass smtp.mailfrom=david.zhang@highgo.ca; dmarc=pass header.from= DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; t=1672175637; s=zoho; d=highgo.ca; i=david.zhang@highgo.ca; h=Message-ID:Date:Date:MIME-Version:Subject:Subject:To:To:Cc:Cc:References:From:From:In-Reply-To:Content-Type:Content-Transfer-Encoding:Message-Id:Reply-To; bh=2D1bh4uAyAxesJU8d//ZCcAW/f/nsOOCUNIWjPkxqNI=; b=QeILBHh6wt1NAcWWoxcG+SGpK21xQuvQUPO+F1U66elOB7sTkvrT8uL02uqHvGPW f4dIW2u3J+gHrpdVhowljfJ9wMNw3Chvl/369/Z3UT/3tpwka65P2YrCCpsvVH6Xy5Y dY2JOav8MlNELIE5oVAOvblz3NMTzgDqlHLgBD94= Received: from [192.168.1.88] (d66-183-207-156.bchsia.telus.net [66.183.207.156]) by mx.zohomail.com with SMTPS id 1672175635268331.4578909592242; Tue, 27 Dec 2022 13:13:55 -0800 (PST) Message-ID: <1a7e0866-2611-44f3-4c37-a9cd2e2cd10d@highgo.ca> Date: Tue, 27 Dec 2022 13:13:53 -0800 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.5.1 Subject: Re: Patch: Global Unique Index Content-Language: en-US To: Nikita Malakhov Cc: Tom Lane , Bruce Momjian , Greg Stark , Simon Riggs , Cary Huang , Pgsql Hackers References: <184879c5306.12490ea581628934.7312528450011769010@highgo.ca> <46a0f6fb-1c0b-bbd8-ef3e-366216a89501@highgo.ca> <1239139.1669763636@sss.pgh.pa.us> <1257837.1669774583@sss.pgh.pa.us> <6b69efba-5f4f-04a5-46b4-b92e38cbb69b@highgo.ca> From: David Zhang In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-ZohoMailClient: External List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2022-12-19 7:51 a.m., Nikita Malakhov wrote: > Sorry to bother - but is this patch used in IvorySQL? > Here: > https://www.ivorysql.org/docs/Global%20Unique%20Index/create_global_unique_index > According to syntax it definitely looks like this patch. The global unique index is one of the features required in IvorySQL development. We want to share it to the communities to get more feedback, and then hopefully we could better contribute it back to PostgreSQL. Best regards, David