The regression test for int8 fails on my system because it does not expect the currency symbol in
test=> select to_char(123, 'L999');
to_char
---------
$ 123
(1 row)
I'm not sure what the problem is. The server is started with LANG="en_US" and all other locale parameters unset
(AFAICT). This is the default
from the RPM startup script, so I don't know what the problem is.
1. Should there be a '$' sign in the en_US language (I guess so?)
2. I have tried to unset the LANG variable in the startup script, and I still get the same output. Is this the "right"
placeto set LANG for the
postmaster application?
3. Is the regression script crazy? ;-)
Help!?
Allan.
expedted/int8.out has (line 236ff)
SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM INT8_TBL;
to_char_13 | to_char
------------+------------------------
| 456.000
| 4567890123456789.000
| 123.000
| 4567890123456789.000
| -4567890123456789.000
(5 rows)
while results/int8.out has
SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM INT8_TBL;
to_char_13 | to_char
------------+------------------------
| $ 456.000
| $ 4567890123456789.000
| $ 123.000
| $ 4567890123456789.000
| $-4567890123456789.000
(5 rows)
bash-2.04$ rpm -qi postgresql
Name : postgresql Relocations: (not relocateable)
Version : 7.1.2 Vendor: (none)
Release : 4PGDG Build Date: Wed 13 Jun 2001 10:18:46 PM BST
Install date: Fri 29 Jun 2001 08:43:51 PM BST Build Host: lowen.wgcr.org
Group : Applications/Databases Source RPM: postgresql-7.1.2-4PGDG.src.rpm
Size : 4426307 License: BSD
URL : http://www.postgresql.org/
Summary : PostgreSQL client programs and libraries.
bash-2.04$ uname -a # RedHat 7.1 US version.
Linux XXXX 2.4.2-2 #17 SMP Tue Jul 3 14:48:45 BST 2001 i686 unknown