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 1p801M-0000zq-TY for pgsql-general@arkaria.postgresql.org; Wed, 21 Dec 2022 14:24:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p801L-0002Cc-Pu for pgsql-general@arkaria.postgresql.org; Wed, 21 Dec 2022 14:24:35 +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 1p801L-0002CS-EZ for pgsql-general@lists.postgresql.org; Wed, 21 Dec 2022 14:24:35 +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 1p801I-0000Zw-Vu for pgsql-general@lists.postgresql.org; Wed, 21 Dec 2022 14:24:35 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1671632671; bh=4tG3+yo4ReMsnMBGBBBFnx7PulASgRPSCglB8PjbPuY=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=XT8Wy0dCdLffSFlq896Yciw6xgw21ooS6pWqblQVCdOap7uZqpclI5j2LVdPBuocw nmBQRT0l4JJ5Hzg3GMTSQbIlCGZuztKaLakt53WR1XyWeUXpDD8Kb9U+QGBnzfXC/r V7zYPRSYyLPKrtnrp18mCCJLbJ0wEJJW6l0RE+ui5aLewOCaCAIg1hOurqg9R6J3Rt 66mVtH9fbFipUqWQRAKkkA+RIVDMClEG3xCdd+98Dm8xsTFGA/GE+JnhUwXS5PK7Lv nKPeog6dHfAiw5wA+ZMStTim9GtLQ+BULCdHqZIOa0JEt+0LYhQNxXD+sqOeVqcuRE df4ayKgpDQYhQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.190.232.80]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1N4QsY-1oiNzt0ZQE-011OFh for ; Wed, 21 Dec 2022 15:24:31 +0100 Received: from ncq by hermes with local (Exim 4.94.2) (envelope-from ) id 1p801G-0004gy-9x for pgsql-general@lists.postgresql.org; Wed, 21 Dec 2022 15:24:30 +0100 Date: Wed, 21 Dec 2022 15:24:30 +0100 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: 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: <9aec6e6d-318e-4a36-96a4-3b898c3600c9@manitou-mail.org> 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:qzMHOvVi5+ev8avVxEtotNyvkjN2Q6kV367UnuSsN6PECmLvRkc djk6McG5SbaLgGEyjAgdbewIsveMIou08YwebopMVA6ci19cmaxzgEtBGl4j6PwLDLww4cG 7jFMhBvI+gRIG6QAXTK2gib0plQWFjY3s4WOZ8QeoFw2OLlXirxJxqJ2YaWqfkR3/EHU16i 27VfvNb+xzMsTJlVgXklQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:V08mxKFvFYw=;DPhc8DuKDMY4468HnjLEqSOI0ds tcb3X6SkAQbpJWVDdVOLkSYa/KjMn+b7meimtYFZSlc63bsLlsNnQy1dTfvsRuX0XrGVP2PjV wOHWbcTDh3JtiOO9oRTjTTtaQ1yG/bq6LSClX7Z/Ro1yH/PZ9crr87nZTHFujtggMApjB+usm 8pjEYgSieMaOhbPI/XKygmT7oH0Q1NyugM3RMSpOEalqr6LK1+FpRzO3mTTngWY2sPORQ996/ EtYVrN4EEzV/b/ekHBORzM9TCS5yAe+hSeDorWBadonPB7E9VAMrvUbSi1+w36qRhSEgT1/mz CUW1pTP08o5eDv0/6LLZqEHg6B6ZzdgRiYDgeCBS1W1Lh2X9xKhF99FMGpQAID9xIDFiWhNdh UHJsjki5+DF7w1MMtgA4fidZ7CU6KToXhTZcDk+up+ejRzR8eQxPqgX6M0KRKTElKo7K2aUeT rktF9OI81MyNfrFoSPlfOkghzeXKR2GCTOoPXKpSxNsdVBKIiRV2PciwvxEHL1eRaE+tMz/fz inNZ24J5O4gRG1dqIJ//T6sFOAMntj9A23x1Z1fXUbHTg+wMu42luAQCwLxazXpXYpxs+TwHY n126/Xd7oocDbWACGRQfUhQEdOYR6AhTtAPbrM9z2PxueTTF2Zqt3QhtNeNIvG/yP2TbzPg2/ Pxvh+GLkJ8/VnfocswRclakzMgnFZwc+9z5EpQUzuI7VNNKzVvE3vlBHMPv2NYRaEWbTea3tv s9efnMyICOeZ73dDQOgd6Bo0DyXS7AAcFbWTx/E8EwJgc682kOI5qD2X8nodaLPaa0bg0a+eK YG8CGKAJ7g3cJsVAsb37jQfQr+g5YZCs1yDxZSd75otIGaAmIGVVDNK/qWMPr0uDy+tOqAEeq I7eJP5Rb1wEFn9U6Dx0oswkirfs62F8Zx0yLqpDBDkngP45NzBrfKnVShzLkexo16FxPpgSpX QK7sJQ== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Dear all, I managed to drop the "special" collations default, C, and POSIX with OIDs 100, 950, 951. Is there a way to recreate them (short of restoring a backup) ? Naive attempts with create collation do not seem to work out. Thanks, Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B