| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Colin Adler <colin(at)coder(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Query returns no results until REINDEX |
| Date: | 2020-02-11 19:32:35 |
| Message-ID: | CAH2-WzmC9w1UD3GwTQUi38LhjfyszFC_f--_xp2vUMhKVVbYEw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Feb 9, 2020 at 12:50 PM Colin Adler <colin(at)coder(dot)com> wrote:
> Looks like it found something. I checked out the contrib/pageinspect docs but
> wasn't too sure what to run. Are incompatible libc versions causing btree
> corruption something you consider a bug? If it's something you'd like to look
> into further I can gladly send over the database files.
No, this is not considered a bug.
It's unfortunate that there is no built in collation versioning
mechanism, or something like that -- that might have alerted you to
the problem before any real damage occurred. We have that for the ICU
collations, but it currently isn't possible to use ICU as the default
collation provider. You really have to go out of your way to use ICU
collations.
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julien Rouhaud | 2020-02-11 20:13:41 | Re: Query returns no results until REINDEX |
| Previous Message | Adrian Klaver | 2020-02-11 17:44:59 | Re: Pre-version pg_upgrade syntax check |