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: | Raw Message | Whole Thread | 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 |