Alex Krohn <alex(at)gossamer-threads(dot)com> writes:
> I added to the startup file:
> LANG=C
> LC_CTYPE=C
> LC_NUMERIC=C
> LC_TIME=C
> LC_COLLATE=C
> LC_MONETARY=C
> LC_MESSAGES=C
> LC_ALL=C
Seems reasonable. It's possible you needed "export" commands in there
too, but I wouldn't have thought so (anything coming in from the outer
environment should be exported already).
> After this, my create test and select still produced the same error. Ugh.
Hm, maybe I'm barking up the wrong tree. Let's try a direct test.
What do you get from
select 'a_b'::text < 'ac'::text;
select 'A_B'::text < 'ac'::text;
On my machine, these produce 't' in C locale, but 'f' in en_US locale.
regards, tom lane