Re: Raphael Hertzog > How can we determine if the collation information has changed between > two glibc releases? (cc Aurélien in case he knows)
The problem is, no one knows. Or else PG would already use that info. You could alternatively use the libicu collations, but these have effectively the same problem, just their track record of doing changes is more coordinated. > I understand the correct default action is to reindex all text fields, > but arguably the "template1" and "template0" databases > are mostly empty and likely have only ascii content where the collation > information has no impact (or rather almost 0% chance of having been > modified), so it should still be safe to perform those operations on those > databases no? template0 is always empty, yes. For template1 and postgres, you could just run `reindex database template1;` Christoph
