BUG #5361: KOI8U issue

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.

Responses

Browse pgsql-bugs by date

  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