Search Postgresql Archives

pg_restore UTF8 problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I ran into a problem while restore a database. I am converting a database from SQLASCII to UTF8. The pg_restore fails with:

pg_restore: ERROR:  invalid UTF-8 byte sequence detected near byte 0xe7
CONTEXT: COPY sl_email_messages, line 119593, column message: "In Reply To:get a life

and terminates. What I would like to happen is for pg_restore to ignore this error and continue on. Is there a way to make it do that?

Tom Burns





---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux