From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: dropped default locale
Date: Wed, 21 Dec 2022 15:46:48 +0100
Message-ID: <Y6McWL3ZI3VXCccj@hermes.hilbert.loc> (raw)
In-Reply-To: <d42f31908c77654da888f722708b7786cc332800.camel@cybertec.at>
References: <Y4yQ6pJuuCQ1w1xI@hermes.hilbert.loc>
<9aec6e6d-318e-4a36-96a4-3b898c3600c9@manitou-mail.org>
<Y6MXHsEr0eDHexcs@hermes.hilbert.loc>
<d42f31908c77654da888f722708b7786cc332800.camel@cybertec.at>
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
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: Karsten.Hilbert@gmx.net, laurenz.albe@cybertec.at
Subject: Re: dropped default locale
In-Reply-To: <Y6McWL3ZI3VXCccj@hermes.hilbert.loc>
References: <Y4yQ6pJuuCQ1w1xI@hermes.hilbert.loc> <9aec6e6d-318e-4a36-96a4-3b898c3600c9@manitou-mail.org> <Y6MXHsEr0eDHexcs@hermes.hilbert.loc> <d42f31908c77654da888f722708b7786cc332800.camel@cybertec.at> <Y6McWL3ZI3VXCccj@hermes.hilbert.loc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox