| From: | "Alexender" <bavcom(at)mail(dot)ru> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5361: KOI8U issue |
| Date: | 2010-03-04 07:31:45 |
| Message-ID: | 201003040731.o247Vj1a007355@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5361
Logged by: Alexender
Email address: bavcom(at)mail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ALEX | 2010-03-04 10:55:14 | BUG #5362: WARNING could not determine encoding |
| Previous Message | Bruce Momjian | 2010-03-03 23:37:51 | Re: Cache lookup failure for index during pg_dump |