On 5 March 2019 18:54:33 CET, Tom Lane <t...@sss.pgh.pa.us> wrote: >Andreas Kretschmer <andr...@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
