Re: Query returns no results until REINDEX - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: Query returns no results until REINDEX
Date
Msg-id CAH2-WzmC9w1UD3GwTQUi38LhjfyszFC_f--_xp2vUMhKVVbYEw@mail.gmail.com
Whole thread Raw
In response to Re: Query returns no results until REINDEX  (Colin Adler <colin@coder.com>)
Responses Re: Query returns no results until REINDEX  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-general
On Sun, Feb 9, 2020 at 12:50 PM Colin Adler <colin@coder.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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Pre-version pg_upgrade syntax check
Next
From: Julien Rouhaud
Date:
Subject: Re: Query returns no results until REINDEX