| From: | Theodore Petrosky <tedpet5(at)yahoo(dot)com> |
|---|---|
| To: | pgsql -bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | importing from 8.0.3 unicode problem |
| Date: | 2005-10-30 20:23:00 |
| Message-ID: | 20051030202300.21581.qmail@web33205.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roddi Walker | 2005-10-31 02:34:00 | BUG #2010: COPY command does not recognise UTF-8 text files with leading BOM |
| Previous Message | Tom Lane | 2005-10-30 16:01:48 | Re: Fwd: Bug#325114: Postgres Rolling back for no reason |