Re: Query returns no results until REINDEX

On Tue, Feb 11, 2020 at 8:33 PM Peter Geoghegan <pg@bowt.ie> wrote:
>
> 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.

FTR, this is something being actively worked on [1], and I still hope
that in pg13 a glibc or ICU upgrade will be detected and raise proper
warning.

[1] https://commitfest.postgresql.org/27/2367/