Hi Tom,
> >> What does EXPLAIN VERBOSE select * from foo where a like 'Test/%';
> >> show?
>
> Well, the indexqual is just what it should be for C locale:
>
> :indxqual ((
> { EXPR :typeOid 16 :opType op :oper
> { OPER :opno 1061 :opid 1052 :opresulttype 16 } :args (
> { VAR :varno 1 :varattn
Hi Tom,
> Alex Krohn <[EMAIL PROTECTED]> writes:
> >> On my machine, these produce 't' in C locale, but 'f' in en_US locale.
>
> > Seem to be in C locale:
>
> So it does. Okay, what was the complete test case again?
> I'm afraid I
Hi Tom,
> >> So it does. Okay, what was the complete test case again?
> >> I'm afraid I didn't save your original message because I wrote it off
> >> as a known problem ...
>
> > Here it is:
>
> > links=# create table foo ( a char(25) );
> > CREATE
> > links
Hi Tom,
> > [postgres@penguin pgsql]$ locale
> > LANG=en_US
> > LC_CTYPE="en_US"
> > LC_NUMERIC="en_US"
> > LC_TIME="en_US"
> > LC_COLLATE="en_US"
> > LC_MONETARY="en_US"
> > LC_MESSAGES="en_US"
> > LC_ALL=en_US
> > [postgres@penguin pgsql]$
>
> > Postmaster is running as user pgsql. Any ideas o
Seem to be in C locale:
links=# select 'a_b'::text < 'ac'::text;
?column?
--
t
(1 row)
links=# select 'A_B'::text < 'ac'::text;
?column?
--
t
(1 row)
links=#
Cheers,
Alex
Gossamer Threads Inc. --
Alex KrohnEmail: [EMAIL PROTECTED]
Internet Consultant Phone: (604) 687-5804
http://www.gossamer-threads.com Fax : (604) 687-5806
Hi Tom,
> Alex Krohn <[EMAIL PROTECTED]> writes:
> > links=# select * from foo where a like 'Test/%'
> > links-# ;
> > a
> > ---
> > (0 rows)
>
> This looks like an artifact of the known probl
Hi,
> Alex Krohn <[EMAIL PROTECTED]> writes:
> >> Beware of changing the postmaster's locale on the fly, however,
> >> since that will leave you with corrupted (out-of-order) indexes.
> >> Safest to dump/initdb in new locale/reload.
>
> > Ho
Hi,
> > So I added:
> > LANG=C
> > LC_ALL=C
> > to the /etc/rc.d/init.d/postgres file and stop, restarted the server. I
> > then dropped and recreated the database. However still same results.
>
> LC_COLLATE overrides LC_ALL, I think --- didn't you previously show us
> that all the LC_xxx famil
Is this a bug, am I missing something? If you need any other
system info, please let me know. I did an RPM install on a pretty plain
Redhat 6.2 system.
Please reply to [EMAIL PROTECTED] with any ideas.
Thanks!
Alex
---- Gossamer Threads Inc. --
Alex Krohn
