The following bug has been logged online: Bug reference: 5361 Logged by: Alexender Email address: bav...@mail.ru PostgreSQL version: 8.4 Operating system: Ubuntu server 9.10 (Karmic) Description: KOI8U issue Details:
This is real problem. Dump from Postgres 8.2 can't be restored in Postgres 8.4 if I use on server 8.2 encodings KOI8 and --lc-collate and --lc-ctype uk_UA.KOI8-U Because conversion is not supported between KOI8R and KOI8U and dump 8.2 have string "SET client encodigs KOI8" which KOI8R in 8.4 but I need in postgres 8.4 "SET client encodigs KOI8U" in dump file because i used --lc-collate and --lc-ctype = uk_UA.koi8-U. [Solved] The only way I solve it change in plain/text dump string on "SET client encodings KOI8U" and use database in koi8U encoding with --lc-collate and --lc-ctype = uk_UA.koi8-U. But it's dfficult to change it in large file. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs