Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: pgsql(at)mohawksoft(dot)com,"PgSql-Win32" <pgsql-hackers-win32(at)postgresql(dot)org>,pgsql-hackers(at)postgresql(dot)org, "Magnus Hagander" <mha(at)sollentuna(dot)net>
Subject: Re: [pgsql-hackers-win32] select like...not using index
Date: 2004-06-03 04:18:24
Message-ID: 16836.1086236304@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-06-03 05:03:42
Subject: Re: Indices pinned in pageable RAM?
Previous:From: Tom LaneDate: 2004-06-03 03:40:55
Subject: Re: pgsql-server: Adjust our timezone library to use pg_time_t (typedef'd

pgsql-hackers-win32 by date

Next:From: Andreas PflugDate: 2004-06-03 08:10:10
Subject: Re: Compiling libpq with VisualC
Previous:From: Bruce MomjianDate: 2004-06-03 00:12:27
Subject: Re: Compiling libpq with VisualC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group