Re: Very strange query difference between 7.3.6 and 7.4.6

>>
>>
> Well I definately did a initdb --no-locale
>
> 34 bin/initdb -D cdata --no-locale
>
> But I didn't specify LC_COLLATE or LC_CTYPE explicitly.
>
> I did set LANG="C" in /etc/sysconfig/i18n however.

Just to be specific...

show all from psql:

lc_collate | C
lc_ctype | C
lc_messages | C
lc_monetary | C
lc_numeric | C
lc_time | C

Sincerely,

Joshua D. Drake

>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>> regards, tom lane
>>
>>
>
>
>------------------------------------------------------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL