Is it me or has the default locale of created databases change at some point?
Currently, on Linux, if one does not specify a locale, the locale is taken from the system environment and it is not "C." While I can both sides of a discussion, I think that choosing a "locale" without one being specified is a bad idea, even if it is the locale of the machine. The reason why it is a bad idea is that certain features of the database which only work correctly with a locale of "C" will not work by default. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend