rihad <rihad@xxxxxxx> writes: > On 07/12/2017 01:54 PM, Albe Laurenz wrote: >> As you see, your index is still sorted according to the C collation >> and scanning it returns wrong results. > This ordering issue can certainly be classified as an inconsistency, but > nothing to lose sleep over. Is this all that is normally meant when > saying "index corruption"? Laurenz neglected to point out that if the index isn't sorted the way that the system assumes it is, then searches may fail to find values that are present (due to descending into the wrong subtree), and by the same token insertions may fail to enforce uniqueness. That's pretty corrupt in my book. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
