I have some additional information that points to an
encoding problem. I pulled the COPY sql from the dump
file for the table that didn't get inserted properly
and tried to run just that section (with psql -f). I
got this error:
psql -f bibent_data.sql HRS
psql:bibent_data.sql:1: ERROR: copy: line 15, Invalid
UNICODE character sequence found (0xc876)
psql:bibent_data.sql:1: lost synchronization with
server, resetting connection
I'm running on FreeBSD 4.5. Is there a way I need to
recode the file before running it?
Paul Warner wrote:
> I've looked for this in the books and archives and
> haven't been able to find an answer.
> I did a pg_dump on an older postgres database (I
> believe it's 7.0.something), and restored to 7.2.1
> with multibyte capability. The old db is not
> multibyte. What's happened is that there are a
> significant number of rows in the dump file that are
> not getting loaded into the new database. The tables
> are getting there, but not the data.
> I notice that there are triggers added in 7.2 that
> don't appear in the earlier version (as in: Triggers:
> RI_ConstraintTrigger_1663276). I don't know if this
> is related, but it is true that all the 952 messages
> related to a certain topic didn't make it into one
> This strikes me as a version issue related to
> integrity constraints, but could it be related to the
> change to multibyte?
> I'm working on FreeBSD 4.5, with aolserver and openacs
> Thanks very much for your help!
> Paul Warner
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
In response to
pgsql-admin by date
|Next:||From: Michael P. Dobmeier||Date: 2002-06-19 15:01:54|
|Subject: Some questions regarding authentication (via pg_hba.conf password pwfile)|
|Previous:||From: Paul Warner||Date: 2002-06-19 14:55:03|
|Subject: pg_dump and restore problem (7.0.? to 7.2) more info|