pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (5+ messages)  latest in thread

Message-ID: <Y6McWL3ZI3VXCccj@hermes.hilbert.loc>
Permalink:  ../Y6McWL3ZI3VXCccj@hermes.hilbert.loc/
Also on:    postgresql.org/message-id/Y6McWL3ZI3VXCccj@hermes.hilbert.loc

 · 

reply

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