importing from 8.0.3 unicode problem

Поиск
Список
Период
Сортировка
От Theodore Petrosky
Тема importing from 8.0.3 unicode problem
Дата
Msg-id 20051030202300.21581.qmail@web33205.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: importing from 8.0.3 unicode problem  (tomas@tuxteam.de (Tomas Zerolo))
Список pgsql-bugs
I don't know if this is a bug or my not understanding
something.

I installed 8.1beta4 on a machine (mac os x 10.4.2). I
have my pg_dump file from my running 8.0.3 server in
the office (os x 10.3.9).

I created a cluster with: initdb --encoding-UNICODE
/path/to/dir

then createdb databasename

psql databasename </path/to/pg_dump/file

I get an error:
ERROR:  invalid UNICODE byte sequence detected near
byte 0x8e
CONTEXT:  COPY ioinfo, line 177, column publication:
"Elle D?cor"
ERROR:  invalid UNICODE byte sequence detected near
byte 0xa5
CONTEXT:  COPY jobinfo, line 523, column
shortdescription: "RUSH!       KA - White lace shirt

this is the top of my pg_dump file:

--
-- PostgreSQL database dump
--

SET client_encoding = 'UNICODE';
SET check_function_bodies = false;
SET client_min_messages = warning;


this is the line in question...
972    SC1511    Elle Décor    November '04        f


I don't understand  why I am having a problem
importing this datadump.

Ted




__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Fwd: Bug#325114: Postgres Rolling back for no reason
Следующее
От: tomas@tuxteam.de (Tomas Zerolo)
Дата:
Сообщение: Re: importing from 8.0.3 unicode problem