Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1etwub-0003vm-Mn for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Mar 2018 14:52:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1etwua-0006Dy-Kc for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Mar 2018 14:52:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1etwua-0006De-C6 for pgsql-hackers@lists.postgresql.org; Thu, 08 Mar 2018 14:52:52 +0000 Received: from g2t2353.austin.hpe.com ([15.233.44.26]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1etwuV-0000Jy-FM for pgsql-hackers@postgresql.org; Thu, 08 Mar 2018 14:52:51 +0000 Received: from G9W8453.americas.hpqcorp.net (exchangepmrr1.us.hpecorp.net [16.216.160.211]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA384 (256/256 bits)) (No client certificate requested) by g2t2353.austin.hpe.com (Postfix) with ESMTPS id 337BF65; Thu, 8 Mar 2018 14:52:43 +0000 (UTC) Received: from G9W8454.americas.hpqcorp.net (2002:10d8:a104::10d8:a104) by G9W8453.americas.hpqcorp.net (2002:10d8:a0d3::10d8:a0d3) with Microsoft SMTP Server (TLS) id 15.0.1178.4; Thu, 8 Mar 2018 14:52:43 +0000 Received: from NAM02-SN1-obe.outbound.protection.outlook.com (15.241.52.11) by G9W8454.americas.hpqcorp.net (16.216.161.4) with Microsoft SMTP Server (TLS) id 15.0.1178.4 via Frontend Transport; Thu, 8 Mar 2018 14:52:42 +0000 Received: from DF4PR8401MB1020.NAMPRD84.PROD.OUTLOOK.COM (10.169.87.140) by DF4PR8401MB1098.NAMPRD84.PROD.OUTLOOK.COM (10.169.92.13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.20.548.13; Thu, 8 Mar 2018 14:52:41 +0000 Received: from DF4PR8401MB1020.NAMPRD84.PROD.OUTLOOK.COM ([fe80::88af:7a61:fa37:34eb]) by DF4PR8401MB1020.NAMPRD84.PROD.OUTLOOK.COM ([fe80::88af:7a61:fa37:34eb%17]) with mapi id 15.20.0548.018; Thu, 8 Mar 2018 14:52:41 +0000 From: "Shinoda, Noriyoshi" To: Amit Langote , Alvaro Herrera , Peter Eisentraut , Jaime Casanova CC: Jesper Pedersen , Pg Hackers Subject: RE: unique indexes on partitioned tables Thread-Topic: unique indexes on partitioned tables Thread-Index: AQHTqizG3y0RKql3C0G/VmmPg5OeHKPGhXbA Date: Thu, 8 Mar 2018 14:52:41 +0000 Message-ID: References: <20180219204531.tsblwxwtz332pp7e@alvherre.pgsql> <7b2f668d-2a8f-5f03-3c5d-959f5b802ff1@lab.ntt.co.jp> In-Reply-To: <7b2f668d-2a8f-5f03-3c5d-959f5b802ff1@lab.ntt.co.jp> Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=noriyoshi.shinoda@hpe.com; x-originating-ip: [114.164.190.11] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;DF4PR8401MB1098;7:Ku+u8DwrbTQUA2jMppIFPGkIQ5qUObvZ17kLp7QulkqXYRquTZcPPKvLeROo7BFP8DjL+8Bxr6+RbX9Q4Lyc640ouRczQoTtpdB1n1OYsdbRD7mUClXTrEsu390mP0626PTH3zSyAkvr/hx2zvW2w8AKD9OLLiPzreZMUeA8tfotgRx3YZbBU2CYyYnCwE9HPNMZMPCAWW4Gx7fS7T+rFlXVTWrmJotUqRbbpprHY1EoGuOiJaEozX2W7wz/b++I x-ms-exchange-antispam-srfa-diagnostics: SSOS; x-ms-office365-filtering-ht: Tenant x-ms-office365-filtering-correlation-id: 8bbd04e3-f9f7-4089-feca-08d585043e6e x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652020)(8989060)(48565401081)(5600026)(4604075)(3008032)(4534165)(4627221)(201703031133081)(201702281549075)(8990040)(2017052603328)(7153060)(7193020);SRVR:DF4PR8401MB1098; x-ms-traffictypediagnostic: DF4PR8401MB1098: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(239476081049307); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(8211001083)(6040501)(2401047)(5005006)(8121501046)(10201501046)(93006095)(93001095)(3002001)(3231220)(944501244)(52105095)(6055026)(6041288)(20161123564045)(20161123562045)(201703131423095)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(20161123560045)(20161123558120)(6072148)(201708071742011);SRVR:DF4PR8401MB1098;BCL:0;PCL:0;RULEID:;SRVR:DF4PR8401MB1098; x-forefront-prvs: 060503E79B x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(39380400002)(39860400002)(346002)(396003)(366004)(376002)(13464003)(43234003)(199004)(189003)(8936002)(316002)(6436002)(14454004)(478600001)(55016002)(2950100002)(3280700002)(81166006)(9686003)(110136005)(76176011)(54906003)(53936002)(7696005)(33656002)(66066001)(186003)(97736004)(86362001)(5660300001)(26005)(229853002)(3846002)(6116002)(2906002)(102836004)(2900100001)(305945005)(6246003)(8676002)(3660700001)(5250100002)(68736007)(5890100001)(81156014)(53546011)(7736002)(99286004)(25786009)(59450400001)(6506007)(106356001)(74316002)(105586002)(4326008);DIR:OUT;SFP:1102;SCL:1;SRVR:DF4PR8401MB1098;H:DF4PR8401MB1020.NAMPRD84.PROD.OUTLOOK.COM;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; received-spf: None (protection.outlook.com: hpe.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: g9WelIxWXnULdAqQXbbYy28kxws5dv8Gofuorwn5Ic2R7sdQQBpKJ1hBT5L5ETYj1OuvxeXzxhpQ+YdjwalEkZH2S+76qwmwfYvzlmNmR2ajYyEX9oqPminhLfyT7RyWy7Gqu+p772lRX43Qc04lR58LDZ0iXxaDQNpHDuxaZCfWzGLGMibNGVLWxyxj6VRjFuE3H+E3CuZ7HLkpD/p0+fMoR/XbOQ0f1szg0hkT5wdI9EBcpGXq/5oZHHG+IqKn8Mh8ElHuPUS1+NzhChn60ri5HgmGG6sC8qCLW1VtPX7L4bXljUb/LfZ7E7pI1sQ1cf6u9p+aPyKFVAD6BN9Z4w== spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-MS-Exchange-CrossTenant-Network-Message-Id: 8bbd04e3-f9f7-4089-feca-08d585043e6e X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Mar 2018 14:52:41.5680 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 105b2061-b669-4b31-92ac-24d304d195dc X-MS-Exchange-Transport-CrossTenantHeadersStamped: DF4PR8401MB1098 X-OriginatorOrg: hpe.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SGkuDQoNCkkgdHJpZWQgdGhpcyBmZWF0dXJlIHdpdGggdGhlIGxhdGVzdCBzbmFwc2hvdC4gV2hl biBJIGV4ZWN1dGVkIHRoZSBmb2xsb3dpbmcgU1FMIHN0YXRlbWVudCwgbXVsdGlwbGUgcHJpbWFy eSBrZXlzIHdlcmUgY3JlYXRlZCBvbiB0aGUgcGFydGl0aW9uLiANCklzIHRoaXMgdGhlIGludGVu ZGVkIGJlaGF2aW9yPw0KDQotLSB0ZXN0DQpwb3N0Z3Jlcz0+IENSRUFURSBUQUJMRSBwYXJ0MShj MSBJTlQgUFJJTUFSWSBLRVksIGMyIElOVCwgYzMgVkFSQ0hBUigxMCkpIFBBUlRJVElPTiBCWSBS QU5HRShjMSkgOw0KQ1JFQVRFIFRBQkxFDQpwb3N0Z3Jlcz0+IENSRUFURSBUQUJMRSBwYXJ0MXYx IChMSUtFIHBhcnQxKSA7DQpDUkVBVEUgVEFCTEUNCnBvc3RncmVzPT4gQUxURVIgVEFCTEUgcGFy dDF2MSBBREQgQ09OU1RSQUlOVCBwa19wYXJ0MXYxIFBSSU1BUlkgS0VZIChjMSwgYzIpIDsNCkFM VEVSIFRBQkxFDQpwb3N0Z3Jlcz0+IEFMVEVSIFRBQkxFIHBhcnQxIEFUVEFDSCBQQVJUSVRJT04g cGFydDF2MSBGT1IgVkFMVUVTIEZST00gKDEwMCkgVE8gKDIwMCkgOw0KQUxURVIgVEFCTEUNCnBv c3RncmVzPT4gXGQgcGFydDF2MQ0KICAgICAgICAgICAgICAgICAgICAgVGFibGUgInB1YmxpYy5w YXJ0MXYxIg0KIENvbHVtbiB8ICAgICAgICAgVHlwZSAgICAgICAgICB8IENvbGxhdGlvbiB8IE51 bGxhYmxlIHwgRGVmYXVsdA0KLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0t LS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0NCiBjMSAgICAgfCBpbnRlZ2VyICAgICAgICAgICAg ICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8DQogYzIgICAgIHwgaW50ZWdlciAgICAgICAgICAg ICAgIHwgICAgICAgICAgIHwgbm90IG51bGwgfA0KIGMzICAgICB8IGNoYXJhY3RlciB2YXJ5aW5n KDEwKSB8ICAgICAgICAgICB8ICAgICAgICAgIHwNClBhcnRpdGlvbiBvZjogcGFydDEgRk9SIFZB TFVFUyBGUk9NICgxMDApIFRPICgyMDApDQpJbmRleGVzOg0KICAgICJwYXJ0MXYxX3BrZXkiIFBS SU1BUlkgS0VZLCBidHJlZSAoYzEpDQogICAgInBrX3BhcnQxdjEiIFBSSU1BUlkgS0VZLCBidHJl ZSAoYzEsIGMyKQ0KDQpSZWdhcmRzLA0KDQpOb3JpeW9zaGkgU2hpbm9kYQ0KDQotLS0tLU9yaWdp bmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogQW1pdCBMYW5nb3RlIFttYWlsdG86TGFuZ290ZV9BbWl0 X2Y4QGxhYi5udHQuY28uanBdIA0KU2VudDogVHVlc2RheSwgRmVicnVhcnkgMjAsIDIwMTggNjoy NCBQTQ0KVG86IEFsdmFybyBIZXJyZXJhIDxhbHZoZXJyZUBhbHZoLm5vLWlwLm9yZz47IFBldGVy IEVpc2VudHJhdXQgPHBldGVyLmVpc2VudHJhdXRAMm5kcXVhZHJhbnQuY29tPjsgSmFpbWUgQ2Fz YW5vdmEgPGphaW1lLmNhc2Fub3ZhQDJuZHF1YWRyYW50LmNvbT4NCkNjOiBKZXNwZXIgUGVkZXJz ZW4gPGplc3Blci5wZWRlcnNlbkByZWRoYXQuY29tPjsgUGcgSGFja2VycyA8cGdzcWwtaGFja2Vy c0Bwb3N0Z3Jlc3FsLm9yZz4NClN1YmplY3Q6IFJlOiB1bmlxdWUgaW5kZXhlcyBvbiBwYXJ0aXRp b25lZCB0YWJsZXMNCg0KSGkuDQoNCk9uIDIwMTgvMDIvMjAgNTo0NSwgQWx2YXJvIEhlcnJlcmEg d3JvdGU6DQo+IEkgcHVzaGVkIHRoaXMgbm93LCB3aXRoIGZpeGVzIGZvciB0aGUgbGFzdCBmZXcg Y29tbWVudHMgdGhlcmUgd2VyZS4NCg0KSSBub3RpY2VkIHdpdGggdGhlIGNvbW1pdCB0aGF0LCB3 aGlsZSBPTiBDT05GTElDVCAoY29uZmxpY3RfdGFyZ2V0KSBETyBVUERBVEUgZ2l2ZXMgYSBsZXNz IHN1cnByaXNpbmcgZXJyb3IgbWVzc2FnZSBieSBjYXRjaGluZyBpdCBpbiB0aGUgcGFyc2VyLCBP TiBDT05GTElDVCAoY29uZmxpY3RfdGFyZ2V0KSBETyBOT1RISU5HIHdpbGwgZ28gaW50byB0aGUg ZXhlY3V0b3Igd2l0aG91dCB0aGUgbmVjZXNzYXJ5IGNvZGUgdG8gaGFuZGxlIHRoZSBjYXNlLiAg RXhhbXBsZToNCg0KY3JlYXRlIHRhYmxlIHAgKGEgaW50IHByaW1hcnkga2V5LCBiIHRleHQpIHBh cnRpdGlvbiBieSBsaXN0IChhKTsgY3JlYXRlIHRhYmxlIHAxMiBwYXJ0aXRpb24gb2YgcCBmb3Ig dmFsdWVzIGluICgxLCAyKTsgY3JlYXRlIHRhYmxlIHAzIHBhcnRpdGlvbiBvZiBwIChhIHVuaXF1 ZSkgZm9yIHZhbHVlcyBpbiAoMyk7DQoNCmluc2VydCBpbnRvIHAgdmFsdWVzICgxLCAnYScpIG9u IGNvbmZsaWN0IChhKSBkbyBub3RoaW5nOw0KRVJST1I6ICB1bmV4cGVjdGVkIGZhaWx1cmUgdG8g ZmluZCBhcmJpdGVyIGluZGV4DQoNCkF0dGFjaGVkIGlzIGEgcGF0Y2ggdG8gZml4IHRoYXQuICBB Y3R1YWxseSwgdGhlcmUgYXJlIHR3byAtLSBvbmUgdGhhdCBhZGp1c3RzIHRoZSBwYXJ0aXRpb25l ZCB0YWJsZSB0ZXN0cyBpbiBpbnNlcnRfY29uZmxpY3Quc3FsIHRvIGhhdmUgYSBwYXJ0aXRpb25l ZCB1bmlxdWUgaW5kZXggYW5kIGFub3RoZXIgdGhhdCBmaXhlcyB0aGUgY29kZS4NCg0KSSBzdXBw b3NlIHdlJ2QgbmVlZCB0byBhcHBseSB0aGlzIHRlbXBvcmFyaWx5IHVudGlsIHdlIGZpeCB0aGUg T04gQ09ORkxJQ1QNCihjb25mbGljdF90YXJnZXQpIGNhc2UgdG8gYmUgYWJsZSB0byB1c2UgcGFy dGl0aW9uZWQgaW5kZXhlcy4NCg0KVGhhbmtzLA0KQW1pdA0K