The following bug has been logged online: Bug reference: 1976 Logged by: Stanislav Sukholet Email address: [EMAIL PROTECTED] 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 [EMAIL PROTECTED]: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=171174 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster