| Villiam Manera 2005-05-06, 8:24 pm |
|
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?
---------------------------(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
|