Re: Some regression tests are failed RH7.0

Lamar Owen <lamar.owen@wgcr.org> writes:
> Tom Lane wrote:
>> Can't tell a thing from that amount of detail.  What's in
>> regression.diffs?

> It appears to be the locale deal, Tom.  It hits a little too familiar of
> a chord (and pattern).  If we analyze his regression.diffs, we'll see
> lots of collation stuff, as well as money format stuff, I'd wager.

I suspected as much, but didn't want to leap to a conclusion without
seeing the diffs.

> The fix is to set the locale to C.  Editing /etc/sysconfig/i18n to set
> either LANG=C or LC_ALL=C.  Or simply delete it and reboot.

Note also that if you change the postmaster's locale you'd better redo
initdb.

BTW, it occurs to me that we don't have anything about locale issues in
the documentation about interpreting the regression tests.  Will fix.

			regards, tom lane