BUG #1328: psql don't accept some valid PGCLIENTENCODING values
The following bug has been logged online:
Bug reference: 1328
Logged by: kaaos
Email address: kaaos@land.ru
PostgreSQL version: 8.0 Beta
Operating system: Linux kaaos 2.6.9 #3 Tue Nov 23 13:12:08 MSK 2004 i686
Intel(R) Celeron(R) CPU 1.70GHz GenuineIntel GNU/Linux
Description: psql don't accept some valid PGCLIENTENCODING values
Details:
Hello!
First of all, sorry for my English :(.
The problem:
With PGCLIENTENCODING=KOI8 and server encoding UNICODE
psql do not starts and print this message:
psql: FATAL: invalid value for parameter "client_encoding": "KOI8"
But, if I unset PGCLIENTENCODING, and in psql enter:
template1=# \encoding KOI8
then psql accept client encoding:
template1=# \encoding
KOI8
template1=# show client_encoding;
client_encoding
-----------------
KOI8
(1 row)
'select version()' output: PostgreSQL 8.0.0beta5
on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3
Thank you.
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
With PGCLIENTENCODING=KOI8 and server encoding UNICODE
psql do not starts and print this message:
psql: FATAL: invalid value for parameter "client_encoding": "KOI8"
Odd ... it Works For Me:
$ PGCLIENTENCODING=KOI8 psql regression
Welcome to psql 8.0.0beta4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
regression=# \encoding
KOI8
regression=#
What locale settings are you using?
regards, tom lane
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
With PGCLIENTENCODING=KOI8 and server encoding UNICODE
psql do not starts and print this message:
psql: FATAL: invalid value for parameter "client_encoding": "KOI8"
Found the problem ... it's something I broke last week :-(. It's fixed
now in CVS tip.
regards, tom lane