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 1m2u4i-0005VR-Jv for pgsql-admin@arkaria.postgresql.org; Mon, 12 Jul 2021 11:26:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m2u4g-0002gp-VT for pgsql-admin@arkaria.postgresql.org; Mon, 12 Jul 2021 11:26:10 +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 1m2u4g-0002gh-KP for pgsql-admin@lists.postgresql.org; Mon, 12 Jul 2021 11:26:10 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m2u4d-0001XK-KB for pgsql-admin@lists.postgresql.org; Mon, 12 Jul 2021 11:26:10 +0000 Received: by mail-wm1-x334.google.com with SMTP id w13so11165073wmc.3 for ; Mon, 12 Jul 2021 04:26:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=icgIJUrf0Yhiaa57qKWfJVD9qTHUJgoEV/GlUUT2JmA=; b=V3TZ8tTFZaBtZG6xjGjb1Nrl+qFNyE1ScPKE8xwgnzRZ9Y5yWS5Ni3QJJ8MAD/41an c9X0kMZn3MEYvee3nv+A2+5qkFWRlmoHGhZEizcIEEn1BcqcYxk3sb9DXsDm9n3+wPcA 4MCFvQ6FAPZyL/lO9YKQDvsILvY5PkR9E9jeeKweSZVlFtOwfnilphncYs61M+RrLTBE a5OXz59iBQitKWy2VV/DOIdo0G4fCPP+SOB1tZ2D3d3LWh2XVoytH7JuF2CWsxjDCGwh DZn9k/VrmfVTHx0sOdcRpdBAc8o/i4dM7oaYVfEH4O7LaYdGNhQT+qg9MsR8EpPxQL+s BZpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=icgIJUrf0Yhiaa57qKWfJVD9qTHUJgoEV/GlUUT2JmA=; b=bpkCvYW2Ao1fUaxbW6ZSfPLXZr2ciC8PTCBMCc9jAoKHpAT2IR9JNTu1e9HVl2xCPO aAjF7PyTgyAWUUGiFRYgZmk20q7keoV7/4siJa8Qy0hwWfvtmojqMDEvnicoPpDtk48i evC2Xsw8vJ3wfW/yVCC/xTMy1DgZuTlQEfwnU7lpEjKzACn4ih8sillSsSbQUiYKU3dw a8ppMqWMapVZpKTKsrD66EnSkHty9Z8pWmSQekKUkixuEs6P5P7yzJM4BiphFM2Tfcom mTuw6C6vKeKSkYwI2HJGUuko4JRpu8DkBoAMK1M3GJTZtG2kF7L1WTmRs9xNTQ5G0tNu FXOQ== X-Gm-Message-State: AOAM530154vfT+RCklbw3JT7IKpBJW2yagJRvfcS56gZbfkf2EgU2sFZ b/aeNd2A/gciCtvBMWkTRJeooA== X-Google-Smtp-Source: ABdhPJyo+RePSs0Kqp1+OnK9oU58IffFVy8y18u6tAtHAVUtJRkEKKxK4tafi/9Wr4EE/yAGiBhnZQ== X-Received: by 2002:a7b:c4d9:: with SMTP id g25mr13628250wmk.108.1626089165246; Mon, 12 Jul 2021 04:26:05 -0700 (PDT) Received: from localhost.localdomain (217-149-171-247.nat.highway.telekom.at. [217.149.171.247]) by smtp.gmail.com with ESMTPSA id b16sm10953307wrw.46.2021.07.12.04.26.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 12 Jul 2021 04:26:05 -0700 (PDT) Message-ID: Subject: Re: Lc_collate & lc_type? whitespace and nbsp unique index... From: Laurenz Albe To: Ilmir Mulyukov , pgsql-admin@lists.postgresql.org Date: Mon, 12 Jul 2021 13:26:04 +0200 In-Reply-To: <1897c8dce7fd6974116c935a50270b33fac09461.camel@cybertec.at> References: <1897c8dce7fd6974116c935a50270b33fac09461.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk UGxlYXNlIGluY2x1ZGUgdGhlIGxpc3QgaW4geW91ciByZXBsaWVzLgoKT24gTW9uLCAyMDIxLTA3 LTEyIGF0IDEzOjA3ICswNjAwLCBJbG1pciBNdWx5dWtvdiB3cm90ZToKPiBMYXVyZW56LCB0aGFu ayB5b3UgZm9yIHlvdSBoZWxwLgo+IAo+IGthX2ltX3BnPSMgc2VsZWN0ICogZnJvbSBfaW5mb3Jn MzE0NDAgd2hlcmUgX0ZsZDMxNDQxPSdXMTkwM0JQIFdJTktPRCDQmtC+0LvQvtC00LrQuCDQtNC4 0YHQutC+0LLRi9C1LCDQv9C10YDQtdC00L3QuNC1JzsKPiBfZmxkMzE0NDEgfCBfZmxkMzE0NDIg fCBfZmxkMzE0NDNycmVmIHwgX2ZsZDIxMDIKPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLSstLS0tLS0tLS0tCj4gVzE5MDNCUCBXSU5LT0Qg0JrQvtC70L7QtNC60Lgg0LTQuNGB 0LrQvtCy0YvQtSwg0L/QtdGA0LXQtNC90LjQtSB8IHwgXHg4MGU5YTRiZjAxMDA5OWI1MTFlYmQz ZDAwYzg5ZjVmMiB8IDAKPiBXMTkwM0JQIFdJTktPRCDQmtC+0LvQvtC00LrQuCDQtNC40YHQutC+ 0LLRi9C1LCDQv9C10YDQtdC00L3QuNC1IHwgNzk2IHwgXHg4MGU5YTRiZjAxMDA5OWI1MTFlYmM5 OGNmNjgyMjVkMiB8IDAKPiBXMTkwM0JQIFdJTktPRCDQmtC+0LvQvtC00LrQuCDQtNC40YHQutC+ 0LLRi9C1LCDQv9C10YDQtdC00L3QuNC1IHwgfCBceDgwZTlhNGJmMDEwMDk5YjUxMWViYzUwNTY2 MTBkZWRmIHwgMAo+IFcxOTAzQlAgV0lOS09EINCa0L7Qu9C+0LTQutC4INC00LjRgdC60L7QstGL 0LUsINC/0LXRgNC10LTQvdC40LUgfCA3OTYgfCBceDgwZThhNGJmMDEwMDk5YjUxMWViYWUwMmE4 MTcyOWMwIHwgMAo+ICg0IHJvd3MpCj4gCj4gIFV0ZiBlbmNvZGUgZm9yIDEgYW5kIDMgcm93Ogo+ ICAKPiBceDU3XHgzMVx4MzlceDMwXHgzM1x4NDJceDUwXHgyMFx4NTdceDQ5XHg0ZVx4NGJceDRm XHg0NFx4MjBceGQwXHg5YVx4ZDBceGJlXHhkMFx4YmJceGQwXHhiZVx4ZDBceGI0XHhkMFx4YmFc eGQwXHhiOFx4MjBceGQwXHhiNFx4ZDBceGI4XHhkMVx4ODFceGQwXHhiYVx4ZDBceGJlXHhkMFx4 YjJceGQxXHg4Ylx4ZDBceGI1XHgyY1x4MjBceGQwXHgKPiBiZlx4ZDBceGI1XHhkMVx4ODBceGQw XHhiNVx4ZDBceGI0XHhkMFx4YmRceGQwXHhiOFx4ZDBceGI1Cj4gCj4gXHg1N1x4MzFceDM5XHgz MFx4MzNceDQyXHg1MFx4MjBceDU3XHg0OVx4NGVceDRiXHg0Zlx4NDRceGMyXHhhMFx4ZDBceDlh XHhkMFx4YmVceGQwXHhiYlx4ZDBceGJlXHhkMFx4YjRceGQwXHhiYVx4ZDBceGI4XHhjMlx4YTBc eGQwXHhiNFx4ZDBceGI4XHhkMVx4ODFceGQwXHhiYVx4ZDBceGJlXHhkMFx4YjJceGQxXHg4Ylx4 ZDBceGI1XHgyY1x4Cj4gMjBceGQwXHhiZlx4ZDBceGI1XHhkMVx4ODBceGQwXHhiNVx4ZDBceGI0 XHhkMFx4YmRceGQwXHhiOFx4ZDBceGI1CgpJIGRvdWJ0IHRoYXQ6CgpDUkVBVEUgVEFCTEUgY3ly aWxsaWMoaWQgaW50ZWdlciBQUklNQVJZIEtFWSwgdCB0ZXh0KTsKCklOU0VSVCBJTlRPIGN5cmls bGljIFZBTFVFUyAoMSwgY29udmVydF9mcm9tKCdceDU3MzEzOTMwMzM0MjUwMjA1NzQ5NGU0YjRm NDQyMGQwOWFkMGJlZDBiYmQwYmVkMGI0ZDBiYWQwYjgyMGQwYjRkMGI4ZDE4MWQwYmFkMGJlZDBi MmQxOGJkMGI1MmMyMGQwYmZkMGI1ZDE4MGQwYjVkMGI0ZDBiZGQwYjhkMGI1JywgJ1VURjgnKSk7 CklOU0VSVCBJTlRPIGN5cmlsbGljIFZBTFVFUyAoMiwgY29udmVydF9mcm9tKCdceDU3MzEzOTMw MzM0MjUwMjA1NzQ5NGU0YjRmNDRjMmEwZDA5YWQwYmVkMGJiZDBiZWQwYjRkMGJhZDBiOGMyYTBk MGI0ZDBiOGQxODFkMGJhZDBiZWQwYjJkMThiZDBiNTJjMjBkMGJmZDBiNWQxODBkMGI1ZDBiNGQw YmRkMGI4ZDBiNScsICdVVEY4JykpOwoKU0VMRUNUICogRlJPTSBjeXJpbGxpYyBXSEVSRSB0ID0g RSdXMTkwM0JQIFdJTktPRFx1MDBBMNCa0L7Qu9C+0LTQutC4XHUwMEEw0LTQuNGB0LrQvtCy0YvQ tSwg0L/QtdGA0LXQtNC90LjQtSc7CgogaWQg4pSCICAgICAgICAgICAgICAgICAgICAgdCAgICAg ICAgICAgICAgICAgICAgIArilZDilZDilZDilZDilarilZDilZDilZDilZDilZDilZDilZDilZDi lZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDi lZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZAKICAyIOKUgiBX MTkwM0JQIFdJTktPRCDQmtC+0LvQvtC00LrQuCDQtNC40YHQutC+0LLRi9C1LCDQv9C10YDQtdC0 0L3QuNC1CigxIHJvdykKClNFTEVDVCAqIEZST00gY3lyaWxsaWMgV0hFUkUgdCA9IEUnVzE5MDNC UCBXSU5LT0Qg0JrQvtC70L7QtNC60Lgg0LTQuNGB0LrQvtCy0YvQtSwg0L/QtdGA0LXQtNC90LjQ tSc7CgogaWQg4pSCICAgICAgICAgICAgICAgICAgICAgdCAgICAgICAgICAgICAgICAgICAgIAri lZDilZDilZDilZDilarilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDi lZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDi lZDilZDilZDilZDilZDilZDilZDilZDilZDilZAKICAxIOKUgiBXMTkwM0JQIFdJTktPRCDQmtC+ 0LvQvtC00LrQuCDQtNC40YHQutC+0LLRi9C1LCDQv9C10YDQtdC00L3QuNC1CigxIHJvdykKClBl cmhhcHMgeW91IGdvdCBhIGNvcnJ1cHRlZCBpbmRleCBvbiB0aGUgIl9mbGQzMTQ0MSIgY29sdW1u LgpEb2VzIHJlaW5kZXhpbmcgdGhhdCBpbmRleCBjaGFuZ2UgdGhpbmdzPwoKWW91cnMsCkxhdXJl bnogQWxiZQotLSAKQ3liZXJ0ZWMgfCBodHRwczovL3d3dy5jeWJlcnRlYy1wb3N0Z3Jlc3FsLmNv bQ0K