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
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 |