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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--yrj/dFKFPuw6o+aM
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Sun, Oct 30, 2005 at 12:23:00PM -0800, Theodore Petrosky wrote:
[...]

Everything indicates that you have an iso-8859-1 `e with acute' there.
So whatever went wrong, it was at (or before) dump time.

Regards
-- tom=E1s

--yrj/dFKFPuw6o+aM
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQFDZaAcBcgs9XrR2kYRAlr9AJ0XTC/dX+TRFsTFtpEvc5mfds5fkwCfR3pG
cEP3z7RR1EaYUSNsvmwwQGk=
=xVXw
-----END PGP SIGNATURE-----

--yrj/dFKFPuw6o+aM--