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

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

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: <pgsql(at)mohawksoft(dot)com>
Cc: "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-02 12:07:23
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB34101AE48@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
> Hmmm, snipped from your reply was the explain plan from the query
where it
> was clear you were using two different character data types: bpchat
and
> text. That, alone, may have been a problem.
> Looking at your defaults, did you do:
> initdb --locale=C somepath

I reran initdb --locale=C yesterday and that fixed the problem.  Since I
am doing the nightly win32 builds I run initdb each night around 1am and
I missed the locale warning.  I had a feeling it was something like
this.  The part I don't understand is why psql was saying the locale
(show lc_ctype) was 'C' when pg_controldata was not.  This, along with
recent code revisions tricked me for a while (not to mention the default
locale being changed).

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.
The real settings are of course built into the database itself.  This
stuff is all new to me, I've never really had to deal with locales
before.

> Personally, I think, if I do not specify a locale, I don't want a
specific
> locale. Period. I haven't been paying too close attention to the
hackers
> list to say when this happened, but it bit me a couple times.

I now accept this as dogma :)

Merlin

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-06-02 13:33:53
Subject: Re: ACLs versus ALTER OWNER
Previous:From: John HansenDate: 2004-06-02 10:23:00
Subject: Re: ACLs versus ALTER OWNER

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2004-06-03 00:12:27
Subject: Re: Compiling libpq with VisualC
Previous:From: Harald MassaDate: 2004-06-02 09:36:50
Subject: have a wiki for postgresql.win32

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