BUG #1976: steps to reproduce BUG #1438: Non UTF-8 client encoding problem - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1976
Logged by:          Stanislav Sukholet
Email address:      ctac113@mail.ru
PostgreSQL version: 7.4.8.1.FC3.1
Operating system:   2.6.12-1.1378_FC3
Description:        steps to reproduce BUG #1438: Non UTF-8 client encoding
problem
Details:

That was really easy to reproduce:
$ export LANG=ru_RU.koi8r
$ createdb -E UNICODE mydb
$ psql -d mydb
mydb=# \encoding KOI8
mydb=# create table a (aa integer);
CREATE TABLE
mydb=# create table b (bb integer primary key);
ERROR:  ignoring unconvertible UTF-8 character 0xd3cf
mydb=# \d
           Список связей
 Схема  | Имя |   Тип   | Владелец
--------+-----+---------+----------
 public | a   | таблица | postgres
(1 запись)

mydb=#

So, it's always a problem when I put PRIMARY KEY modifier after column
declaration with KOI8 encoding.
I've put this report to bugzilla@redhat:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=171174