On 07/12/2017 09:31 PM, Tom Lane wrote:
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
Wow. It sure is.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
