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

Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug?

From: Max Pyziur <pyz(at)panix(dot)com>
To: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-bugs(at)hub(dot)org, mturczan(at)nyp(dot)org
Subject: Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug?
Date: 2000-09-12 03:03:26
Message-ID: Pine.NEB.4.21.0009112256500.6647-100000@panix2.panix.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugspgsql-sql

On Mon, 11 Sep 2000, Lamar Owen wrote:

> Max Pyziur wrote:
> > I dropped my databases, uninstalled the 7.0.2-2 rpms and installed 6.5.3 rpms on
> > my development RH6.2 Linux 2.2.14-5.0 system and I still get the anomalous query
> > result on that box.
> 
> This is a RedHat 6.2 locale problem.  Set LC_COLLATE=C and see if that
> fixes things.

That didn't do it.  But I'll tell you what did give me the
(original) results for which I was looking.  Looking through the various
*rc files which get called in the stock RH6.2 installation I saw that
there was a /etc/profile.d/lang.sh file (for bash shells) and lang.csh
(for csh shells).  I moved the lang.sh to lang.sh.bak (since the login
initialization script looks for /etc/profile.d/*sh files), shutdown
postmaster and restarted and now I'm getting the results I got before.

The thing which I'm concerned about is doing a 'env | sort' doesn't show
any of the LC_xxx variable settings.  Nor does 'echo $LC_COLLATE'.  What
command can I use to "expose" these settings to make sure that I don't
run into a similar situation?

Much thanks to you and tom lane (in his ferlinghetti way) for helping me
out of this one (at least to get the original results I had).
 
> --
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11
> 


Max Pyziur                                     BRAMA - Gateway Ukraine
pyz(at)brama(dot)com                                  http://www.brama.com/


In response to

pgsql-admin by date

Next:From: Dronamraju RajeshDate: 2000-09-12 13:15:27
Subject: gzip, gcc, gmake utilities to install POSTGRES on solaris ???
Previous:From: Tim QuinlanDate: 2000-09-11 23:26:56
Subject: Re: backup/restore

pgsql-bugs by date

Next:From: Ronald KuczekDate: 2000-09-12 07:51:16
Subject: Failed to compile on Win32 with --enable locale
Previous:From: Tom LaneDate: 2000-09-11 16:10:32
Subject: Re: nested implicit selects (views) go wrong

pgsql-sql by date

Next:From: Zeljko TrogrlicDate: 2000-09-12 10:51:59
Subject: Re: Tree structure
Previous:From: Darrin LaddDate: 2000-09-12 01:15:31
Subject: Re: How can I select all of the tables with field name 'area'?

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