Re: Problems with pg_dump (on Debian i386)

Joachim Trinkwitz <jtr(at)uni-bonn(dot)de> writes:
> CREATE TABLE "lplan" (
> ...
> "art" character[] NOT NULL,

I believe that PG 7.1 interprets that field declaration as

"art" character(1)[] NOT NULL,

and then truncates your input to match. 7.2-to-be rejects the input
with complaints like
psql:germdb.sql:20: ERROR: value too long for type character(1)
which is the SQL-specified behavior for char(n) fields.

Since you appear to be using different string lengths in your data,
I doubt char(n) is the right datatype to begin with. I suggest

"art" varchar(n)[] NOT NULL,

for some appropriate n.

regards, tom lane