On 5 March 2019 18:54:33 CET, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>Andreas Kretschmer <andreas@a-kretschmer.de> writes:
>> the other thing is, it would be nice to to know why the index is
>corrupt.
>
>Given that (a) this was triggered by a server migration and (b)
>the leading column of the index looks like it's probably varchar,
>I'm suspicious that the new server has different collation behavior.
>
> regards, tom lane
yes, sounds reasonable.
Regards, Andreas.
--
2ndQuadrant - The PostgreSQL Support Company
--
2ndQuadrant - The PostgreSQL Support Company