BUG #1652: pg_restore failed

From: "Villiam Manera" <vmanera(at)manord(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1652: pg_restore failed
Date: 2005-05-06 16:46:20
Message-ID: 20050506164620.2F999F0B03@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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?

Browse pgsql-bugs by date

  From Date Subject
Next Message Guilherme 2005-05-06 19:37:22 BUG #1653: Bug in date
Previous Message Peter van der Meer 2005-05-06 15:15:40 BUG #1651: static date field is not recognized automatically when group by is used