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 1p80N1-0002MD-Va for pgsql-general@arkaria.postgresql.org; Wed, 21 Dec 2022 14:46: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 1p80N0-0001jl-Md for pgsql-general@arkaria.postgresql.org; Wed, 21 Dec 2022 14:46:58 +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 1p80N0-0001jV-Cm for pgsql-general@lists.postgresql.org; Wed, 21 Dec 2022 14:46:58 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p80Mu-0000mI-7R for pgsql-general@lists.postgresql.org; Wed, 21 Dec 2022 14:46:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1671634010; bh=yRNyXc1yIpUjeRZusGQn09oe8WcH5m9JvHofzWFa3EM=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:References:In-Reply-To; b=hE0P3cPTiYh2ckv6vLnAbxuHA1MziBQDvdgPrmwPN7SWsspq39ey2D/4E9TElYN5v TUZhG5zd2O/Ih11AHrzcd6r8q6ehAI3yEcVss9UfOeddVv8bXOucZzzco2RAD2GJm1 eFFcCVJKZF0vSld/8KdyHXbeIE/nkhMrL+4Yr/JFPn8OvfelmPbaACFo3Z9CsNab1N D4CJDlaXjOZQFgoWFM90Gi0HFEtaboOfoQF8SJtdWtrcfPYAnfNuRi+qIM5u0h67VG yUxfpalvQl8Nu6Qfwbs+l/amM4qjbPDLxTy50tOHURct5DvgFPED3t/dwEeaeQa41Y fiMo5iq82patA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.190.232.80]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MyKHc-1oyHXa0ZLw-00yfTL; Wed, 21 Dec 2022 15:46:50 +0100 Received: from ncq by hermes with local (Exim 4.94.2) (envelope-from ) id 1p80Mq-0005Bm-QQ; Wed, 21 Dec 2022 15:46:48 +0100 Date: Wed, 21 Dec 2022 15:46:48 +0100 From: Karsten Hilbert To: Laurenz Albe Cc: pgsql-general@lists.postgresql.org Subject: Re: dropped default locale Message-ID: References: <9aec6e6d-318e-4a36-96a4-3b898c3600c9@manitou-mail.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:rh/0KMXk5QiRUmB+BCdj1HjCKA1CrDkJNGWWUQzBH44s86qMPSX e16Fj59+qYGNjC7kr+IXT1If/0JciJ+VDNFXyteQv22rLcdOCXEYnode9NCo6futztAqRMq hB+0twIOX20rAHkElVFvhVLIBkidZyWAxWHj3jQESyB9fjAb4SouzPuIkXKOlMNNmYbL3uY ySuvp+UCEcHhqoJZeB62A== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:KzZ6ASWNDQc=;VX4KBZuOwztRMm+yPw3mjzL1+TH eppCSqW6AnqfgZq/15097iTUpqCNSjF/wZOA2ZWFSiZLoVfUdWtC7vJbDotGtBBWiPoZMe+Ju p0qzzbd4InYK5VHlFb8ld34EDDgEiEbR+EGYbVuJ5ee8o4GTFg5hT/XUjm8e3op7/wg+2T73r zSnkceeeYTh+g6kuPqgTzY6DdRfMPQc25snjrmdOKVl3THQ+g8p4VW1f+AZ5AlKlAyeh5SYoi R71S0ReKhKyzHHZcUmNaGx1RFWX8yptAYHTgyCVxcKrYWMTP4/EaFFLY0NY7OkrIZUoqBGuva 93nVVwsNF/Qun07EeHNDEuIkwaydnJROzYg+wLiRaHjWzYnk3dnky5vHSM7XPXjtxAGt/l8hO +JpjQdeqsUTXTMsMq9zO+qItlT63zeSv0KyGTUtVI9ljQJTAhmWm07GfI+hdI9K4nUwgvUEcm m/0w0A4wP0EATlw5riRf4WaQI6edCseYvopYYV2YTCgkjpfSY6gFB3NRPG6P5Y4POIoJ9U4T1 EbsgG388M/RvCWG9eE22gXG2VqGnhHpziHBW4mAASyOwEyD3lLvlktZUypdrlOLkIjxiaUyCd tpecfTWpUDdQvo9OoRc8yM3UDP6zOl8RVkWXIIY+ece+nvUTwCosppcjHtdjqNkHBBDcVXltk O+12Nsvy4VP85IE0Nsifo8Zo8wdGBO1B7iVH4IbUG7Iw7CszCzhsJZjJXLcWC3O1Jioy1o+Gz G8E91Y4viozQJj/Dezbc12GBlHqd/o91U0zVXyEHHg1b08vfyQnw05rj2hMN7h12eRkpb9G1A QnKRBLMAptPeoW3MTsYODIRjDwnHBHDshjtNXB5t5o0YRkhyd1NR6I6MlhdJNd9v9vryfn6H9 7oxKB9K2OyrkxTEZ1LCkNz5DBDGHHNvDJ1KSh6FUgn3MhpMjcPj6iXcVYrnoFagEd0tbGTQHy 7tagqZJcNcyQuE4oL3hijH0wpyU= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Wed, Dec 21, 2022 at 03:41:24PM +0100 schrieb Laurenz Albe: > I would definitely go for the backup, but here is how you can > create these three rows in PostgreSQL v15: > > INSERT INTO pg_collation > (oid, collname, collnamespace, collowner, collprovider, > collisdeterministic, collencoding, collcollate, collctype) > VALUES > (100, 'default', 11, 10, 'd', TRUE, -1, NULL, NULL), > (950, 'C', 11, 10, 'c', TRUE, -1, 'C', 'C'), > (951, 'POSIX', 11, 10, 'c', TRUE, -1, 'POSIX', 'POSIX'); Many thanks ! I wasn't so sure whether inserting appropriate rows would be equivalent to create collation... (pg_collation might have been a view projecting inner workings of the server engine). Thanks, Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B