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@postgresql.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@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL