Re: Diederik de Haas > > > > HINT: Rebuild all objects in this database that use the default > > > > collation > > > > and run ALTER DATABASE template1 REFRESH COLLATION VERSION, > > > > or build PostgreSQL with the right library version. > > The 'AND run' part of the hint was what brought confusion/doubt for me as it > suggested 2 different things, whereas only the latter was explained/detailed.
"Rebuild all objects" is mostly indexes that use some ordering, but might be a plethora of corner-case-ish things like "CHECK (foo < '1-1')". https://wiki.postgresql.org/wiki/Locale_data_changes has more details. Arguably, the message doesn't say that, but it's hard to squeeze a complex topic into just a few lines. Christoph