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

Re: select fails on indexed varchars.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Krohn <alex(at)gossamer-threads(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: select fails on indexed varchars.
Date: 2001-01-26 21:26:59
Message-ID: 3872.980544419@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Alex Krohn <alex(at)gossamer-threads(dot)com> writes:
> 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 family variables were set in your default
environment?  You may need to set (or unset if you prefer) all of 'em.

Also, I'd really recommend an initdb, not the above half-baked approach,
because the above will not fix any problems that the template1 indexes
might have with a changed sort order.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-01-26 23:07:05
Subject: Re: BUG in postgres mathematic
Previous:From: Bruce MomjianDate: 2001-01-26 20:10:02
Subject: Re: JDBC driver throws SQLException while parsing timestamp

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