Joachim Trinkwitz <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
