| From: | Christoph Berg <myon(at)debian(dot)org> |
|---|---|
| To: | Phil Endecott <spam_from_pgsql_lists(at)chezphil(dot)org> |
| Cc: | pgsql-pkg-debian(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Keeping Postgresql-9.6 on Buster |
| Date: | 2019-07-11 19:55:41 |
| Message-ID: | 20190711195519.GB15076@msg.df7cb.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-pkg-debian |
Re: Phil Endecott 2019-07-11 <1562848237936(at)dmwebmail(dot)dmwebmail(dot)chezphil(dot)org>
> OK, I have found this: https://wiki.postgresql.org/wiki/Locale_data_changes
> and your linked email.
>
> Much of my data is just ASCII, or binary blobs, but I think I probably set
> the locales to UTF8. Hmmm.
You are affected as soon as you put an index on a "text" column with
en_US.UTF-8 collation that contains things as simple as "1-1" "1 1".
These will switch ordering, and the old index is corrupt wrt. the new
operating system. Indexes on "bytea" are fine.
> I will probably have more questions, unless I just decide to not upgrade.
> Is this the best place to ask?
Here or on pgsql-general.
Christoph
| From | Date | Subject | |
|---|---|---|---|
| Next Message | apt.postgresql.org Repository Update | 2019-07-17 11:25:48 | periods updated to version 0.03-1.pgdg+1 |
| Previous Message | Phil Endecott | 2019-07-11 12:30:37 | Re: Keeping Postgresql-9.6 on Buster |