On 5 March 2019 18:54:33 CET, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> 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
