The following bug has been logged online:
Bug reference: 1652
Logged by: Villiam Manera
Email address: vmanera@manord.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?