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
In response to
pgsql-admin by date
|Next:||From: Dronamraju Rajesh||Date: 2000-09-12 13:15:27|
|Subject: gzip, gcc, gmake utilities to install POSTGRES on solaris ???|
|Previous:||From: Tim Quinlan||Date: 2000-09-11 23:26:56|
|Subject: Re: backup/restore|
pgsql-bugs by date
|Next:||From: Ronald Kuczek||Date: 2000-09-12 07:51:16|
|Subject: Failed to compile on Win32 with --enable locale|
|Previous:||From: Tom Lane||Date: 2000-09-11 16:10:32|
|Subject: Re: nested implicit selects (views) go wrong |
pgsql-sql by date
|Next:||From: Zeljko Trogrlic||Date: 2000-09-12 10:51:59|
|Subject: Re: Tree structure|
|Previous:||From: Darrin Ladd||Date: 2000-09-12 01:15:31|
|Subject: Re: How can I select all of the tables with field name 'area'?|