Re: [HACKERS] copy

>
> Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it> writes:
> > I have a strange behavior while copying from a text file, I don't know
> > if this will be considered a bug or a feature.
> > Seems that COPY expects that last field is 20 char long and if it is
> > less than 20 it becomes crazy.
>
> I cannot replicate this bug with 6.4. What version are you using?

I can, but it isn't a bug! At least not one in the backend.

The file must contain CRLF at the end of a line instead of a
single LF.

The data is absolutely intact in the database including the
CR for those lines, where the second fields value is shorter
than 20 chars. It's just psql(1) who's output get's mangled
up.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #