"Merlin Moncure" <[EMAIL PROTECTED]> writes: > 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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org