Re: [HACKERS] select like...not using index
Tom Lane <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32,gmane.comp.db.postgresql.devel.general |
|---|---|
| Message-ID | <[email protected]> |
"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 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html