Re: COPY..FROM question on 7.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY..FROM question on 7.3
Date
Msg-id 5539.1043884908@sss.pgh.pa.us
Whole thread Raw
In response to COPY..FROM question on 7.3  ("Patrick Hatcher" <PHatcher@macys.com>)
List pgsql-general
"Patrick Hatcher" <PHatcher@macys.com> writes:
> Trying to import a 4 column tab delimited file into Pg 7.3.  As it stands,
> the last line contains only the first two columns.  I would expect that the
> import would only update the first two column like it did in  Pg 7.2.x.
> However, I get an error message Missing data from column "X".
> Is there something I can do to avoid the message?

Yes, fix the data file ;-).  This was deliberately tightened in 7.3 to
detect the sorts of obscure mistakes that the old behavior allowed to
slip by ...

            regards, tom lane

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Problem starting postmaster at startup
Next
From: "Patrick Hatcher"
Date:
Subject: Re: COPY..FROM question on 7.3