>> Here is what I think happened (this might be a bug, might not): Each >> night I run initdb but I use a special postgresql.conf which is >> optimized for quick data loading. This is copied over the >default one >> after the server is started. This contains the locale >information which >> is 'initialized by initdb'. These were still 'C' because >this file was >> generated before the default locale was changed. psql shows this >> information when you ask it for the locale info even if it is >> incorrect. > >I don't believe this for a minute. lc_ctype and lc_collate can *not* >be set from postgresql.conf. Try it.
It certainly doesn't. There still was a bug with the locale stuff, though - the GUC variable was not set in the child processes. So "show lc_collate" would *always* return "C", for example. attached patch fixes this. //Magnus
locale_guc.patch
Description: locale_guc.patch
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend