The following bug has been logged online:

Bug reference: 1652
Logged by: Villiam Manera
Email address: vmanera (AT) manord (DOT) com
PostgreSQL version: 8.01
Operating system: linux
Description: pg_restore failed
Details:

from pgAdminIII i've created a backup
and then I've try to restore it but:

pg_restore: ERROR: value too long for type character(40)
CONTEXT: COPY conti, line 24410, column descr_1: "2) crediti immobilizzati
verso societÃ? d"

in the descr_1 column instead of ... verso societÃ* d..


This is due at un initially wrong encoding, but anyway now this character is
inside the database.. and pg_restore count 41 instead of 40 character.

I'm novice in postgres, perhaps there is some way to work around it? or is a
bug?

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