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 1n6wNg-0004bQ-M7 for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Jan 2022 15:14:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n6wNf-0007Ed-I9 for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Jan 2022 15:14:43 +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 1n6wNf-0007ET-79 for pgsql-hackers@lists.postgresql.org; Mon, 10 Jan 2022 15:14:43 +0000 Received: from mail-pj1-x1033.google.com ([2607:f8b0:4864:20::1033]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n6wNd-0000Va-4Q for pgsql-hackers@postgresql.org; Mon, 10 Jan 2022 15:14:42 +0000 Received: by mail-pj1-x1033.google.com with SMTP id pj2so12632222pjb.2 for ; Mon, 10 Jan 2022 07:14:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=V5/mjtOg65fYWQPzIdWB2OKHsjhp786TMNUTgM+az80=; b=Uq4t4S+IqDMq+SoCGea0N9ZJokPTJBV6Z08LkZNYuaa2fRt5P3nZuVGXIq3vy+ne5H 4/Iq09she6g0t524DtXTIO7+qydIiivSC1MXMfJuQyttiAP3Bmnsn5ytlZLGNc6M40Q3 eR2xqvMr0aJ0R5SUSGREJO3WqM3IQi8nObGStSG60wtTSrAeQ3JQZeAsTyu86gXLLwJp VmLn8+EfUUyb5qau79pQzyauZTKQ0DtWUCiqmJHS5kKLitDD444tScAyZGsUeEfdzLMQ uzo3xJLol7PUOMgIOfW8nnk/AdZVIrmMNp6Fs6LgazyANhw+hb4KRAeWriXqa5OtEnpa SYew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=V5/mjtOg65fYWQPzIdWB2OKHsjhp786TMNUTgM+az80=; b=qVhkdYpTNcUQi6nzHOR1p0tBHSXjy46itaWJNw05QlTA+GUabmdXD8KgUeEjom13ij QKAbRFretpzM+MpwmhgJb++n3qM2JdBRfLya2Z61S+NpXPJ+x8G3ZWu00jFabTDj4PFA xCP4YNtkl/APRkGZP0/tnPNiUPBVlfF22H9cWYKFaIKzAX+1bQA0W/Ur8LL7SGNr36kt HytslP3PGEMTIBXKSN7EHgA7fM26iwMF3juaauikIABEF0oshYRfzVISU3fU0k1xRi98 Hj0gFU2hYEmU15fJ6Si09xXtLpP4tsBE8T8nGYP1sKe/lV9ClOLSJBhafLYWPgVXZLoA jI9w== X-Gm-Message-State: AOAM533ysCCVMRQYsUHuHGSwlg314umy+Q47I9F10mHTVWm/tjGZc8kK kWCn7mUo4HNqUfnLLDDCVdw= X-Google-Smtp-Source: ABdhPJyXS8abOZJRLJGl/ijhyKrxhOv+l/izgL0mZgvZux/eB3/Ri7ARWzI2Ao+gUqj4P5aFXan2zw== X-Received: by 2002:a17:902:854a:b0:149:6297:e90 with SMTP id d10-20020a170902854a00b0014962970e90mr72257850plo.58.1641827678009; Mon, 10 Jan 2022 07:14:38 -0800 (PST) Received: from jrouhaud (1-171-174-202.dynamic-ip.hinet.net. [1.171.174.202]) by smtp.gmail.com with ESMTPSA id i4sm9129232pjj.30.2022.01.10.07.14.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 10 Jan 2022 07:14:37 -0800 (PST) Date: Mon, 10 Jan 2022 23:14:31 +0800 From: Julien Rouhaud To: Daniel Verite Cc: Peter Eisentraut , Pgsql-Hackers Subject: Re: ICU for global collation Message-ID: References: <7a784a83-7187-449b-b58e-e389668e9221@manitou-mail.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7a784a83-7187-449b-b58e-e389668e9221@manitou-mail.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Jan 10, 2022 at 03:45:47PM +0100, Daniel Verite wrote: > > By that I understand that CREATE DATABASE is limited to copying a template > database and then not write anything into it beyond that, as it's > not even connected to it. Yes. > I guess there's still the possibility of requiring that the ICU db-wide > collation of the new database does exist in the template database, > and then the CREATE DATABASE would refer to that collation instead of > an independent locale string. That could work. However if having the collation in the template database a strict requirement the something should also be done for initdb, and it will probably be a bigger problem.