Problem with pg_dump/pg_restore or pg_dump/psql

From: Yanik Crépeau <yanik(dot)crepeau(at)exScriptis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Problem with pg_dump/pg_restore or pg_dump/psql
Date: 2003-09-30 18:15:20
Message-ID: 007301c3877e$cee7e980$6401a8c0@DINSPIRON
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pg_dump version: 7.3.4
pg_restore version: 7.3.4
psql version: 7.3.4

I try to use the various scenarios proposed in the pg_dump man page to dump
one database and restore it on another machine. In all case, I have got an
error during the restore process (psql -d xxx -f yyy or pg_restore).

I have checked very carefully where such an error happens and I have
discovered that it is only when psql or pg_restore reaches a record
containing a character with an accent (like é, è, à etc etc.). It does not
fail systematically, but chance to have a failure are very high if:

a) a record contains more characters with accents than just one or
b) the character with an accent is at the end of the field

If I pad a field with space characters ('Crépeau ' instead of
'Crépeau'), that could fix the problem but I suspect the end result will
miss some blank characters.

Oh, by the way, all my databases are encoded with UNICODE.

Yanik

Yanik Crépeau "homo sum, humani nihil a me alienum puto"
Montréal QC
PGP 0xD5EF5EF1/2047: 7AB063B5 CAAA60CA 573ED213 7E4B9EB4
PGP 0xD1F892EF/2048: 9754F2BEA6B788C578F9C547E986596AD1F892EF

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeffery Read 2003-10-01 14:00:17 strange problems...
Previous Message Bruce Momjian 2003-09-29 18:53:19 Re: bug in clusterdb script