Re: [pgsql-hackers-win32] select like...not using index - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [pgsql-hackers-win32] select like...not using index
Date
Msg-id 16836.1086236304@sss.pgh.pa.us
Whole thread Raw
In response to Re: [pgsql-hackers-win32] select like...not using index  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-hackers
"Merlin Moncure" <merlin.moncure@rcsonline.com> 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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql-server: Adjust our timezone library to use pg_time_t (typedef'd
Next
From: Tom Lane
Date:
Subject: Re: Indices pinned in pageable RAM?